All articles

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(…)

Enhancing idql/iapi with rlwrap (part I)

The rant I have a confession to make: I’m obsessed with idql/iapi. These tools so central to Documentum administrative tasks are so lame for interactive work that they have probably disgusted more than their share of administrators. The problem is(…)

Automatic column formatting in Oracle sqlplus

Column formatting was always a pain in sqlplus when writing queries on the prompt. Most people use tools like SQL Developer or Quest TOAD which can scroll horizontally when running queries against a database, but as a consultant you are(…)