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 (dbcloudcmd)

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


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.


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


  1. Run the SetArbiter task on a cloud server.
  2. Run the AddScaleOutDatabaseCopy task on a different cloud server.
  3. Run the ConvertScaleOutDatabaseCopyToMirror task.


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


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 

Next Steps

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