Database Backup (DBS) allows you to back up your databases in a continuous and cost-effective manner. DBS provides three backup methods: logical backup, physical backup, and dump backup. This topic describes how to select backup methods.

For more information, see Logical backup, physical backup, and snapshot-based backup.

Engine type Logical backup Physical backup
MySQL
  • Full backup (periodic, with an RPO of days)
  • Incremental backup (real-time, with an RPO of seconds)
  • Full backup (periodic, with an RPO of days)
  • Incremental backup (real-time, with an RPO of 10 minutes)
SQL Server
  • Full backup (periodic, with an RPO of days)
  • Full backup (periodic, with an RPO of days)
  • Incremental backup (periodic, with an RPO of 10 minutes)
PostgreSQL
  • Full backup (periodic, with an RPO of days)
Not supported
PPAS
  • Full backup (periodic, with an RPO of days)
Not supported
Oracle
  • Full backup (periodic, with an RPO of days)
  • Full backup (periodic, with an RPO of days)
  • Incremental backup (periodic, with an RPO of 10 minutes)
Redis
  • Full backup (periodic, with an RPO of days)
  • Incremental backup (periodic, with an RPO of 10 minutes)
Not supported
MongoDB
  • Full backup (periodic, with an RPO of days)
  • Incremental backup (periodic, with an RPO of 10 minutes)
Not supported

Self-managed local databases

Database type Engine type Network environment Backup scenario Backup method (recommended)
Self-managed local database MySQL
  • Public endpoint
  • Leased line
  • VPN gateway
  • Smart gateway
Cloud backup Logical backup
Self-managed local database MySQL Internet access Cloud backup Physical backup
Self-managed local database SQL Server
  • Public endpoint
  • Leased line
  • VPN gateway
  • Smart gateway
Cloud backup Physical backup
Self-managed local database SQL Server Internet access Cloud backup Physical backup
Self-managed local database Oracle
  • Public endpoint
  • Leased line
  • VPN gateway
  • Smart gateway
Cloud backup Physical backup
Self-managed local database Oracle Internet access Cloud backup Physical backup
Self-managed local database PostgreSQL, Redis, and MongoDB
  • Public endpoint
  • Leased line
  • VPN gateway
  • Smart gateway
Cloud backup Logical backup
Self-managed local database Oracle, PostgreSQL, Redis, and MongoDB
  • Public endpoint
  • Leased line
  • VPN gateway
  • Smart gateway with Internet access
Cloud backup Logical backup (using a database gateway)
Self-managed local database No limit No Internet access Cloud backup Not supported

Self-managed ECS-based databases

Database type Engine type Network environment Backup scenario Backup method (recommended)
Self-managed ECS-based database MySQL, PostgreSQL, Redis, and MongoDB No limit Backup in self-managed ECS-based databases Logical backup
Self-managed ECS-based database Oracle No limit Backup in self-managed ECS-based databases Physical backup
Self-managed ECS-based database SQL Server No limit Backup in self-managed ECS-based databases Physical backup

Cloud databases

Database type Engine type Network environment Backup scenario Backup method (recommended)
ApsaraDB RDS MySQL 5.7 on RDS High-availability Edition with local SSDs and MySQL 5.6 No limit Cross-region backup Dump backup
ApsaraDB RDS MySQL (other) No limit Cross-region backup Logical backup
ApsaraDB RDS MySQL No limit Flexible backup Logical backup
ApsaraDB RDS SQL Server No limit Cross-region backup and flexible backup Logical backup
ApsaraDB RDS PostgreSQL No limit Cross-region backup and flexible backup Logical backup
ApsaraDB RDS PPAS No limit Cross-region backup and flexible backup Logical backup
PolarDB MySQL No limit Cross-region backup and flexible backup Logical backup
PolarDB PostgreSQL No limit Cross-region backup and flexible backup Logical backup
PolarDB Oracle No limit Cross-region backup and flexible backup Logical backup
ApsaraDB for Redis No limit No limit Cross-region backup and flexible backup Logical backup
ApsaraDB for MongoDB No limit No limit Cross-region backup and flexible backup Logical backup

For more information about dump backup and flexible backup, see ApsaraDB RDS-generated backups and DBS-generated backups.