rds mysql auto backup


//=== http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.BackingUpAndRestoringAmazonRDSInstances.html

* RDS automatic backup for the MySQL DB engine only support InnoDB storage engine;
for MyISAM storage engine, restoring from backups may lead to unreliable behavior;
you can attempt to manually repair tables after a crash by REPAIR command
--> http://dev.mysql.com/doc/refman/5.5/en/repair-table.html

* daily automated backup + real-time db change logs(transaction logs) archive
--> point-in-time recovery up to the LatestRestorableTime (typically up to the last five minutes)


*** backup window, retention period
A "daily" automated backup occurs during a configurable period of time, "the preferred backup window".
Backups created during the backup window are retained for a configurable number of days "the backup retention period".

During the backup window, storage I/O may be suspended while your data is being backed up and you may experience longer latency.

This I/O suspension typically lasts for the duration of the snapshot. This period of I/O suspension is shorter for Multi-AZ DB deployments, since the backup is taken from the standby.

RDS assigns a default 30-minute backup window which is selected at random from an 8-hour block of time per region.

* The backup window cannot overlap with the weekly maintenance window for the DB instance.

[ex] set the backup window to 03:00 to 03:30
PROMPT> rds-modify-db-instance mydbinstance --preferred-backup-window 03:00-03:30




//===
If you don't set the backup retention period, RDS uses a default period retention period of one day. Y
valid values are 0 (for no backup retention) to a maximum of 35 days.

//=== http://aws.amazon.com/about-aws/whats-new/2012/03/19/amazon-rds-increases-backup-retention-period/

the maximum retention period for automated backups has been increased from eight days to thirty five days. This new limit will enable you to store more than a month of backups.


//=== disable auto backup
* to temporarily disable automated backups in certain situations; for example, while loading large amounts of data.
by setting the backup retention period to 0.

PROMPT> rds-modify-db-instance mydbinstance --backup-retention-period 0 --apply-immediately

PROMPT> rds-describe-db-instances mydbinstance --headers


//=== enable auto backup
* enable auto backup by setting the backup retention period to a non-zero value.

[ex] Set the backup retention period to 3 days.
PROMPT> rds-modify-db-instance mydbinstance --backup-retention-period 3 --apply-immediately