Note: Please go to docs.rightscale.com to access the current RightScale documentation set. Also, feel free to Chat with us!
Home > ServerTemplates > Archive > Pre-11H1 > MySQL-EBS v1 (No Stripe) > Manager for MySQL-EBS Runbook > MySQL-EBS Recipes > Disable or Enable Continuous Backups

Disable or Enable Continuous Backups

NOTE: The time needed to complete a database restoration will vary depending on the size of the database.

Instructions to Disable "Freeze" Continuous Backups

  1. Go to your deployment (Manage -> Deployments).
  2. Click the nickname of the MySQL-EBS instance where you would like to disable "freeze" backups.
  3. Under the Scripts tab, run the DB freeze binary backups operational script.
  4. Wait for the action to be successfully completed.

Instructions to Enable "Unfreeze" Continuous Backups

  1. Go to your deployment (Manage -> Deployments).
  2. Click the nickname of the MySQL-EBS instance where you would like to enable "unfreeze" backups.
  3. Under the Scripts tab, run the DB unfreeze binary backups operational script.
  4. Wait for the action to be successfully completed.

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. 

Once the action is successfully completed, the DB instance where we have executed the script should stop performing the periodic backups (in case of a "freeze"), or resume performing backups (in case of an "unfreeze").

An easy way to confirm that the action took effect is to browse the snapshots (Clouds -> AWS -> EBS Snapshots), and check that the time of the most recent completed snapshot is the same (if you "froze" backups) or that backup snapshots have resumed (if you have "unfrozen" them).

For example, if DB_EBS_PREFIX = mydb

For slave instances, the snapshots have names like 'mydb-slave-YYYYMMDDHHMM.'
For master instances, the snapshots have names like 'mydb-master-YYYYMMDDHHMM.'

NOTE: Slave and master DB backups are performed as defined by the input variables, DB_BACKUP_MASTER_FREQ and DB_BACKUP_SLAVE_FREQ.   So you may have to wait an appropriate amount of time in order to confirm that backups have been successfully frozen or unfrozen. 

You must to post a comment.
Last modified
21:34, 16 May 2013

Tags

This page has no custom tags.

Classifications

This page has no classifications.

Announcements

None


© 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.