Understand MyBase High-Availability Architecture & Failover - ApsaraDB for MyBase - Alibaba Cloud - ApsaraDB for MyBase

Alibaba Cloud offers cloud database services in two editions: Master-replica Edition and High-availability Edition. This topic focuses on the High-availability Edition.

The High-availability Edition is a versatile cloud database edition. By default, it uses a high-availability architecture that includes a primary instance and a secondary instance, but no read-only instances. You can add up to seven read-only instances, each of which also uses a primary/secondary architecture. On the instance's basic information page, the Type & Edition field displays General-purpose Instance (High-availability Edition).

Note The secondary instance is a standby and does not accept application traffic.

Supported versions

MySQL 8.0
MySQL 5.7
MySQL 5.6

Topology

Benefits

High availability
In the High-availability Edition, data is replicated from the primary instance to the secondary instance in semi-synchronous or asynchronous mode. If the primary instance fails, the service automatically fails over to the secondary instance.
Note If a read-only instance fails, its secondary instance becomes the new read-only instance.
Comprehensive features
The High-availability Edition provides a full suite of features, including secondary instance recreation, backup and restoration, performance optimization, and read/write splitting. It also offers SQL Explorer, which stores logs of all executed SQL statements for up to five years. You can use these logs to audit all database access and ensure the security of your core data.

Limitations

For performance reasons, the primary and secondary instances of a High-availability Edition instance must reside in the same region.

FAQ

Can I access the secondary instance?
No. You can only access the primary instance. The secondary instance is a standby and does not accept application traffic.
How do I change the data replication mode for my High-availability Edition instance?
See Query and change data replication mode.