Home > ServerTemplates > Archive > Pre-11H1 > MySQL-EBS v1 (No Stripe) > Manager for MySQL-EBS Runbook > MySQL-EBS Recipes > Promote Slave-DB to Master-DB
Promote Slave-DB to Master-DB
Promote Slave-DB to Master-DB
Table of Contents
Promoting a Slave-DB to become the new Master-DB involves syncing up DB contents, switching DNS entries and creating a snapshot of the new Master-DB. After the promotion is complete, the new Master-DB will swap DNS entries of the previous Master-DB and the previous Master-DB will become a slave of the new master.
Instructions
- Go to your deployment (Manage -> Deployments).
- Click the nickname of the MySQL-EBS "slave" instance that you want to make the new Master-DB.
- Under the Scripts tab, run the DB EBS promote to master operational script. (At the end, a snapshot will be taken of the new Master-DB.)
- Wait for the snapshot of the new Master-DB to be 100% complete before launching any new slave instances.
- If you are running a Rails application, restart all of the mongrels so they will point to the new DNS entries.
What feedback to expect
The Recent Events pane will highlight the progress of the operation. Click on the name of an action in the pane to view a detailed output of the action that can be used to troubleshoot the cause of a failure, if necessary.
- © Copyright 2015 RightScale Technical Support