Backup Master-DB
Table of Contents
Backups of a Master-DB ("MySQL EBS" ServerTemplate) are saved as EBS snapshots.
When a backup of the Master-DB is completed, a new snapshot will be created and named according to DB_EBS_PREFIX input variable. The complete name of the snapshot will have the date appended to the specified prefix. For example, if DB_EBS_PREFIX = mydb, a resulting snapshot name would look something like 'mydb-master-200709081143'. Times are in UTC format (by default or as specified in the input variable OPT_TZINFO). This format will help you sort and locate the times of the existing snapshots.
Since backups are done via an EBS snapshot the the operation will complete very quickly. However, the snapshot itself will not be available for creating volumes until the snapshot is complete. The time for a snapshot to complete will vary widely depending on the size of the EBS volume and the total number of changes to the EBS volume since the last snapshot was taken.
Instructions
- Go to your deployment (Manage -> Deployments).
- Click the nickname of the MySQL-EBS "master" instance.
- Under the Scripts tab, run the DB EBS backup operational script. (At the end, a snapshot will be taken of the new Master-DB.)
- Wait for the snapshot of the new Master-DB to be 100% complete before launching any new slave instances.
What feedback to expect
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.
- © Copyright 2015 RightScale Technical Support