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.
Source DB Engine |
Source DB Type and Version |
Destination DB Type and Version |
Migration Type |
---|---|---|---|
MySQL |
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 |
NOTE:
|
DDS Versions 3.4, 4.0, and 4.2 |
Full Full+Incremental migration supports the following scenarios:
NOTE:
|
NOTE:
|
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:
|
|
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:
|
MongoDB on other clouds Versions 3.2, 3.4, and 4.0 |
Full Full+Incremental migration supports the following scenarios:
|
||
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.
Backup File Version |
Destination DB Version |
Migration Method |
Backup File Source |
---|---|---|---|
On-premises and cloud Microsoft SQL Server backup file versions:
|
RDS for SQL Server
|
Full Incremental |
OBS bucket RDS full backup |
RDS for SQL Server full backup file versions:
|
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.
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 |
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 |
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:
|
|
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
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.
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.
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 |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.