Updated on 2023-07-03 GMT+08:00

Supported Databases

DRS supports data flows between different DB engines. This section lists the supported databases in real-time migration, backup migration, real-time synchronization, data subscription, and real-time DR.

Real-Time Migration

You can migrate all database objects across cloud platforms, from on-premises databases to the cloud, or across regions on the cloud in real time. Table 1 lists the supported databases, versions, and migration types. For more information about real-time migration, see Real-Time Migration.

Self-built databases (such as MySQL and MongoDB) refer to on-premises databases and databases created on an ECS. RDS for MySQL refers to the MySQL databases on an RDS instance.

  • Some functions are only available for whitelisted users. To use these functions, submit a service ticket. In the upper right corner of the management console, choose Service Tickets > Create Service Ticket.
  • Data cannot be migrated from a newer version database to an older version database.
Table 1 Database information

Source DB Engine

Source DB Type and Version

Destination DB Type and Version

Migration Type

MySQL

  • On-premises MySQL databases

    Versions 5.5, 5.6, 5.7, and 8.0

  • MySQL databases built on other clouds

    Versions 5.5, 5.6, 5.7, and 8.0

RDS for MySQL

All versions

Full

Full+Incremental

DDM

The same version as that of the associated RDS instance.

Full

Full+Incremental

GaussDB(for MySQL)

Compatible with MySQL 8.0

Full

Full+Incremental

RDS for MySQL

All versions

RDS for MySQL

All versions

Full

Full+Incremental

Self-built or other cloud MySQL

Versions 5.6, 5.7, and 8.0

Full

Full+Incremental

DDM

The same version as that of the associated RDS instance.

Full

Full+Incremental

GaussDB(for MySQL)

Compatible with MySQL 8.0

Full

Full+Incremental

MongoDB

  • Self-built MongoDB

    Versions 3.2, 3.4, and 4.0

  • MongoDB on other clouds

    Versions 3.2, 3.4, and 4.0

  • DDS

    Versions 3.4 and 4.0

NOTE:
  • The source does not support GaussDB(for Mongo).

DDS

Versions 3.4, 4.0, and 4.2

Full

Full+Incremental migration supports the following scenarios:

  • Replica set -> Replica set
  • Replica set -> Cluster
  • Cluster -> Cluster
NOTE:
  • If the source is a DDS cluster instance, the incremental migration can only be performed in the VPC network.
  • To perform a full plus incremental migration for a single node instance, the source database must be on the HUAWEI CLOUD.
  • Self-built MongoDB

    Versions 3.2, 3.4, and 4.0

  • MongoDB on other clouds

    Versions 3.2, 3.4, and 4.0

  • DDS

    Versions 3.4 and 4.0

NOTE:
  • The source does not support GaussDB(for Mongo).

GaussDB(for Mongo)

Versions 3.4 and 4.0

NOTE:

Only whitelisted users can use this function.

Full

Full+Incremental migration supports the following scenarios:

  • Replica set -> Replica set
  • Replica set -> Cluster
  • Cluster -> Cluster
    NOTE:

    If the source is a DDS cluster, only full migration is supported.

DDS

DDS

Versions 3.2, 3.4, and 4.0

Self-built MongoDB

Versions 3.2, 3.4, and 4.0

Full

Full+Incremental migration supports the following scenarios:

  • Replica set -> Single node
  • Replica set -> Replica set
  • Replica set -> Cluster
  • Single node -> Single node
  • Single node -> Replica set
  • Single node -> Cluster

MongoDB on other clouds

Versions 3.2, 3.4, and 4.0

Full

Full+Incremental migration supports the following scenarios:

  • Replica set -> Single node
  • Replica set -> Replica set
  • Replica set -> Cluster
  • Single node -> Single node
  • Single node -> Replica set
  • Single node -> Cluster

MySQL schema and logic table

DDM

DDM

Full

Full+Incremental

Redis

Self-built open-source single-node Redis

Versions 2.8.x, 3.0.x, 3.2.x, 4.0.x, and 5.0.x

GaussDB(for Redis)

NOTE:

Only whitelisted users can use this function.

Full

Full+Incremental

GaussDB(for Redis)

Self-built open-source Codis

Version 3.0 or later

NOTE:

