Initialize Slave-DB from Master-DB
Table of Contents
By default, when a new slave DB instance is launched with the "MySQL Additional" server template, it will automatically sync itself to the master DB and start replication once the contents of the master DB have been copied over. (The "MySQL Additional" server template includes "DB slave init at boot" as a boot script.)
If a slave DB instance is launched in a different way and did not automatically sync itself with the master DB, you can manually initialize the slave DB by running the "DB slave init" operational action.
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 slave init 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