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 |
|
|
SQL Server |
|
|
PostgreSQL |
|
Not supported |
PPAS |
|
Not supported |
Oracle |
|
|
Redis |
|
Not supported |
MongoDB |
|
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.