ApsaraDB for RDS

  • MySQL

    Logical backup

    Version Full backup Incremental backup Data restoration
    5.5 Supported Supported Supported
    5.6 Supported Supported Supported
    5.7 Supported Supported Supported
    8.0 Supported Supported Supported
    Note Incremental backup is supported only when binlogging is enabled for databases.
  • MariaDB

    Logical backup

    Version Full backup Incremental backup Data restoration
    10.3 Supported Supported Supported
    Note The Database Location parameter can only be set to User-Created Database with Public IP Address <IP Address:Port Number>.
  • SQL Server

    Logical backup

    Version Full backup Incremental backup Data restoration
    2005 Supported Not supported Supported
    2008R2 Supported Not supported Supported
    2012 Supported Not supported Supported
    2014 Supported Not supported Supported
    2016 Supported Not supported Supported
    2017 Supported Not supported Supported
    Database object Backup and restoration
    Table Supported
    Index Supported
    View Supported
    Trigger Supported
    Stored procedure Supported
    User Supported
    Role Supported
    Constraint Supported
    User-defined function (UDF) Supported
    Custom data type Supported
    Custom table type Supported
  • PostgreSQL

    Logical backup

    Version Full backup Incremental backup Data restoration
    9.2 Supported Not supported Supported
    9.3 Supported Not supported Supported
    9.4 Supported Not supported Supported
    9.5 Supported Not supported Supported
    10 Supported Not supported Supported
    11 Supported Not supported Supported
    Database object Backup and restoration
    Table Supported
    Index Supported
    View Supported
    Function Supported
    Stored procedure Supported
    Constraint Supported
    Foreign key Supported
    Sequence Supported
    Rule Supported
    Domain Supported
    Extension Supported
    operator Supported
  • PPAS

    Logical backup

    Version Full backup Incremental backup Data restoration
    9.3 Supported Not supported Supported
    10 Supported Not supported Supported

PolarDB

  • MySQL
    Note Set the database type to MySQL when you purchase backup schedules.

    Logical backup

    Version Full backup Incremental backup Data restoration
    5.6 Supported Supported Supported
    5.7 Supported Supported Supported
    8.0 Supported Supported Supported
    Note For more information about how to use incremental backup for PolarDB clusters, see Enable binlogging.
  • PostgreSQL
    Note Set the database type to PostgreSQL when you purchase backup schedules.

    Logical backup

    Version Full backup Incremental backup Data restoration
    11 Supported Not supported Supported
  • Compatible with Oracle databases
    Note Set the database type to Oracle when you purchase backup schedules.

    Logical backup

    Version Full backup Incremental backup Data restoration
    9.3 Supported Not supported Supported
    10 Supported Not supported Supported

ApsaraDB for Redis

Redis

Logical backup

Version Full backup Incremental backup Data restoration
4.0 Supported Supported Supported
Note Only ApsaraDB for Redis instances of the Basic Edition can be backed up. ApsaraDB for Redis instances of the Cluster Edition cannot be backed up.
Database object Backup and restoration
String Supported
binary Supported
List Supported
Set Supported
Sorted set Supported
Hash Supported
Bit array Supported
HyperLogLog Supported
Geo Supported
Module Not supported

ApsaraDB for MongoDB

Logical backup

Mode Version Full backup Incremental backup Data restoration
Replica set 3.2 Supported Supported Supported
Replica set 3.4 Supported Supported Supported
Replica set 3.6 Supported Supported Supported
Replica set 4.0 Supported Supported Supported
Replica set 4.2 Supported Supported Supported
Sharded cluster 3.2 Supported Not supported Supported
Sharded cluster 3.4 Supported Not supported Supported
Sharded cluster 3.6 Supported Not supported Supported
Sharded cluster 4.0 Supported Not supported Supported
Sharded cluster 4.2 Supported Not supported Supported
Note Compatibility with MongoDB 3.0 and earlier has not been fully tested.
Database object Backup and restoration
Database Supported
Collection Supported
Index Supported
View Supported
Function Supported
User Supported
Role Supported
Note The admin database does not support backup.

