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.
Context and remarks
Connections to the database are temporarily disabled during the process of enabling tenant mirroring.
Run the SetArbiter task on a cloud server.
Run the AddScaleOutDatabaseCopy task on a different cloud server.
Run the ConvertScaleOutDatabaseCopyToMirror task.
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
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company - SAP SQL Anywhere, on-demand edition 1.0|