Launch a new Master-DB
Table of Contents
Launch a new Master-DB instance using the MySQL EBS ServerTemplate where you manually restore the MySQL database by using an existing EBS snapshot to create and attach an EBS volume.
The data with which the DB instance will be initialized will correspond to the contents of the latest existing master EBS snapshot. In particular, the snapshot to restore will be the snapshot matching the prefix as specified by the DB_EBS_PREFIX input variable in our MySQL EBS template. In case of multiple matches, the snapshot with the latest appended number (which corresponds to the date it was taken) will be chosen. Or the snapshot used can be overridden using the DB_RESTORE_PREFIX_OVERRIDE input variable.
If no matching snapshot exists, the master restore operational script will fail, and manual initialization of the DB will be required. This latter case should only happen the first time we boot that DB. Manual installation of the initial DB contents is explained in Recipe 3.
Instructions
- Go to your deployment (Manage -> Deployments).
- Find the MySQL-EBS "master" instance ("MySQL EBS" ServerTemplate) and click the Launch button.
- Set the input variable, INIT_SLAVE_AT_BOOT = False
- Restore the Master DB using the "DB EBS master restore" operational script
What feedback to expect
A notification on the Recent Events pane should indicate that the Master-DB server is pending.
To confirm it, we can:
- Go to your deployment (Manage -> Deployments).
- Locate the master server instance and verify that it's state is no longer "stopped" and that the instance's runtime is consistent with when it was launched.
- Click on its nickname to see more detailed information about the server.
IMPORTANT! When you are through make sure your Servers are named appropriately! For example, if you have a new master and a new slave Server, make sure you name (or rename) your Servers appropriately.
- © Copyright 2015 RightScale Technical Support