ApsaraDB MyBase is available in two editions: High-availability Edition and Master-replica Edition. This topic describes High-availability Edition.

High-availability Edition is a widely used edition. By default, High-availability Edition contains a primary instance and a secondary instance. You can create up to seven read-only instances on demand. Each read-only instance uses a primary/secondary architecture. High-availability Edition
Note The secondary instance runs as a standby for the primary instance and does not allow external access.

Supported versions

  • MySQL 8.0
  • MySQL 5.7
  • MySQL 5.6

Topology

Topology of High-availability Edition

Benefits

  • High availability
    In High-availability Edition, data is replicated from the primary instance to the secondary instance in semi-synchronous or asynchronous mode. If the primary instance is inaccessible, your workloads are automatically failed over to the secondary instance.
    Note If a read-only instance fails, its secondary instance takes over as the new read-only instance.
  • Comprehensive functionality

    High-availability Edition provides a complete suite of features, such as secondary instance recreation, backup and restoration, performance optimization, read/write splitting, and SQL Explorer. The SQL Explorer feature allows you to store the logs of all executed SQL statements for up to five years. This way, you can trace database access behavior and ensure the security of important data.

Limits

For performance purposes, you must deploy the primary and secondary instances in the same region.

FAQ

  • Can I access a secondary instance?

    No, you cannot access a secondary instance. You can access only the primary instance. A secondary instance runs only as a standby and does not allow external access.

  • If my instance runs High-availability Edition, how do I change the data replication mode of the instance?

    You can change the data replication mode in the console. For more information, see Change the data replication mode of an ApsaraDB RDS for MySQL instance.