Only whitelisted users can use this function.

Full+Incremental

Backup Migration

You can export data from the source database to a backup file, upload the backup file to OBS, and then restore the backup file to the destination database. In this way, data migration can be complete without exposing your source database to the Internet. Table 2 lists the supported databases, versions, and migration types. For more information about backup migration, see Backup Migration.

  • Data cannot be migrated from a newer version database to an older version database.
Table 2 Database information

Backup File Version

Destination DB Version

Migration Method

Backup File Source

On-premises and cloud Microsoft SQL Server backup file versions:

  • Microsoft SQL Server 2000
  • Microsoft SQL Server 2005
  • Microsoft SQL Server 2008
  • Microsoft SQL Server 2012
  • Microsoft SQL Server 2014
  • Microsoft SQL Server 2016
  • Microsoft SQL Server 2017
  • Microsoft SQL Server 2019

RDS for SQL Server

  • Microsoft SQL Server 2008
  • Microsoft SQL Server 2012
  • Microsoft SQL Server 2014
  • Microsoft SQL Server 2016
  • Microsoft SQL Server 2017
  • Microsoft SQL Server 2019

Full

Incremental

OBS bucket

RDS full backup

RDS for SQL Server full backup file versions:

  • Microsoft SQL Server 2008
  • Microsoft SQL Server 2012
  • Microsoft SQL Server 2014
  • Microsoft SQL Server 2016
  • Microsoft SQL Server 2017
  • Microsoft SQL Server 2019

Full

Incremental

OBS bucket

RDS full backup

Real-Time Synchronization

Real-time synchronization refers to the process of copying data from one data source to another database while keeping data consistency. In this way, the data of key services can flow in real time. Table 3 lists the supported databases, versions, and synchronization types. For more information about real-time synchronization, see Real-Time Synchronization.

Self-built databases (such as MySQL, Oracle, and PostgreSQL) refer to on-premises databases and databases created on an ECS. RDS for MySQL refers to the MySQL databases on an RDS instance.

  • Some functions are only available for whitelisted users. To use these functions, submit a service ticket. In the upper right corner of the management console, choose Service Tickets > Create Service Ticket.
  • Data cannot be migrated from a newer version database to an older version database.
Table 3 Database information

Source DB Engine

Source DB Type and Version

Destination DB Type and Version

Synchronization Mode

MySQL

Self-built or other cloud MySQL

Versions 5.5, 5.6, 5.7, and 8.0

RDS for MySQL

All versions

Incremental

Full+Incremental

GaussDB(for MySQL)

Version 8.0

Incremental

Full+Incremental

NOTE:

Only whitelisted users can perform the incremental synchronization.

RDS for PostgreSQL

Versions 9.5, 9.6, 10, and 11

Full

Full+Incremental

GaussDB distributed

Version 1.0.0 or later

Full+Incremental

GaussDB primary/standby

Version 1.0.0 or later

NOTE:

Only whitelisted users can use this function.

Full+Incremental

GaussDB(DWS)

Version 8.1.3

Incremental

Full

Full+Incremental

NOTE:

Only whitelisted users can perform the incremental synchronization.

Kafka

Version 0.11 or later

Incremental

Full+Incremental

CSS/ES

ElasticSearch 5.5, 6.2, 6.5, 7.1, 7.6, 7.9 and 7.10

Full+Incremental

RDS for MySQL

All versions

RDS for MySQL

All versions

Incremental

Full+Incremental

Self-built or other cloud MySQL

Versions 5.6, 5.7, and 8.0

Incremental

Full+Incremental

GaussDB(for MySQL)

Version 8.0

Incremental

Full+Incremental

NOTE:

Only whitelisted users can perform the incremental synchronization.

RDS for PostgreSQL

Versions 9.5, 9.6, 10, and 11

Full

Full+Incremental

GaussDB distributed

Version 1.0.0 or later

Full+Incremental

GaussDB primary/standby

Version 1.0.0 or later

NOTE:

Only whitelisted users can use this function.

Full+Incremental

GaussDB(DWS)

Version 8.1.3

Incremental

Full

Full+Incremental

NOTE:

Only whitelisted users can perform the incremental synchronization.

Kafka

Version 0.11 or later

Incremental

