As long as you are planning to store backups internally in the cluster, it is possible to get a good sizing estimate from the Hardware Configuration Wizard by entering only the basic settings. The Wizard assumes default values for the advanced settings.
|Raw Data Volume (GB)||The volume of the uncompressed data, comparable to the size your data would be if stored as CSV files.|
The EXASOL database always compresses the data. To estimate the volume of compressed data, you enter an expected compression factor.
Without a Proof of Concept, it is difficult to know what the compression factor for your data will be, but a good approach is to assume a moderate compression factor of 2,5 (this is the default value in the Hardware Configuration Wizard).
|Required DB RAM Ratio||The required database RAM expressed as a percentage of the raw (uncompressed) data volume.|
|Cluster Internal Backup|
Backups can be stored within the cluster on remote servers (e.g. FTP).
Please note, that only backups stored within the cluster can be restored in so called "non-blocking mode", effectively leading to immediate restore of your database.
If the basic settings do not cover your requirements - for example, you expect high index volumes or you want to turn on auditing - then you should use the Advanced Settings.
Select Hardware Configuration
Based on the input parameters you entered, the Hardware Configuration Wizard suggests several hardware configuration options. This is done using Skyline algorithm, which provides you with a buffer based on your input parameters, but also suggests the most cost-efficient options available.
If you have a specific requirement regarding the number of active nodes you require, you can enter the number in the Active Nodes field and click Refresh.
Once you have selected a hardware configuration, click Print PDF to produce a document summarizing your input parameters and selected hardware. You can contact EXASOL with this information to discuss the next steps.
Database RAM and Maximum Database RAM
For an EXASOL implementation, you receive a license based on the DB RAM that you request. This means that you can only assign up to this amount of RAM to a database.
The Max DB RAM in the Setup Selection screen shows the maximum database RAM that you could upgrade your system to, depending on the hardware configuration you select. If you want to ensure that you have sufficient processing scalability for your system, you should select an option that allows a suitable maximum database RAM.
Even though the hardware configuration you select might be capable of more database RAM, you would still need to purchase an additional license to utilize RAM over the amount that you are licensed to use.