Add Database

This article explains how to add a new Exasol SaaS database.

Exasol SaaS Standard edition supports up to two databases, while with the Enterprise edition you can add up to five databases. If you need more than five databases, contact support. For more information, see SaaS Editions Overview.

Prerequisites

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

Procedure

  1. On the Databases page, click on Add database.

    add database

  2. Choose a database type. If you want to accelerate your BI by replicating data into an Exasol database, choose Espresso. For more advanced use cases, choose Enterprise.

    espresso options enterprise options

  3. Select the AWS region where the database will be deployed. If you are unsure, select the region that is closest to your location.

  4. For Espresso, the new database will be named EspressoDatabase. For Enterprise, you can enter a name for the new database. You can change the name later for both database types.

  5. For Espresso, select the maximum data size that you will require for the database. The application will then choose the appropriate instance size for the main cluster. The cluster will be named MainCluster.

    For Enterprise, choose an instance type for the cluster from the dropdown menu. You can also set a name for the cluster.

    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 TiB 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.

  6. If desired, set a timeout value for the Cluster auto-stop feature, which automatically stops the cluster after a period of inactivity. The default value is 120 minutes. You can also disable the auto-stop feature.

    Disabling the auto-stop feature may result in increased cloud resource usage.

  7. When you have set the options for your database, click on Add database. You will be redirected to the Databases page in the web console.

    Database view

    The database and cluster will be in Creating status until they are ready for use, then the status will be shown as Running. The creation process will take about 15 minutes to complete. You will receive an email when your database is ready for use.

    Database running