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

Enabling tenant mirroring (Cloud Console)

Set up a mirroring system to ensure the availability of your tenant database.

Prerequisites

You must have:

  • Two cloud servers to run the mirror and the arbiter. The major and minor version of these cloud servers must be the same as the cloud server that runs the primary database.

  • The AddDatabase and AlterTenantMirroring privileges.

The database cannot be an autostart database.

Context

A mirroring system involves two cloud servers running the primary and mirror databases, and one cloud server running as arbiter, which negotiates which database is the read-write copy.

Connections to the database are temporarily disabled during the process of enabling tenant mirroring.

Procedure

  1. In the Cloud Console, navigate to the Mirror & Scale-out panel of the tenant database.
  2. Click Start mirroring and follow the instructions.

Results

Your tenant mirroring system now contains a primary, a mirror, and an arbiter.

Next Steps

(Optional) Add read-only scale-out to your tenant mirroring system by creating scale-out database copies.