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.
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.
© 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.