Database Backup (DBS) provides features such as geo-redundancy, long-term archiving, and single-table restoration for MySQL instances.
Features
Feature | Description |
---|---|
incremental backup |
DBS uses incremental log streaming to retrieve binary log files in real time for incremental backup. |
Full backup |
Logical backups are stored in the Parquet format. Physical backups are stored in the gzip format. |
Backup set download |
DBS allows you to download backup sets. For more information, see Overview. |
Backup data query |
DBS allows you to use SQL statements to query data in backup sets without the need to restore backup data. For more information, see Backup set query overview. |
Geo-redundancy | DBS can back up a MySQL instance to an Object Storage Service (OSS) bucket across regions. DBS allows you to restore the backup data to a MySQL instance in the source, the destination, or a different region. |
Long-term archiving |
DBS can retain your backup data for up to ten years. After ten years, DBS transfers backup sets to Archive Storage. |
Fine-grained backup |
DBS allows you to back up a single table, a single database, multiple databases, or an entire MySQL instance. |
Backup speed limit |
DBS allows you to limit the backup speed to reduce the negative impact of backup operations on database performance. For more information, see How do I change the maximum backup speed?. |
Single-table restoration |
DBS allows you to restore a single table without the need to restore the entire MySQL instance. This way, the restoration time is reduced. When you configure the objects to restore, select the table that you want to restore. For more information, see Restore a MySQL database from a logical backup. |
Create a backup schedule
For more information, see Purchase a backup schedule.