On-premises databases, ECS-hosted databases, and databases on other clouds

  • MySQL
    • Logical backup
      Version Full backup Incremental backup Data restoration
      5.5 Supported Supported Supported
      5.6 Supported Supported Supported
      5.7 Supported Supported Supported
      8.0 Supported Supported Supported
      Note Incremental backup is supported only when binlogging is enabled for databases. Compatibility with MySQL 5.1 and earlier, Percona, and MariaDB has not been fully tested.
    • Physical backup
      Version Full backup Differential backup Incremental backup Data restoration
      5.5 Supported Supported Not supported Supported
      5.6 Supported Supported Not supported Supported
      5.7 Supported Supported Not supported Supported
      8.0 Supported Supported Not supported Supported
  • MariaDB

    Logical backup

    Version Full backup Incremental backup Data restoration
    10.0 Supported Supported Supported
    10.3 Supported Supported Supported
  • SQL Server
    Note Only SQL Server instances on Windows are supported.
    • Logical backup
      Version Full backup Incremental backup Data restoration
      2005 Supported Not supported Supported
      2008R2 Supported Not supported Supported
      2012 Supported Not supported Supported
      2014 Supported Not supported Supported
      2016 Supported Not supported Supported
      2017 Supported Not supported Supported
      Database object Backup and restoration
      Table Supported
      Index Supported
      View Supported
      Trigger Supported
      Stored procedure Supported
      User Supported
      Role Supported
      Constraint Supported
      UDF Supported
      Custom data type Supported
      Custom table type Supported
    • Physical backup
      Version Full backup Incremental backup Data restoration
      2000 Supported Supported Supported
      2005 Supported Supported Supported
      2008R2 Supported Supported Supported
      2012 Supported Supported Supported
      2014 Supported Supported Supported
      2016 Supported Supported Supported
      2017 Supported Supported Supported
  • PostgreSQL

    Logical backup

    Version Full backup Incremental backup Data restoration
    9.2 Supported Not supported Supported
    9.3 Supported Not supported Supported
    9.4 Supported Not supported Supported
    9.5 Supported Not supported Supported
    10 Supported Not supported Supported
    11 Supported Not supported Supported
    Database object Backup and restoration
    Table Supported
    Index Supported
    View Supported
    Function Supported
    Stored procedure Supported
    Constraint Supported
    Foreign key Supported
    Sequence Supported
    Rule Supported
    Domain Supported
    Extension Supported
    operator Supported
  • Oracle
    • Logical backup
      Version Full backup Incremental backup Data restoration
      9i Supported Not supported Supported
      10g Supported Not supported Supported
      11g Supported Not supported Supported
      12c Supported Not supported Supported
      Database object Backup and restoration
      Table Supported
      Index Supported
      View Supported
      Constraint Supported
      Foreign key Supported
      Sequence Supported
      Trigger Supported
      Function Supported
      Stored procedure Supported
      Synonym Supported
      Package Supported
      Data type Backup and restoration
      bfile Supported
      blob Supported
      char Supported
      date Supported
      double Supported
      float Supported
      integer Supported
      interval Supported
      long Supported
      long raw Supported
      nchar Supported
      nblob Supported
      number Supported
      nvchar Supported
      raw Supported
      rowid Supported
      timestamp Supported
      xml Supported
    • Physical backup
      Version Architecture Operating system Full backup Incremental backup Data restoration
      10g Single Instance and Data Guard Linux Supported Supported Supported
      11g Single Instance and Data Guard Linux Supported Supported Supported
      12c Single Instance and Data Guard Linux Supported Supported Supported
      18c Single Instance and Data Guard Linux Supported Supported Supported
      19c Single Instance and Data Guard Linux Supported Supported Supported
  • Redis
    Note Only ApsaraDB for Redis instances of the Basic Edition can be backed up. ApsaraDB for Redis instances of the Cluster Edition cannot be backed up.

    Logical backup

    Version Full backup Incremental backup Data restoration
    2.6 Supported Supported Supported
    2.8 Supported Supported Supported
    3.0 Supported Supported Supported
    3.2 Supported Supported Supported
    4.0 Supported Supported Supported
    Database object Backup and restoration
    String Supported
    binary Supported
    List Supported
    Set Supported
    Sorted set Supported
    Hash Supported
    Bit array Supported
    HyperLogLog Supported
    Geo Supported
    Module Not supported
  • MongoDB

    Logical backup

    Mode Version Full backup Incremental backup Data restoration
    Replica set 3.2 Supported Supported Supported
    Replica set 3.4 Supported Supported Supported
    Replica set 3.6 Supported Supported Supported
    Replica set 4.0 Supported Supported Supported
    Replica set 4.2 Supported Supported Supported
    Sharded cluster 3.2 Supported Not supported Supported
    Sharded cluster 3.4 Supported Not supported Supported
    Sharded cluster 3.6 Supported Not supported Supported
    Sharded cluster 4.0 Supported Not supported Supported
    Sharded cluster 4.2 Supported Not supported Supported
    Note Compatibility with MongoDB 3.0 and earlier has not been fully tested.
    Database object Backup and restoration
    Database Supported
    Collection Supported
    Index Supported
    View Supported
    Function Supported
    User Supported
    Role Supported
    Note The admin database does not support backup.

Second-level restoration

Database type Backup mode Second-level restoration
MySQL Physical backup Supported
Oracle Physical backup Supported

Fine-grained backup and restoration

Database type Backup mode Fine-grained backup Fine-grained restoration
MySQL Logical backup Table Table
MySQL Physical backup Instance Instance
SQL Server Logical backup Table Table
SQL Server Physical backup Database Database
Oracle Logical backup Table Table
Oracle Physical backup Instance Instance
PostgreSQL Logical backup Table Table
PPAS Logical backup Table Table

Backup set query

Database type Backup mode Feature scope
MySQL Logical backup Full backup set
SQL Server Logical backup Full backup set
Oracle Logical backup Full backup set
PostgreSQL Logical backup Full backup set
PPAS Logical backup Full backup set
Note For more information about backup set query, see Use SQL statements to query backup sets.

Backup set download

Database type Backup mode Storage type Feature type Feature scope
MySQL Logical backup Built-in storage Manual download
  • Full backup set: CSV files
  • Incremental backup set: native binlog files
MySQL Logical backup Built-in storage Automatic download
  • Full backup set: CSV files
  • Incremental backup set: native binlog files