All articles

Getting started with Exasol – A multi node cluster in AWS

As of now, all the previous posts worked with the Community Edition of Exasol. While that is great for getting started quickly (the Community Edition comes with all the features, except multi node support and a(…)

SQL Server AlwaysOn node “Add all eligible storage to the cluster”

I made a mistake recently when adding a new node to an existing Windows Failover Cluster supporting AlwaysOn SQL Server instances. When adding a new node using the GUI there’s this option checked by default named “Add all eligible storage(…)

ODA X8-2-HA cluster issue and NTP configuration

I have been recently deploying some new ODA X8-2-HA. After reimaging and creating the appliance, I had to patch the ODA. The day after, checking status, I could realize that my node 0 was not working as expected. I did(…)

Getting started with Exasol – Backup and restore (2)

In the previous post we did the groundwork for being able to backup the Exasol database to an S3 bucket. We learned that you can do full level 0 backups and of top of that you(…)

YCSB (NoSQL benchmark) on Oracle Database

By Franck Pachot . The NoSQL technologies emerged for Big Data workloads where eventual consistency is acceptable and scaling out to multiple server nodes is an easy answer to increase throughput. With cloud services rising, those key-value document datastores(…)

Setup an NGINX Ingress Controller on Kubernetes

One of the most important and basic concept in Kubernetes is the Service exposition. How about exposing a Kubernetes Service deployed inside a cluster to outside traffic? Let’s have a look on the different approaches to expose a Kubernetes(…)

Getting started with Exasol – Backup and restore (1)

Now that we have a system with a proper network setup we can take a look at how backup and restore works in Exasol. Without being able to restore and recover your database, you for sure(…)

Getting started with Exasol – Installation from ISO

Initially I wanted to write about Backup and Restore of Exasol databases but I quickly ran into issues, and this is the reason why this post is coming first. When you import the Exasol Community OVA as described(…)

CLUSTER

By Franck Pachot . Statistically, my blog posts starting with a single SQL keyword (like COMMIT and ROLLBACK) in the title are not fully technical ones, but about moves. Same here.

Enhancing idql/iapi with rlwrap (part II)

This is Part II of a tour of rlwrap for idql/iapi. For Part I, please follow the link here. Enhanced output visualization This is one rlwrap’s most fantastic enhancement. It is not that different from what I suggested(…)