This topic describes the database engine versions and database objects that are supported by DBS, and the fine granularity of backup and restoration in Database Backup (DBS). This topic also provides information about features and other items that are supported by each module of DBS.

Common features

  • Compression: reduces storage costs by using compression, compact backup, and incremental backup.
  • Encryption: uses SSL and AES-256 encryption to protect backup data transmission and storage security.
  • Throttling: throttles the number of backup threads to improve the backup performance of source databases.
  • Lifecycle management: provides complete lifecycle management and global rule control, and dumps, clears, copies, and distributes automatic backup data.

Symbol comment

  • This section describes the meaning of the check (✔️) and cross (❌) signs that are used in the tables of this topic.
    • ✔️ indicates that the feature is supported.
    • ❌ indicates that the feature is not supported.
  • For more information about terms such as logical backup and full backup, see Backup methods.

Relational databases

  • Alibaba Cloud databases
    Backup method Feature RDS MySQL RDS SQL Server RDS PostgreSQL RDS MariaDB RDS PPAS PolarDB MySQL PolarDB-O PolarDB PostgreSQL PolarDB-X MySQL
    Logical backup Supported version 5.5

    5.6

    5.7

    8.0

    2005

    2008R2

    2012

    2014

    2016

    2017

    9.2

    9.3

    9.4

    9.5

    10

    11

    10.3

    9.3

    10

    5.6

    5.7

    8.0

    9.3

    10

    11 The storage type is ApsaraDB RDS for MySQL. The MySQL version is 5.x.
    Full data backup ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
    Incremental log backup ✔️ ✔️ ✔️
    Real-time backup RPO in seconds RPO in days RPO in days RPO in seconds RPO in days RPO in seconds RPO in days RPO in days RPO in days
    Instance restoration ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
    Minimum granularity Table Table Table Table Table Table Table Table Datebase
    Backup set download ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
    Backup set query ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
    Note You can back up and restore Alibaba Cloud databases across accounts in DBS. For more information, see Back up and restore data across Alibaba Cloud accounts.
  • Self-managed databases hosted on ECS, local databases, and other cloud databases
    Backup method Feature MySQL SQL Server Oracle PostgreSQL MariaDB
    Logical backup Supported version 5.5, 5.6, 5.7, and 8.0 DBS supports the following versions of Windows SQL Server: 2005, 2008 R2, 2012, 2014, 2016, and 2017 9i, 10g, 11g, and 12c 9.2, 9.3, 9.4, 9.5, 10, and 11 10 and 10.3
    Full data backup ✔️ ✔️ ✔️ ✔️ ✔️
    Incremental log backup ✔️ ✔️
    Real-time backup RPO in seconds RPO in days RPO in days RPO in days RPO in seconds
    Instance restoration ✔️ ✔️ ✔️ ✔️ ✔️
    Minimum granularity Table Table Table Table Table
    Backup set download ✔️ ✔️ ✔️ ✔️ ✔️
    Backup set query ✔️ ✔️ ✔️ ✔️
    Physical backup Supported version DBS supports the following versions of MySQL on Linux: 5.5, 5.6, 5.7, and 8.0 2000, 2005, 2008 R2, 2012, 2014, 2016, and 2017 DBS supports the following versions of Oracle Linux: 10g, 11g, 12c, 18g, and 19g
    Full data backup ✔️ ✔️ ✔️
    Incremental log backup ✔️ ✔️
    Differential backup ✔️
    Instance restoration ✔️ ✔️ ✔️
    Minimum granularity Instance Database Instance
    Backup set download ✔️ ✔️ ✔️
    Backup set query ✔️ ✔️ ✔️
    Minute-level restoration ✔️ ✔️
    DBS sandbox ✔️ ✔️

NoSQL database

Backup method Feature MongoDB Redis
Logical backup Database type
  • Alibaba Cloud databases
  • Self-managed databases hosted on ECS
  • Local databases
  • Other cloud databases
  • Alibaba Cloud databases
  • Self-managed databases hosted on ECS
  • Local databases
  • Other cloud databases
Supported version 3.2, 3.4, 3.6, 4.0, and 4.2 2.6, 2.8, 3.0, 3.2, and 4.0
Full data backup ✔️ ✔️
Incremental log backup ✔️ (Only replica set architecture is supported.) ✔️
Real-time backup RPO in 10 minutes RPO in 10 minutes
Instance restoration ✔️ ✔️
Minimum granularity Collection Database
Backup set download ✔️
Backup set query

Database objects supported by logical backup

The following table shows the database objects that can be backed up and restored in DBS.

Database engine Database object
  • MySQL
  • MariaDB
Table, index, view, trigger, constraint, primary key, foreign key, stored procedure, and function.
  • PostgreSQL
  • PolarDB PostgreSQL
Table, index, view, function, stored procedure, constraint, foreign key, sequence, rule, domain, extension, and operator.
  • PolarDB MySQL
  • PolarDB-O
  • PolarDB-X
Table, index, view, trigger, stored procedure, user, role, constraint, user-defined function, and user-defined table type.
SQL Server Table, index, view, trigger, stored procedure, user, role, constraint, user-defined function, user-defined data type, and user-defined table type.
Oracle Table, index, view, constraint, foreign key, sequence, trigger, function, stored procedure, synonym, and package.
Redis String, Binary, List, Set, Sorted set, Hash, Bit array, HyperLog, Geo, and Module
MongoDB Table, collection, index, view, function, user, and role
Note Admin databases do not support backup.