To launch a new Master-DB instance where you manually restore the MySQL database by using an existing set of backup snapshots to create and attach all volumes in the EBS stripe.
Note: If you do not have a previous set of backup snapshots to restore from and are launching a Master-DB server for the first time with RightScale's premium MySQL ServerTemplates, you will need to follow the appropriate "stripe" MySQL Database Setups tutorials to launch a new Master-DB.
Table of Contents
By default, the backup that will be used to initialize and restore the database will be the most recently completed set of backup snapshots that match the lineage as specified by the DB_LINEAGE_NAME input variable (regardless of whether they are snapshots of the master or slave). If you don't want to use the most recent set of backup snapshots you can use the OPT_DB_RESTORE_LINEAGE_OVERRIDE and OPT_DB_RESTORE_TIMESTAMP_OVERRIDE input variables to override and select a specific backup (set of EBS snapshots). For example, if your database is corrupted, you can perform database restorations to find your last clean (uncorrupted) copy. If you're creating a Staging Deployment, you may want to setup your database servers with the most recent backup of the Production Deployment. But be careful! If you forget to change the DB_LINEAGE_NAME to be different than your Production Deployment, you could accidentally create backups for your live production environment!
Note: If you use the override inputs to restore from a backup (set of snapshots) with a different lineage name (DB_LINEAGE_NAME), it's important to realize that future backups will be created and named according to the DB_LINEAGE_NAME input. As a best practice, the lineage name input should always be set at the Deployment level.
The 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.
IMPORTANT! When you are done, make sure your Servers are named appropriately! Make sure you know which Server is your master and which one is your slave.
© 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.