Full+Incremental

CSS/ES

ElasticSearch 5.5, 6.2, 6.5, 7.1, 7.6, 7.9 and 7.10

Full+Incremental

Self-built Oracle

Versions 10g, 11g, 12c, 18c, and 19c

Full+Incremental

PostgreSQL

  • Self-built PostgreSQL

    Versions 9.4, 9.5, 9.6, 10, 11, 12, 13, and 14

  • RDS for PostgreSQL

    Versions 9.5, 9.6, 10, 11, 12, 13, and 14

  • PostgreSQL on other clouds

    Versions 9.4, 9.5, 9.6, 10, 11, 12, 13, and 14

RDS for PostgreSQL

Versions 9.5, 9.6, 10, 11, 12, 13, and 14

Incremental

Full

Full+Incremental

NOTE:

Only whitelisted users can perform the incremental synchronization.

GaussDB(DWS)

Full+Incremental

GaussDB primary/standby

Incremental

Full

Full+Incremental

NOTE:

Only whitelisted users can perform the incremental synchronization.

GaussDB distributed

Incremental

Full

Full+Incremental

NOTE:

Only whitelisted users can perform the incremental synchronization.

Kafka

Version 0.11 or later

Incremental

DDM

DDM

RDS for MySQL

Versions 5.6 and 5.7

Full+Incremental

Self-built or other cloud MySQL

Versions 5.6 and 5.7

Full+Incremental

DDM

Full+Incremental

GaussDB(DWS)

Full+Incremental

Self-built Oracle

Versions 10g, 11g, 12c, 18c, and 19c

Full+Incremental

Kafka

Version 0.11 or later

Incremental

Oracle

Oracle

Versions 10g, 11g, 12c, 18c, and 19c

RDS for MySQL

All versions

Full

Full+Incremental

GaussDB(for MySQL)

Version 8.0

Full

Full+Incremental

RDS for PostgreSQL

Versions 9.5, 9.6, 10, 11, and 12

Full

Full+Incremental

GaussDB primary/standby

Version 1.0.0 or later

Incremental

Full

Full+Incremental

GaussDB distributed

Version 1.0.0 or later

Incremental

Full

Full+Incremental

DDM

Full

Full+Incremental

GaussDB(DWS)

Full

Full+Incremental

Kafka

Version 0.11 or later

Incremental

GaussDB distributed

GaussDB distributed

Version 1.1.0 or later

RDS for MySQL

Versions 5.6 and 5.7

Incremental

Self-built or other cloud MySQL

Versions 5.5, 5.6, and 5.7

Incremental

Self-built Oracle

Versions 11g and 19c

Full

Incremental

Full+Incremental

GaussDB(DWS)

Full

Incremental

Full+Incremental

NOTE:

Only whitelisted users can perform the full+incremental synchronization.

Kafka

Version 0.11 or later

Incremental

GaussDB distributed

Version 1.1.0 or later

Full

Incremental

Full+Incremental

GaussDB primary/standby

Version 1.1.0 or later

NOTE:

Only whitelisted users can use this function.

Full

Incremental

Full+Incremental

GaussDB primary/standby

GaussDB primary/standby

Version 1.3 or later

RDS for MySQL

Versions 5.6 and 5.7

NOTE:

Only whitelisted users can use this function.

Full

Incremental

Full+Incremental

Self-built or other cloud MySQL

Versions 5.5, 5.6, and 5.7

NOTE:

Only whitelisted users can use this function.

Full

Incremental

Full+Incremental

Oracle

Full

Incremental

Full+Incremental

Kafka

Version 0.11 or later

Incremental

GaussDB(DWS)

Full

Incremental

Full+Incremental

GaussDB distributed

Version 1.1.0 or later

Full

Incremental

Full+Incremental

GaussDB primary/standby

Version 1.1.0 or later

Full

Incremental

Full+Incremental

GaussDB(for MySQL)

GaussDB(for MySQL)

Version 8.0

RDS for MySQL

Version 8.0

Incremental

Full+Incremental

Self-built or other cloud MySQL

Version 8.0

Incremental

Full+Incremental

GaussDB(DWS)

Full+Incremental

Kafka

Version 0.11 or later

Incremental

Full+Incremental

CSS/ES

