Add Cluster

This page describes the steps on how to add a cluster to a database in the web console. By default, each database includes a MAIN cluster, and you can configure additional clusters for higher concurrency. For more details, see Horizontal Scaling. The MAIN cluster of a database must be running in order to add a new cluster.

Exasol SaaS Standard edition only supports the MAIN cluster and additional clusters cannot be added. With Enterprise edition you can add two additional clusters for a total of three clusters. If you need more than three clusters, please send a support request. To send a support request, click Help and then click Support. For more information, see Editions Overview.

The optimal cluster size is based on usage patterns. As a rule of thumb, start with a RAM size that corresponds to about 10% of your raw data. For example, if you want to process about 1TB of raw data, then the cluster size Small may be a good starting point. Depending on your workload, you may need a larger cluster to use additional CPU and memory. Sometimes, a smaller cluster may also meet your requirements and be more cost-effective. You can dynamically test which size best fits your needs by resizing a cluster. For more information, see Resize Cluster.

Procedure

  1. In the web console, click Databases Databases.
  2. Click More on the database to which you want to add more clusters and then click Add cluster. The Add cluster screen is displayed.

    3. add new cluster

  3. Configure the following settings for the cluster: 
    • Cluster name: Enter a unique name to identify the cluster. The name can contain letters a-z (lower and upper case), numbers, hyphen, dot, and underscores (_).
    • Cluster size: Choose the cluster size based on your requirements. By default, the cluster size XSmall is selected.

      • Standard edition only supports XSmall - Large cluster sizes. Enterprise edition supports all cluster sizes. For more information, see Editions Overview.

    • Auto-Stop settings: To save unwanted charges, by default, all clusters are automatically stopped after being idle for two hours. You can change or turn off these settings. For more information, see Change Auto-Stop Settings.

  4. Check that the estimated hourly, weekly, and monthly costs for your cluster meet your expectations. If needed, you can change the cluster size and see the new estimated costs.

  5. Click Add cluster to add the cluster to the database.

View Cluster(s)

Click the Show Clusters drop-down button on the database to view all the clusters configured to that database. If you have recently added a cluster to a database, this cluster's status is Creating until it is ready to use. Depending on the cluster size and storage, it can take several minutes before the database is available for use. The Running status means a cluster is ready to use.

Add more cluster

Cluster Actions

You can click More next to your cluster to perform the following actions: 

More cluster actions

  • Run SQL: Opens a browser-based worksheet connected to the cluster. For more information, see Worksheets
  • Connect via tools: Provides you with the options to connect to the cluster with an SQL client or BI tool of your choice, or to any other tool supporting JDBC or ODBC drivers. For more information, see Connect via Tools.
  • Stop cluster: Stops the running cluster. If the cluster you stop is the MAIN cluster, this will stop the database and all the clusters for this database. For detailed steps, see Start and Stop All Clusters.
  • Auto-Stop settings: To save unwanted charges, by default, all clusters are automatically stopped after being idle for two hours. You can change or turn off these settings. For more information, see Change Auto-Stop Settings.
  • Resize: Provides you with the options to resize the selected cluster. For more information, see Resize Cluster.
  • Rename:This lets you rename the selected cluster. For more information, see Rename Cluster.
  • Delete cluster: This lets you delete the selected cluster. If the cluster is the MAIN cluster, you cannot delete it, and the Delete cluster option is disabled. For detailed steps, see Delete Cluster.

Cluster Details

To view details about the cluster, click the information icon.

  • vCPU: The number of vCPUs is set by the size of the cluster you selected when you created the cluster. For example, if you selected an X-Small cluster size, the cluster will have eight VCPUs.

  • Memory: The amount of memory is set by the size of the cluster you selected when you created the cluster. For example, if you selected an X-Small cluster size, the cluster will have 64GB of memory.

  • Cluster ID: The ID generated by SaaS when you created the cluster.

  • Auto-Stop: The number of minutes until an idle cluster stops. For more information, see Change Auto-Stop Settings.

  • Connection string: The connection string to SaaS generated when you created the cluster.

  • Port: The port used for the connection to SaaS. The default port is 8563.

  • User name: The user name of the user that created the cluster.