If a secondary instance on a host in an ApsaraDB for MyBase dedicated cluster is abnormal or you want to migrate a secondary instance to a host in another dedicated cluster, you can recreate the secondary instance.

Supported database engines

  • RDS MySQL
  • RDS PostgreSQL

Note

  • When you recreate the secondary instance, you must minimize read and write operations on the primary instance. If a large number of read and write operations are performed on the primary instance, data may fail to be synchronized to the secondary instance.
  • The duration in which the secondary instance is created varies based on your data volume and business traffic.

Procedure

  1. Log on to the ApsaraDB for MyBase console.
  2. In the upper-left corner of the page, select the region where you want to deploy the dedicated cluster.
  3. In the left-side navigation pane, click Clusters. On the page that appears, find the dedicated cluster that you want to manage, and click Details in the Actions column.
  4. In the left-side navigation pane, click Instances.
  5. Find the instance for which you want to recreate a secondary instance, and click Create New Secondary Instance in the Actions column.
    Recreate a secondary instance
  6. The Create New Secondary Instance dialog box appears.
    • If you do not want to specify a host for the secondary database that you want to recreate, click OK. Recreate a secondary instance - specify a host
      Note If you do not turn on Enable Host, the secondary database is recreated based on the following rules:
      • Preferentially recreate the secondary instance on the host of the original secondary instance.
      • If the secondary instance cannot be recreated on the host, select a host on which the primary instance is not deployed in the dedicated cluster.
      • If a host is unavailable or the host does not have sufficient space, a message appears. This message indicates that the secondary instance cannot be recreated. In this case, you must add a host or scale up the host.
    • If you want to recreate the secondary instance on a specified host, turn on Enable Host, select the host on which you want to the secondary instance, and then click OK. Recreate a secondary instance - specify an instance

Related API operations

API Description
Rebuild instance Recreates the secondary instance of a primary ApsaraDB RDS instance in a dedicated cluster.