ElasticSearch 5.5, 6.2, 6.5, 7.1, 7.6, 7.9 and 7.10

Full+Incremental

Self-built Oracle

Versions 10g, 11g, 12c, 18c, and 19c

Full+Incremental

MongoDB

  • Self-built MongoDB

    Versions 3.2, 3.4, and 4.0

  • MongoDB on other clouds

    Versions 3.2, 3.4, and 4.0

  • DDS

    Versions 3.4 and 4.0

    NOTE:

    The source does not support GaussDB(for Mongo).

DDS

Versions 3.4, 4.0, and 4.2

NOTE:

DDS 4.2 can be used as the destination database only in the cloud migration scenario.

Full+Incremental migration supports the following scenarios:

  • Replica set -> Replica set

DDS

DDS

Versions 3.2, 3.4, and 4.0

Self-built MongoDB

Versions 3.2, 3.4, and 4.0

Incremental synchronization supports the following modes:

Replica set -> Replica set

Cluster -> Cluster (the source cluster version must be 4.0 or later)

MongoDB on other clouds

Versions 3.2, 3.4, and 4.0

Incremental synchronization supports the following modes:

Replica set -> Replica set

Cluster -> Cluster (the source cluster version must be 4.0 or later)

DB2 for LUW

DB2 for LUW

Versions 9.7, 10.1, 10.5, 11.1, and 11.5

GaussDB distributed

Version 1.1.0 or later

NOTE:

Only whitelisted users can use this function.

Full

Full+Incremental

GaussDB primary/standby

Version 1.1.0 or later

NOTE:

Only whitelisted users can use this function.

Full

Full+Incremental

GaussDB(DWS)

Full

Full+Incremental

TiDB

TiDB

Version 4.0.0 and later (excluding the development version)

GaussDB(for MySQL)

Version 8.0

NOTE:

Only whitelisted users can use this function.

Full+Incremental

Microsoft SQL Server

Microsoft SQL Server

Enterprise Edition 2012 or later

Standard Edition 2016 SP1 or later

GaussDB(DWS)

NOTE:

Only whitelisted users can use this function.

Full+Incremental

GaussDB distributed

Version 1.1.0 or later

NOTE:

Only whitelisted users can use this function.

Full+Incremental

GaussDB primary/standby

Version 1.1.0 or later

NOTE:

Only whitelisted users can use this function.

Full+Incremental

RDS for SQL Server

  • Enterprise Edition 2012 or later
  • Standard Edition 2016 SP1 or later
NOTE:

Only whitelisted users can use this function.

Full+Incremental

Data Subscription

Data subscription is used to obtain data changes of key services in the database. DRS caches the data changes and provides a unified SDK interface for downstream services to subscribe to, obtain, and consume the changes. Table 4 describes the supported databases and data types. For details about data subscription, see Data Subscription.

Table 4 Database information

DB Engine

Data Type

RDS for MySQL

Versions 5.6 and 5.7

  • Data update
  • Structure update

Real-Time Disaster Recovery

To prevent service unavailability caused by regional faults, DRS provides disaster recovery to ensure service continuity. Table 5 lists the databases and versions supported by real-time DR. For more information about real-time DR, see Real-Time Disaster Recovery.

Self-built databases (for example, MySQL) refer to on-premises databases and the databases created on an ECS. RDS for MySQL refers to the MySQL databases on an RDS instance.

  • Some functions are only available for whitelisted users. To use these functions, submit a service ticket. In the upper right corner of the management console, choose Service Tickets > Create Service Ticket.
  • Data cannot be migrated from a newer version database to an older version database.
Table 5 Database information

Service DB Engine

Service DB Type and Version

DR DB Type and Version

MySQL

Self-built or other cloud MySQL

Versions 5.6, 5.7, and 8.0

RDS for MySQL

All versions

GaussDB(for MySQL)

Version 8.0

RDS for MySQL

All versions

RDS for MySQL

All versions

Self-built or other cloud MySQL

Versions 5.6, 5.7, and 8.0

GaussDB(for MySQL)

Version 8.0

DDM

DDM

DDM

GaussDB(for MySQL)

GaussDB(for MySQL)

Version 8.0

GaussDB(for MySQL)

Version 8.0