All Products
Search
Document Center

Select a backup method

Last Updated: Aug 20, 2020

DBS is a cost-effective database backup service that provides continuous protection for data.DBS provides three backup methods: logical backup, physical backup, and dump backup. This topic describes how to select a backup method.

Backup method

Logical backup Physical backup
MySQL
  • Full backup (periodic, day-level RPO)
  • Incremental backup (real-time, second-level RPO)
  • Full backup (periodic, day-level RPO)
  • Incremental backup (real-time, 10-minute RPO)
SQL Server
  • Full backup (periodic, day-level RPO)
  • Full backup (periodic, day-level RPO)
  • Incremental backup (periodic, 10-minute RPO)
PostgreSQL
  • Full backup (periodic, day-level RPO)
Not supported
PPAS
  • Full backup (periodic, day-level RPO)
Not supported
Oracle
  • Full backup (periodic, day-level RPO)
  • Full backup (periodic, day-level RPO)
  • Incremental backup (periodic, 10-minute RPO)
Redis
  • Full backup (periodic, day-level RPO)
  • Incremental backup (periodic, 10-minute RPO)
Not supported
MongoDB
  • Full backup (periodic, day-level RPO)
  • Incremental backup (periodic, 10-minute RPO)
Not supported

On-premises user-created database

Database instance type Database type Network requirement Backup scene Recommended backup method
On-premises user-created database MySQL The database can be accessed through a public IP address, Express Connect, VPN Gateway, or Smart Access Gateway. Back up an on-premises database to the cloud. Logical backup
On-premises user-created database MySQL The database is connected to the Internet. Back up an on-premises database to the cloud. Physical backup
On-premises user-created database SQL Server The database can be accessed through a public IP address, Express Connect, VPN Gateway, or Smart Access Gateway. Back up an on-premises database to the cloud. Physical backup
On-premises user-created database SQL Server The database is connected to the Internet. Back up an on-premises database to the cloud. Physical backup
On-premises user-created database Oracle The database can be accessed through a public IP address, Express Connect, VPN Gateway, or Smart Access Gateway. Back up an on-premises database to the cloud. Physical backup
On-premises user-created database Oracle The database is connected to the Internet. Back up an on-premises database to the cloud. Physical backup
On-premises user-created database PostgreSQL, Redis, and MongoDB The database can be accessed through a public IP address, Express Connect, VPN Gateway, or Smart Access Gateway. Back up an on-premises database to the cloud. Logical backup
On-premises user-created database Oracle, PostgreSQL, Redis, and MongoDB The database is connected to the Internet but cannot be accessed through a public IP address, Express Connect, VPN Gateway, or Smart Access Gateway. Back up an on-premises database to the cloud. Not supported
On-premises user-created database Not limited The database is not connected to the Internet. Back up an on-premises database to the cloud. Not supported

ECS-hosted database

Database instance type Database type Network requirement Backup scene Recommended backup method
ECS-hosted database MySQL, PostgreSQL, Redis, and MongoDB Not limited Back up an ECS-hosted database. Logical backup
ECS-hosted database Oracle Not limited Back up an ECS-hosted database. Physical backup
ECS-hosted database SQL Server Not limited Back up an ECS-hosted database. Physical backup

ApsaraDB

Database instance type Database type Network requirement Backup scene Recommended backup method
ApsaraDB for RDS MySQL 5.7 High-Availability Edition with SSD, and MySQL 5.6 Not limited Remote backup Dump backup
ApsaraDB for RDS MySQL (other) Not limited Remote backup Logical backup
ApsaraDB for RDS MySQL Not limited Flexible backup Logical backup
ApsaraDB for RDS SQL Server Not limited Remote backup and flexible backup Logical backup
ApsaraDB for RDS PostgreSQL Not limited Remote backup and flexible backup Logical backup
ApsaraDB for RDS PPAS Not limited Remote backup and flexible backup Logical backup
ApsaraDB for PolarDB MySQL Not limited Remote backup and flexible backup Logical backup
ApsaraDB for PolarDB PostgreSQL Not limited Remote backup and flexible backup Logical backup
ApsaraDB for PolarDB Oracle Not limited Remote backup and flexible backup Logical backup
ApsaraDB for Redis Not limited Not limited Remote backup and flexible backup Logical backup
ApsaraDB for MongoDB Not limited Not limited Remote backup and flexible backup Logical backup

For more information about dump backup and flexible backup, see What is the difference between DBS and the backup capability of ApsaraDB for RDS.