Note: Please go to to access the current RightScale documentation set. Also, feel free to Chat with us!
Home > ServerTemplates > Archive > Pre-11H1 > MySQL-S3 > Database Manager for MySQL-S3 Runbook > MySQL-S3 Recipes > Promote Slave-DB to Master-DB

Promote Slave-DB to Master-DB

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.


  1. Go to the running slave DB's instance page.  (Manage -> Servers)
  2. Click on the nickname of the slave DB.
  3. Click on the Scripts tab. Then click on the DB promote to master operational button.
  4. 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.

You must to post a comment.
Last modified
21:34, 16 May 2013



This page has no classifications.



© 2006-2014 RightScale, Inc. All rights reserved.
RightScale is a registered trademark of RightScale, Inc. All other products and services may be trademarks or servicemarks of their respective owners.