This topic describes the database engine versions and database objects that are supported by Database Backup (DBS), and the granularity of backup and restoration in DBS. This topic also describes the features that are supported by DBS for different types of databases.

Features for all supported databases

  • Compression: DBS reduces storage costs by means of compression, compact backup, and incremental backup.
  • Encryption: DBS uses SSL and AES-256 encryption to ensure security in the transmission and storage of backup data.
  • Throttling: DBS throttles the number of backup threads to reduce the impact on the performance of source databases.
  • Lifecycle management: DBS provides complete lifecycle management of backup sets and globally controls lifecycle rules to dump, clear, copy, and distribute automatic backup data.

Symbols in the tables

  • This section describes the symbols that are used in the tables in 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 Logical backup, physical backup, and snapshot-based backup.

Note For more information about how to purchase and configure a backup schedule in DBS, see Backup and restoration overview.

Relational databases

  • Alibaba Cloud database services
    Backup methodFeatureApsaraDB RDS for MySQLApsaraDB RDS for SQL ServerApsaraDB RDS for PostgreSQLApsaraDB RDS for MariaDBApsaraDB RDS for PPASPolarDB for MySQLPolarDB for PostgreSQLDistributed Relational Database Service (DRDS)
    Logical backupSupported versions

    8.0

    5.7

    5.6

    5.5

    2019

    2017

    2016

    2012

    2008 R2

    14

    13

    12

    11

    10

    9.4

    10.3

    10

    9.3

    8.0

    5.7

    5.6

    11

    The storage type is ApsaraDB RDS for MySQL. The MySQL version is 5.x.
    Data source typeMySQLSQL ServerPostgreSQLMariaDBPPASMySQL
    • Oracle
    • PostgreSQL
    PolarDB-X (formerly known as DRDS)
    Full data backup✔️✔️✔️✔️✔️✔️✔️✔️
    Incremental log backup✔️✔️✔️
    Real-time backupRPO in secondsRPO in daysRPO in daysRPO in secondsRPO in daysRPO in secondsRPO in daysRPO in days
    Instance restoration✔️✔️✔️✔️✔️✔️✔️✔️
    Minimum granularityTableTableTableTableTableTableTableDatabase
    Backup set download✔️✔️✔️✔️✔️✔️✔️✔️
    Backup set query✔️✔️✔️✔️✔️✔️ (Backup set query is supported only when the data source type is PostgreSQL.)✔️
    Note
    • Recovery Point Objective (RPO) refers to the point in time to which data can be restored after a disaster. RPO is used to measure the maximum amount of acceptable data loss in a disaster.
    • You can back up and restore Alibaba Cloud database services across accounts in DBS. For more information, see Back up and restore data across Alibaba Cloud accounts.
  • Self-managed databases hosted on Elastic Compute Service (ECS) instances, on-premises databases, and cloud databases from third-party providers
    Backup methodFeatureMySQLSQL ServerOraclePostgreSQLMariaDB
    Logical backupSupported versions8.0, 5.7, 5.6, and 5.5SQL Server 2019, 2017, 2016, 2014, 2012, 2008 R2, and 2005 on Windows12c, 11g, 10g, and 9i11, 10, 9.5, 9.4, and 9.310.3 and 10
    Data source typeMySQLSQL ServerOraclePostgreSQLMariaDB
    Full data backup✔️✔️✔️✔️✔️
    Incremental log backup✔️✔️
    Real-time backupRPO in secondsRPO in daysRPO in daysRPO in daysRPO in seconds
    Instance restoration✔️✔️✔️✔️✔️
    Minimum granularityTableTableTableTableTable
    Backup set download✔️✔️✔️✔️✔️
    Backup set query✔️✔️✔️✔️
    Physical backupSupported versionsMySQL 8.0, 5.7, 5.6, and 5.5 on Linux2019, 2017, 2016, 2014, 2012, 2008 R2, 2005, and 200011g, 10g, 12c, 18c, and 19c
    Data source typeMySQLSQL ServerOracle
    Full data backup✔️✔️✔️
    Incremental log backup✔️

    Binary logs can be backed up. For more information, see Back up binary logs of a MySQL database.

    ✔️✔️
    Differential backup✔️
    Instance restoration✔️✔️✔️
    Minimum granularityInstanceDatabaseInstance
    Backup set download✔️✔️✔️
    Backup set query
    Restoration in minutes✔️✔️
    DBS sandbox✔️✔️

NoSQL databases

Backup methodFeatureMongoDBRedis
Logical backupDatabase type
  • Alibaba Cloud database services
  • Self-managed databases hosted on ECS instances
  • On-premises databases
  • Cloud databases from third-party providers
  • Alibaba Cloud database services
  • Self-managed databases hosted on ECS instances
  • On-premises databases
  • Cloud databases from third-party providers
Data source typeMongoDBRedis
Supported versions4.2, 4.0, 3.6, 3.4, and 3.24.0 (standard master-replica architecture)
Note
  • Redis 5.0 or later is not supported.
  • Redis cluster instances are not supported.
Full data backup✔️✔️
Incremental log backup✔️ (only the replica set architecture is supported.)✔️
Real-time backupRPO in 10 minutesRPO in 10 minutes
Instance restoration✔️✔️
Minimum granularityCollectionDatabase
Backup set download✔️
Backup set query

Database objects supported by logical backup

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

Database engineDatabase object
  • MySQL
  • MariaDB
Table, index, view, trigger, constraint, primary key, foreign key, stored procedure, and function
  • PostgreSQL
  • PolarDB for PostgreSQL
Table, index, view, function, stored procedure, constraint, foreign key, sequence, rule, domain, extension, and operator
  • PolarDB for MySQL
  • PolarDB for Oracle
  • Distributed Relational Database Service (DRDS)
Table, index, view, trigger, stored procedure, role, constraint, user-defined function, and user-defined table type
SQL ServerTable, index, view, trigger, stored procedure, user, role, constraint, user-defined function, user-defined data type, and user-defined table type
OracleTable, index, view, constraint, foreign key, sequence, trigger, function, stored procedure, synonym, and package
RedisSTRING, BINARY, LIST, SET, SORTED SET, HASH, BITARRAY, HYPERLOG, GEO, and MODULE
MongoDBTable, collection, index, view, function, user, and role
Note The admin databases in MongoDB cannot be backed up.