Licenses
This section describes the licensing for Exasol databases.
Exasol provides a Raw Data license based on your contract with Exasol and your business requirements. The license specifies the maximum size of raw data that you can store across all databases in the cluster. This is the default license type.
The raw data volume corresponds to the data volume that is comparable to the size the data would have if stored as CSV files. If you exceed the licensed capacity, you cannot import any additional data unless you delete the data inside the database.
Audit data is not counted towards the raw data license limit.
For more details about how raw data size is determined, see Sizing for Data Types and Object Types.
For more information about licensing, contact your account manager or Exasol support.
Exasol previously offered a license type that specified the total amount of RAM that could be assigned to the databases in the cluster. This license type is now deprecated.
License limits
Exasol periodically checks the size of the data. If the size limit exceeds the value specified in the license, the database does not permit any further data insertion until the usage drops below the specified value.
To check the limits of your license in EXAoperation, select Configuration > Software > License.
License limits on data storage size apply to all databases in your system. If one database has a license problem, all database instances will be affected.
Audit data is not counted towards the license limit.
Restricted mode
If the data storage limit in the license is exceeded, all databases will enter a restricted mode that affects the following statements:
- IMPORT
- INSERT
- CREATE TABLE AS
- MERGE
- SELECT INTO
In restricted mode, any attempt to execute one of these statement types will result in an SQL exception:
[R0010] Statement currently not allowed because latest cumulative database
raw sizes of 10.6 GiB exceeded raw size license limit of 10.0 GiB (106.2%).
Please increase your license or delete some data and FLUSH STATISTICS.All the statements mentioned above are blocked in restricted mode, even those that would not result in an actual insertion of data (MERGE and SELECT).
Monitoring
The following table lists the different warning and error messages you will see in the EXAoperation Monitoring section when the license limit is exceeded:
| Alert type | Trigger | Description |
|---|---|---|
| Warning | When the cumulative data size reaches a certain percentage of the license value (default is 85%). |
A Warning is displayed when the license limit has reached 85% of the value. Once the warning limit is reached, the databases still permit data inserts, but a warning is displayed that the databases are close to the license limit. Example: License Warning: Databases raw sizes of 8.7 GiB is close to the license limit of 10.0 GiB (86.5%). At 105% databases will no longer permit data insertion. |
| Error | When the data size reaches 105% of the license value. |
An Error is displayed when the license limit is exceeded. No further inserts are permitted in all databases. Inserts are permitted again only when the usage drops below 100%. Example: License exceeded: Databases raw sizes of 10.6 GiB exceed license limit of 10.0 GiB (106.2%). Databases no longer permit data insertion. |
| Notice | When the data size drops below 100% of the license value. |
A Notice is displayed when the license limit drops below the license value. Example: License OK: Database raw size is O.K. again (96.2%). Databases permit data insertion. |
The warning threshold value for your license limit is configurable. You can configure this in EXAoperation.
Recommended actions
If you have exceeded the limits in your license, clear some large data (DROP or DELETE tables) and perform FLUSH STATISTICS to update the current database sizes. Make sure that you clear sufficient data to bring the volume below 100% of the license limit.
To view information on database sizes, check the EXA_DB_SIZE_LAST_DAY table. To view information on license events, check the EXA_SYSTEM_EVENTS table.
Because the license limit is checked periodically, it may take a few minutes for a database to recognize the changes and leave restricted mode.
License models for cloud deployment
Pay as you go (PAYG)
The pay as you go (PAYG) license model is a flexible and scalable license model for deployment of Exasol on a cloud platform. With the PAYG model, you pay for your cloud resources and Exasol software through the cloud platform’s billing cycle. You can always change your setup later to scale up or down your system, and the billing changes accordingly.
For pricing information, refer to the following resources:
Bring your own license (BYOL)
BYOL licensing has been deprecated and is no longer offered for Exasol 7.1 cloud deployments. Existing licenses are not affected and will continue to be valid.
