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

Switching tenant mirroring roles

Initiate a role switch or failover on a tenant database to force the primary and mirror databases to change their roles.

Prerequisites

You must have the AlterTenantMirroring privilege.

The primary and mirror databases must be running.

Context

The primary database stops and then restarts as the mirror database, resulting in dropped connections. Connections to scale-out database copies and the mirror database that becomes the primary database are not affected.

Procedure

  1. In the Cloud Console, navigate to the Mirror & Scale-out panel of the tenant database.
  2. Click Switch roles.

Results

The primary database (the read-write database copy) becomes the mirror (a read-only database copy), and the mirror database becomes the primary, transferring ownership of the read-write database copy.