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

Tenant mirroring and read-only scale-out requirements and notes

There are several requirements for setting up a tenant mirroring and/or read-only scale-out system.

  • Host considerations for tenant mirroring systems
    • Place the primary database, mirror database, and arbiter server on three different hosts. If the primary becomes unavailable because of hardware or software failure, then the mirror negotiates with the arbiter to assume the role of primary.

      Although databases can run on the cloud partners, for improved performance, especially in clouds with a high volume of activity, consider running tenant databases on separate hosts.

  • Cloud server considerations for tenant mirroring and read-only scale-out systems
    • A cloud server can only run one database copy of a specific tenant database at a time.

    • A cloud server can be assigned a role in a cloud high availability or tenant mirroring system. You can assign a cloud server multiple roles in various tenant mirroring systems. For example, a cloud server can act as an arbiter for one tenant, a mirror for another tenant, and a primary for yet another tenant.

  • Application design considerations for mirroring systems
    • Application designers should consider that if a role switch occurs for a mirrored tenant database, then tenant applications must reconnect to the database.

  • Restriction for autostart databases
    • Autostart databases cannot be involved in a mirroring or read-only scale-out system.

  • Cloud server version restriction
    • When a tenant database is involved in a mirroring or read-only scale-out system, all of its database copies must run on cloud servers that are of the same major and minor version. In a mirroring system, the arbiter server must also be of the same major and minor version as primary, mirror, and any scale-out database copies.

  • Read-only scale-out in a tenant mirroring system

    To ensure the availability of the read-write database, use mirroring with a tenant read-only scale-out system. In a mirroring system the primary and mirror databases can switch roles at anytime. As a result, when a read-only scale-out is used with mirroring, the read-write database of the read-only scale-out system consists of both the primary and mirror databases of the tenant mirroring system.