Help Center/
Relational Database Service/
User Guide (ME-Abu Dhabi Region) /
Working with RDS for SQL Server/
Instance Modifications/
Changing a DB Instance Type from Single to Primary/Standby
Updated on 2023-07-06 GMT+08:00
Changing a DB Instance Type from Single to Primary/Standby
Scenarios
- RDS enables you to change single DB instances to primary/standby DB instances to improve instance reliability.
- Primary/standby DB instances support automatic failover. If the primary DB instance fails, the standby DB instance takes over services quickly. You are advised to deploy primary and standby DB instances in different AZs for high availability and disaster recovery.
Procedure
- Log in to the management console.
- Click in the upper left corner and select a region and a project.
- Click Service List. Under Database, click Relational Database Service. The RDS console is displayed.
- On the Instance Management page, locate the target DB instance and choose More > Change Type to Primary/Standby in the Operation column.
Alternatively, click the target DB instance. In the DB instance topology, click on the left to change the instance type from single to primary/standby.
- Select a standby AZ and enter the original administrator password. Other configurations are the same as those of the primary DB instance by default. Confirm the configurations and click Submit.
- After a single DB instance is changed to primary/standby instance, you can view and manage it on the Instance Management page.
- The DB instance is in the Changing type to primary/standby status. You can view the progress on the Task Center page. For details, see Task Center.
- In the upper right corner of the DB instance list, click to refresh the list. After the DB instance type is changed to primary/standby, the instance status will change to Available and the instance type will change to Primary/Standby.
Parent topic: Instance Modifications
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot