Resize Cluster

This section describes how to resize an Exasol SaaS database cluster.

Resizing a cluster means changing the compute power and RAM to optimize concurrency, also referred to as vertical scaling. For more information and use cases, see Database scalability.

You can resize a running or stopped cluster.

  • If you resize a running cluster, the cluster will automatically restart when you apply the change. If the cluster you are resizing is the MAIN cluster, the database and all clusters will be restarted. This means that the database will be unavailable during the scaling operation.

  • If you resize a stopped cluster you must start it manually after applying the change. For more information, see Start and Stop a Cluster.

Prerequisites

You must be logged in as a user with the Owner role.

Procedure

  1. On the Databases page, click on More on the desired cluster and select Resize from the dropdown menu.

    rename cluster

  2. Choose a new instance type for the cluster from the dropdown menu.

    The optimal cluster size for an Exasol database is based on usage patterns. As a rule of thumb, start with a RAM size that corresponds to about 10 percent of the size of your raw data. For example, if you want to process about 1 TB of raw data, the cluster size Small may be a good starting point.

    Depending on your workload, you may need a larger cluster size to use additional CPU and memory. Sometimes, a smaller cluster may however also meet your requirements and be more cost-effective. You can dynamically test which size best fits your needs by resizing a cluster.

    Verify that the estimated hourly, weekly, and monthly cost for your cluster meets your expectations. If needed, change the cluster size to see the new estimated cost.

  3. Click on Resize cluster to apply the changes, or click on Close to cancel the operation.