Working with Backups
RDS supports DB instance backups and restorations to ensure data reliability.
RDS uses Sysbench to import data models and a certain amount of data. After data is backed up, the compression ratio is about 80%. The more duplicate data is, the higher the compression rate is.
Compression ratio = Space occupied by backup files/Space occupied by data files x 100%
Although RDS supports high availability, if a database or table is maliciously or mistakenly deleted, data on the standby DB instance is also deleted and cannot be restored. In this case, backups can be used to restore DB instances after data is deleted.
Automatic backups are created during the backup period of your DB instances. RDS saves automated backups based on the retention period you specified. If necessary, you can restore to any point in time during your backup retention period.
You can also create manual backups. RDS saves manual backups of the DB instance based on the backup retention period you specified. If necessary, you can restore to any point in time during your backup retention period.
The full backup mode is used to back up all target data even if no data is updated since the last backup.
RDS automatically backs up data updated since the last automated or incremental backup every five minutes.