Database Essentials
Exasol databases must be stored in EXAStorage data volumes. You must therefore create at least one data volume before you can create a database. For more information, see Volumes Overview.
Only one database can actively use a volume. Even though it is possible to create multiple data volumes and multiple databases using these volumes in the same Exasol cluster, this is not recommended for production systems.
Assign nodes
Upon adding a database with EXAoperation, all nodes designated for that database – usually all available cluster nodes – are being assigned to the Node list. That means active nodes as well as reserve nodes.
The number of active nodes entered into the second field must match the number of master nodes of the assigned data volume (v0000 in the example). The Runtime disk (d002_data in the example) will be used to store logfiles, tracefiles etc. of that database.
Assign DB RAM
The amount of RAM that can be assigned to the database is limited by the license and the available RAM on the cluster nodes. It is recommended to leave 10% of the server’s RAM for the operation system of the node.
Example:
4+1 Cluster with node RAM of 100 GiB for each node.
That makes 400 GiB in total for the active nodes.
10% = 40 GiB subtracted leaves 360 GiB of available RAM.
The purchased license allows for 300 GiB -> Assign 300 GiB for the database.
Status “Not created”
After adding the database it is initially showed as Not created in EXAoperation.
Select the action "Create"
From the dropdown menu on the database page, select the action Create.
