Exasol leads the categories Performance, Platform Reliability and Support Quality for Analytical Database products. And we get a 100% recommendation score from the 782 customers in the survey.

https://uhesse.files.wordpress.com/2020/08/check.png?w=150 150w, https://uhesse.files.wordpress.com/2020/08/check.png?w=300 300w" sizes="(max-width: 554px) 100vw,

Data Vault is just too slow?

You think Data Vault is a great model but you struggle with query performance?

Use Exasol as a Platform!

We have the remedy: Use our analytical database Exasol as a platform and query performance problems with Data Vault disappear.

What’s the problem with Data Vault?

The Data Vault model comes with an increased number of tables and joins. Other data warehouse platforms likely have a problem to deliver acceptable query performance with that.

Exasol solves that problem!

Exasol on the other hand is very good with joins even on many tables. We use columnar storage and we always compress data. And our database is designed to do MPP with commodity hardware.

With these attributes, combining Data Vault with Exasol delivered the best query performance for that model already using earlier versions of Exasol. And for a very reasonable price, if I may add that.

Isn’t it nice if you can make an impact with your tweets and posts? That’s what I thought today while investigating our online learning registrations.
As you may know, Exasol offers free online learning – recently also combined with free certification. We have also recently changed our course curriculum to better suit customer demands.

Together with very many IT people being in home office, that all leads to quite high numbers in registrations to our online learning platform called Exacademy: 617 in 2020 so far.

That’s many for a still quite small training & certification department like ours, and we couldn’t possibly educate that many customers with instructor-led courses.

Today, I looked at the Exacademy registrations per day:

This is the second part of the mini-series Exasol on AWS. Here’s the first part.

Cloud UI is an extension to EXAoperation that makes it easy for you to

• Scale up & down
• Increase storage capacity
• Scale out by adding nodes to the cluster

Cloud UI can be reached by adding the port number 8835 to the URL of your License Server and uses the same credentials as EXAoperation.

Scale down to m5.large with Cloud UI

Depending on the load you get on your Exasol cluster, you can scale up your data nodes to more powerful EC2 instances if load is high and scale down to less expensive EC2 instances with lower user demands.

I started my little cluster with r5.large instances. Now I want to scale down to m5.large. Enter Cloud UI:

It’s amazingly easy to run an Exasol Cluster on Amazon Web Services (AWS).

Subscribe Exasol in AWS marketplace

After having registered and having logged in to your AWS account, go to the AWS marketplace and search for Exasol:

Adding a cluster node will not only increase the available storage capacity but also the total compute power of your cluster. This scale-out is a quite common operation for Exasol customers to do.

My example shows how to change an existing 2+1 cluster into a 3+0 cluster. Before you can enlarge the database with an active node, this node has to be a reserve node first. See here how to add a reserve to a 2+0 cluster. Of course you can add another reserve node to change from 3+0 to 3+1 afterwards. See here if you wonder why you may want to have a reserve node at all.

Initial state – reserve node is present

I start with a 2+1 cluster – 2 active nodes and 1 reserve node:

https://uhesse.files.wordpress.com/2019/09/vboxvshyperv.png?w=150&h=8

After having installed a 2+0 Cluster in Hyper-V, now let’s expand that to a 2+1 Cluster.

Add the node as a VM first

Add another VM in Hyper-V with the same attributes as the existing two data nodes n11 and n12 and name it n13:

• 2500 MB memory, not dynamically extending
• Legacy network adapter, connected to edu-cluster-interconnect
• Network adapter, connected to edu-public-network
• Boot order with legacy network adapter first
• Two hard disk of type VHDX with max. size 100 GB

Give it a static MAC for the Legacy Network Adapter 08:00:27:58:03:21 and a static MAC for normal Network Adapter 08:00:27:71:27:26 and make sure they do not conflict with other existing MAC addresses in your environment.

After having installed Hyper-V, an ISO file with the Exasol software needs to be downloaded. The 2+0 cluster consisting of two data nodes and one license server needs a host machine with at least 8 GB memory and 60 GB free disk space. I do it on my Windows 10 notebook with 16 GB memory. This is for educational purposes of course and not suitable for production use.

2+0 means two active nodes and no reserve node. A reserve node can be added later, expanding the environment to a 2+1 cluster.

We’ll start adding two virtual switches to be able to connect the network adapter of the VMs to them later.

Create Hyper-V Switches for Private and Public Network of the cluster

Click the Virtual Switch Manager in Hyper-V Manager: