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