All Products
Search
Document Center

What is the difference between DBS and the backup capability of ApsaraDB for RDS

Last Updated: Jun 02, 2020

DBS offers features such as full backup, incremental backup, and data restore. It supports restoring databases deployed in multiple environments to OSS.

Environments supported by DBS

  • Databases deployed in on-premise data centers or on third-party clouds.

  • Databases deployed on ECS instances

  • ApsaraDB for RDS instances

For more information about database environments and versions supported by DBS, see Functionality matrix.

Difference between DBS and the backup capability of ApsaraDB for RDS

  • DBS provides the dump backup and logical backup features to meet the remote backup and flexible backup requirements of ApsaraDB for RDS customers.

  • DBS also supports the physical backup feature to meet the local backup and quick restore requirements of ApsaraDB for RDS customers.

1.4

Benefits of DBS dump backup (remote backup)

  • A secure and reliable backup network is provided. For more information, see Cross-region RDS backup.

  • DBS directly dumps the native physical backup data and logs of ApsaraDB for RDS to OSS without starting an additional backup operation.

  • DBS supports restoring backup sets to an ApsaraDB for RDS instance with one click.

  • Backup sets can be separately retained for up to five years, even if the corresponding ApsaraDB for RDS instance is released.

  • The storage service supports elastic scaling and does not require O&M.

Benefits of DBS logical backup (flexible backup)

  • DBS enables you to back up your core tables and protect your core data in real time. It supports single-table full backup and real-time incremental backup. DBS also supports restoring the backup data to any time point accurate to the second. For more information, see Configure a backup schedule.

  • DBS supports restoring a single table by extracting the target table from the entire backup set. The time required for single-table restore depends on the actual amount of data to be restored. Generally, this takes only a few minutes.

  • DBS supports database or table mapping during data restore. You do not need to purchase another database instance to restore the data. The database or table mapping feature enables you to restore your backup data to the source database instance. You can manually rename and restore databases and tables. DBS also provides a conflict handling feature for tables with duplicate names. When the name of a table to be restored is the same as that of an existing table in the destination database instance, the table to be restored is automatically renamed. The data restore process does not delete or modify existing data in the destination database. For more information, see Restore a database.

  • DBS allows you to query the backup data online. Deeply integrated with Data Lake Analytics (DLA), DBS brings life to your backup data. You can query the backup data by using SQL statements without restoring the data to a database. The query results will be returned to you immediately.

1.3

  • DBS is deeply integrated with DMS to directly perform real-time backup and second-level restore for ApsaraDB for RDS databases in DMS.

1.1