All Products
Search
Document Center

Functionality matrix

Last Updated: Jun 18, 2020

ApsaraDB for POLARDB

MySQL

1. Logical backup

Version Full backup Incremental backup Data restore
5.6 Supported Supported Supported
8.0 Supported Supported Supported

Select MySQL as the database type when purchasing a DBS instance.For more information about incremental backup of ApsaraDB for POLARDB, see Enable binlogging.

PostgreSQL

1. Logical backup

Version Full backup Incremental backup Data restore
11 Supported Not supported Supported

Select PostgreSQL as the database type when purchasing a DBS instance.

Oracle

1. Logical backup

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

Select Oracle as the database type when purchasing a DBS instance.

ApsaraDB for RDS

MySQL

1. Logical backup

Version Full backup Incremental backup Data restore
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 the database.

MariaDB

1. Logical backup

Version Full backup Incremental backup Data restore
10.3 Supported Supported Supported

SQL Server

1. Logical backup

Version Full backup Incremental backup Data restore
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 restore
Table Supported
Index Supported
View Supported
Trigger Supported
Stored procedure Supported
User Supported
Role Supported
Constraint Supported
UDF Supported
Custom data Supported
Custom table Supported

PostgreSQL

1. Logical backup

Version Full backup Incremental backup Data restore
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 restore
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

1. Logical backup

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

ApsaraDB for Redis

Redis

1. Logical backup

Version Full backup Incremental backup Data restore
4.0 Supported Supported Supported

Note:

Currently, DBS only supports backing up a Basic Edition ApsaraDB for Redis instance. The Cluster Edition is not supported for the time being.

Database object Backup and restore
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

1. Logical backup

Mode Version Full backup Incremental backup Data restore
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
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

Note:

Compatibility with MongoDB 3.0 and earlier versions has not been fully tested.

Database object Backup and restore
Database Supported
Collection Supported
Index Supported
View Supported
Function Supported
User Supported
Role Supported

Note:

The admin database does not support backup.

ECS-hosted databases and others

MySQL

1. Logical backup

Version Full backup Incremental backup Data restore
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 the database. Compatibility with MySQL 5.1 and earlier versions, Percona, and MariaDB has not been fully tested.

2. Physical backup

Version Full backup Incremental backup Data restore
5.5 Supported Not supported Supported
5.6 Supported Not supported Supported
5.7 Supported Not supported Supported

Note:

For more information about physical backup, see Physical backup.

MariaDB

1. Logical backup

Version Full backup Incremental backup Data restore
10.0 Supported Supported Supported
10.3 Supported Supported Supported

SQL Server

1. Logical backup

Version Full backup Incremental backup Data restore
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 restore
Table Supported
Index Supported
View Supported
Trigger Supported
Stored procedure Supported
User Supported
Role Supported
Constraint Supported
UDF Supported
Custom data Supported
Custom table Supported

2. Physical backup

Version Full backup Incremental backup Data restore
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

Note:

For more information about physical backup, see Physical backup.

PostgreSQL

1. Logical backup

Version Full backup Incremental backup Data restore
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 restore
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

2. Physical backup

Note:

Currently, DBS does not support physical backup for PostgreSQL.

Oracle

1. Logical backup

Version Full backup Incremental backup Data restore
9i Supported Not supported Supported
10g Supported Not supported Supported
11g Supported Not supported Supported
12c Supported Not supported Supported
Database object Backup and restore
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 restore
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

2. Physical backup

Version Architecture Operating system Full backup Incremental backup Data restore
11g Single-instance Linux Supported Supported Supported

Redis

1. Logical backup

Version Full backup Incremental backup Data restore
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

Note:

Currently, DBS only supports backing up a Basic Edition ApsaraDB for Redis instance. The Cluster Edition is not supported for the time being.

Database object Backup and restore
String Supported
Binary Supported
List Supported
Set Supported
Sorted set Supported
Hash Supported
Bit array Supported
HyperLogLog Supported
Geo Supported
Module Not supported

2. Physical backup

Note:

Currently, DBS does not support physical backup for Redis.

MongoDB

1. Logical backup

Mode Version Full backup Incremental backup Data restore
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
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

Note:

Compatibility with MongoDB 3.0 and earlier versions has not been fully tested.

Database object Backup and restore
Database Supported
Collection Supported
Index Supported
View Supported
Function Supported
User Supported
Role Supported

Note:

The admin database does not support backup.

2. Physical backup

Note:

Currently, DBS does not support physical backup for MongoDB.

Backup set query

Database type Backup method 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

Backup set download

Database type Backup method 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