Session Offload

This section describes how to configure session offload settings for an Exasol SaaS database cluster.

The auto scaling feature in Exasol allows sessions to be automatically offloaded to other clusters to distribute the load over the clusters in multi-cluster deployments. 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.

When a worker cluster is stopped, the sessions on that cluster will automatically be migrated to the main cluster. You can set a timeout value to abort the migration after a certain time.

For more information about auto scaling, see Move Sessions Between Clusters.

Prerequisites

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

Enable

  1. On the Databases page, click on More on the desired cluster and select Cluster settings from the dropdown menu.

    cluster settings

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

    enable offloading

  3. Click on Save to apply the changes, or click on Close to cancel the operation.