Promoting a Read Replica to Primary

Scenarios

If your DB instance fails and you want to quickly obtain a readable and writable instance, promote one of the instance's read replicas to primary.

After a read replica is promoted to primary, the replication relationship between the read replica and its primary instance is removed and the read replica serves as a standalone DB instance. Promoting a read replica has no impact on its original primary DB instance.

Constraints

• This function is available only to RDS for MySQL 5.7 and 8.0.
• This function is unavailable for DB instances with proxy enabled.

Procedure

1. Log in to the management console.
2. Click in the upper left corner of the page and choose Databases > Relational Database Service.
3. On the Instances page, locate the target RDS for MySQL instance and click in front of it to expand the read replica list.
4. Find the desired read replica and choose More > Promote to Primary in the Operation column.
5. In the displayed dialog box, click Yes.
6. After the promotion is complete, check and manage the new instance on the Instances page.
   • During the promotion, the read replica status is Promoting to primary. Upon the completion of the promotion, a full backup is automatically performed.
   • After the read replica is promoted to primary, it is disassociated from the original DB instance. Its Status becomes Available and DB Instance Type becomes Single.
   • The billing mode on the new instance remains unchanged.