Initialize Slave-DB from Master-DB
There are two ways to initialize a Slave-DB from a Master-DB. You can either launch a new Slave-DB that will initialize with the running Master-DB at boot time or manually initialize a Slave-DB with the Master-DB by running an operational script.
When you initialize a Slave-DB from a Master-DB, a new EBS volume is created from the most recent snapshot of the Master-DB. The new volume is mounted to the slave and the contents of the Master-DB are copied over to the Slave-DB. Once all of its contents are in sync with the master, replication will be active.
1. Initialize Slave-DB at boot time
The normal scenario is that INIT_SLAVE_AT_BOOT is set to True so that a new slave instance will automatically initialize with the master when launched.
Instructions
- Go to your deployment (Manage -> Deployments).
- Find the MySQL-EBS "slave" instance ("MySQL EBS" ServerTemplate) and click the Launch button.
- When the server enters the operational state the Slave-DB will be initialized and will be replicating from the Master-DB.
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.
2. Manually Initialize a Slave-DB
If a Slave DB instance is launched in a different way and did not automatically sync itself with the Master-DB (i.e. INIT_SLAVE_AT_BOOT was set to False), you can manually initialize the Slave-DB by running an operational script.
Instructions
- Go to your deployment (Manage -> Deployments).
- Click the nickname of the MySQL-EBS "slave" instance ("MySQL EBS" ServerTemplate) that is currently not connected to the Master-DB.
- Under the Scripts tab, run the DB EBS slave init operational script.
- When the server enters the operational state the Slave-DB will be initialized and will be replicating from the Master-DB.
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