Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere, on-demand edition 1.0 Support Package 3 » SAP Sybase SQL Anywhere, on-demand edition 1.0 » Tenant databases

 

Balancing database load on cloud servers

Load balance the tenant databases in your cloud to redistribute database copies running on overloaded cloud servers to cloud servers that have less activity. Load balancing can be used when you want the cloud to select the appropriate cloud servers for the tenant database copies.

Prerequisites

You must have the MoveDatabase privilege.

Load balancing cannot move the following database copies:

  • The read-write database copy in a read-only scale-out system.

  • The mirror database copy if the primary is not running.

  • The primary database copy if:

    • There is more than one copy for the database.

    • There is a mirror and both the primary and mirror are not running.

Context and remarks

If one or more of your cloud servers is overloaded, then the performance of your cloud can be negatively affected.

Load balancing primary and mirror database copies can cause tenant connections to be dropped. Moving database copies can put extra load on the tenant databases involved.

 Task
  1. In the Cloud Console, navigate to the cloud Overview panel.

  2. Click Load balance databases and follow the instructions.

Results

The specified database copies are moved in a way to avoid overloaded cloud servers where possible. If the load is already balanced and all of the copies specified are located on the specified target cloud servers, then nothing is moved.

 See also