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 » SAP SQL Anywhere, on-demand edition » Tenant databases » Tenant database mirroring and read-only scale out systems

 

Enabling tenant mirroring (dbcloudcmd)

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 and remarks

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

 Task
  1. Run the SetArbiter task on a cloud server.

  2. Run the AddScaleOutDatabaseCopy task on a different cloud server.

  3. Run the ConvertScaleOutDatabaseCopyToMirror task.

Results

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

Next

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

Example

The following commands set up a tenant mirroring system for the database demo.

dbcloudcmd -cc uid=dbtest;pwd=sql;host=h1 run SetArbiter demo h2#1
    
dbcloudcmd -cc uid=dbtest;pwd=sql;host=h1 run AddScaleOutDatabaseCopy demo h3#1
    
dbcloudcmd -cc uid=dbtest;pwd=sql;host=h1 run ConvertScaleOutDatabaseCopyToMirror demo@h3#1 

 See also