Session offload
Learn how to configure session offload settings in Exasol SaaS.
The auto scaling feature allows sessions to be automatically offloaded to other (worker) clusters to distribute the load in multi-cluster deployments, based on a scaling policy that you have created in the database.
When a worker cluster is stopped, any sessions on that cluster that were created on the main cluster will automatically be migrated back to the main cluster. Sessions that were initiated on the worker cluster will be terminated.
You can enable offloading for each cluster individually in the cluster settings dialog when you create the cluster, or afterwards through the cluster settings menu. You can also set a timeout value to abort the migration after a certain time.
For more details about the auto scaling mechanism, see Move sessions between clusters.
Prerequisites
-
You must be logged in as a user with the
Owner
role. -
A scaling policy must exist in the database. See Create a scaling policy.
Enable
-
On the Databases page, click on on the desired cluster and select Cluster settings from the dropdown menu.
-
Change the Enable offloading setting as desired.
Optionally, you can change the timeout in minutes for aborting migration of offloaded sessions if the cluster is stopped. A value of 0 (zero) means that the session migration process will not time out.
-
Click on Save to apply the changes, or click on Close to cancel the operation.
