Databases require regular automatic backup to ensure data integrity, reliability, and restorability.
ApsaraDB for RDS provides the following backup functions:
- Data backup: required. You must configure at least two physical backup tasks every week. You can also initiate a temporary backup task in the ApsaraDB for RDS console or by calling an API operation based on O&M requirements.Backup files can be retained for 7 to 730 days.
- Log backup: optional. If you disable log backup, data can only be restored to the point in time when the backup set is created. Data backup and log backup support the same retention policy.
ApsaraDB RDS for MySQL also supports backup archiving and cross-region backup. For more information, see Back up an ApsaraDB RDS for MySQL instance across regions.
Data restorability is essential to ensure the reliability of database O&M.
ApsaraDB for RDS provides the following restoration functions:
- Restoration by backup set: You can restore data from a specified backup set to a temporary or cloned instance. Then, you can check whether your data is intact on the temporary or cloned instance.
- Restoration by point in time: You can select a near point in time to restore data to a temporary or cloned instance by using the last full backup and subsequent log backups.
ApsaraDB RDS for MySQL also supports cross-region restoration and the restoration of individual databases or tables. For more information, see Restore individual databases or tables for an RDS MySQL instance and Restore the data of an RDS MySQL instance across regions.