Promoting a Read Replica Into a Single DB Instance

Scenarios

RDS enables you to promote a read replica into a single DB instance. When you promote a read replica, replication is stopped. After the promotion is complete, the read replica is available as a single DB instance. This operation does not affect the performance of the original DB instance.

• This function is available only for RDS for MySQL 5.7 and RDS for MySQL 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 and select a region and a project.
3. Click Service List. Under Database, click Relational Database Service. The RDS console is displayed.
4. On the Instance Management page, locate the target read replica and choose More > Promote to Primary in the Operation column.
5. View the read replica status on the Instance Management page.
   • During the promotion, the read replica status is Promoting to primary.
   • Refresh the DB instance list by clicking to see if the promotion is complete. After the promotion is complete, the read replica is disassociated from the original DB instance and is available as a single DB instance.
   • The billing mode on the new DB instance remains unchanged.