ApsaraDB RDS for MySQL can generate backups, which are called default backups. If the default backups that are generated by ApsaraDB RDS for MySQL cannot meet your business requirements, you can use Database Backup (DBS) to create advanced backups.

Scenario Item ApsaraDB RDS-generated backup

(physical backup or snapshot backup)

DBS-generated backup

(logical backup)

References
Perform backups. Perform scheduled backups. ✔️ (Scheduled backups are automatically enabled and cannot be disabled.) ✔️ (Scheduled backups must be manually enabled.) Enable automatic backups for an ApsaraDB RDS for MySQL instance
Perform incremental backups or log backups. ✔️ ✔️
Backs up individual databases and tables.
  • Local SSDs: ✔️. Standard SSDs or enhanced SSDs (ESSDs): ❌
  • Manually enabled: ✔️. Enabled at a scheduled point in time: ❌
  • Incremental backups: ❌
✔️ Back up the individual databases and tables of an ApsaraDB RDS for MySQL instance
Perform cross-region backups. Local SSDs: ✔️. Standard SSDs or ESSDs: ❌ ✔️ Enable cross-region backups for an ApsaraDB RDS for MySQL instance
Store backup files. Store backup files to your Object Storage Service (OSS) buckets. ✔️ Back up a MySQL instance
Support multi-level storage pools. ✔️ What is a storage pool?
Download backup files. Manually download backup files. Local SSDs: ✔️. Standard SSDs or ESSDs: ❌ ✔️ Download the backup files of an ApsaraDB RDS for MySQL instance
Automatically download backup files. ✔️
Encrypt backup files. Encrypt backup files at rest. ✔️ ✔️ Encrypt the backup files of an ApsaraDB RDS for MySQL instance
Encrypt backup files in transit. ✔️
Restore data by using backup files. Restore data in single-digit seconds. Local SSDs: ✔️ Create a sandbox instance for emergency recovery
Query backup files at a high speed. ✔️ Query data from DBS-generated logical backup files
Restore individual databases and tables. Local SSDs: ✔️. Standard SSDs or ESSDs: ❌ ✔️ Restore individual databases and tables of an ApsaraDB RDS for MySQL instance

Restore individual databases and tables by using DBS

Restore data to an RDS instance by using backup files.
  • Restore data to a new RDS instance by using backup files: ✔️
  • Restore data to the original RDS instance by using backup files: local SSDs:✔️. Standard SSDs or ESSDs: ❌
  • Restore data to a different existing RDS instance by using backup files: ❌
  • Restore data to a self-managed database by using backup files: ❌
✔️ Restore the backup files of an ApsaraDB RDS for MySQL instance

Restore the backup files by using DBS