Promote Slave-DB to Master-DB
Table of Contents
Promoting a slave DB to be the new master involves syncing up DB contents and switching DNS entries. After the promotion is done, the new master will acquire the master DNS entry, and the old master (if it's alive) will acquire the slave DNS one. The old master (if it's alive) will be demoted to a slave, and will be in sync and replicating from the new one.
Currently, RightScale does not support automatic failover between MySQL instances. We believe that it's best practice to always perform the fail-over manually. Therefore, you should never create an alert and escalation to automatically promote a Slave-DB to Master-DB.
Instructions
- Go to the running slave DB's instance page. (Manage -> Servers)
- Click on the nickname of the slave DB.
- Click on the Scripts tab. Then click on the DB promote to master operational button.
- Wait until the action is successfully completed.
What feedback to expect
The Recent Events pane will highlight the progress of the operation. If the action is not completed successfully and there is a failure message, click on the name of the action in the Recent Events pane for a detailed output that you can use for troubleshooting.
- © Copyright 2015 RightScale Technical Support