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

SAP SQL Anywhere, on-demand edition 1.0 SP 6 » Tenant databases » Tenant database mirroring and read-only scale out systems

Adding a read-only scale-out database copy

Set up a tenant read-only scale-out system.

Prerequisites

You must have:

  • A cloud server created for every scale-out database copy that you add to your read-only scale-out system. The major and minor version of each cloud server must match the cloud server version of the primary database.

  • The AlterTenantMirroring privilege.

The database cannot be an autostart database.

Context

Read-only scale-out involves creating numerous read-only scale-out database copies of a tenant mirroring system or read-write database.

A cloud server can run only one copy of a specific tenant database.

Procedure

  1. In the Cloud Console, navigate to the Mirror & Scale-out panel of the tenant database.
  2. In the Scale-out Database Copies table, click Create, and follow the instructions.

Results

A read-only scale-out database copy is created. As a result, you now have a tenant read-only scale-out system.