Disable or Enable Continuous Backups
Objective
To enable or disable continuous backups of the MySQL database.
Note: The time needed to complete a database restoration will vary depending on the size of the database.
Table of Contents
Steps
Disable "Freeze" Continuous Backups
- Go to your Deployment (Manage -> Deployments).
- Click the nickname of the MySQL database server on which you would like to disable (freeze) backups.
- Under the Scripts tab, run the DB freeze binary backups operational script.
- Wait for the action to be successfully completed. Once the action is successfully completed, the DB instance where we have executed the script should stop performing periodic backups.
(Re)Enable "Unfreeze" Continuous Backups
- Go to your Deployment (Manage -> Deployments).
- Click the nickname of the MySQL-EBS instance where you would like to (re)enable (unfreeze) backups.
- Under the Scripts tab, run the DB unfreeze binary backups operational script.
- Wait for the action to be successfully completed. Once the action is successfully completed, the DB instance where we have executed the script should start or resume performing backups.
Verify your Changes
An easy way to confirm that the action took effect is to browse the snapshots (Clouds -> AWS Region -> EBS Snapshots), and verify that the time of the most recently completed snapshots are the same (if you "froze" backups) or that backup snapshots have resumed (if you have "unfrozen" them).
For example, if DB_LINEAGE_NAME = mydb
For slave instances, the snapshots have names like 'mydb-slave-YYYYMMDDHHMM.'
For master instances, the snapshots have names like 'mydb-master-YYYYMMDDHHMM.'
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