Synchronization Overview
Real-time synchronization refers to the real-time flow of key service data from sources to destinations while consistency of data can be ensured.
It is different from migration. Migration means moving your overall database from one platform to another. Synchronization refers to the continuous flow of data between different services.
You can use real-time synchronization in many scenarios such as real-time analysis, report system, and data warehouse environment.
Real-time synchronization is mainly used for synchronizing tables and data. It can meet various requirements, such as many-to-one, one-to-many synchronization, dynamic addition and deletion of tables, and synchronization between tables with different names.
Supported Database Types
The following table lists the source database and destination database types supported by DRS in real-time synchronization.
|
Source DB Type |
Destination DB Type |
Synchronization Mode |
Related Documents |
|---|---|---|---|
|
RDS for MySQL |
Incremental Full Full+Incremental |
From MySQL to MySQL (To the cloud) |
|
GaussDB(for MySQL) |
Incremental Full+Incremental |
||
|
RDS for PostgreSQL |
Full Full+Incremental |
||
|
GaussDB distributed |
Incremental Full Full+Incremental |
From MySQL to GaussDB Distributed (To the cloud) From MySQL to GaussDB Distributed (self-built - self-built) |
|
|
GaussDB primary/standby |
Incremental Full Full+Incremental |
From MySQL to GaussDB Primary/Standby (To the cloud) From MySQL to GaussDB Primary/Standby (self-built - self-built) |
|
|
GaussDB(DWS)
NOTE:
This service is currently not supported. Use DataArts Studio for data synchronization. |
Incremental Full Full+Incremental |
||
|
RDS for MariaDB |
Incremental Full Full+Incremental |
From MySQL to MariaDB (To the cloud) |
|
|
RDS for MySQL |
|
Incremental Full+Incremental |
From MySQL to MySQL (Out of the cloud) |
|
Kafka |
Incremental Full+Incremental |
From MySQL to Kafka (Out of the cloud) |
|
|
CSS/ES |
Full+Incremental |
From MySQL to CSS/ES (Out of the cloud) |
|
|
Full+Incremental |
||
|
Incremental Full Full+Incremental |
From MySQL to MariaDB (Out of the cloud) |
|
|
Kafka |
Incremental Full+Incremental |
From MySQL to Kafka (self-built - self-built) |
|
CSS/ES |
Full+Incremental |
From MySQL to CSS/ES (self-built - self-built) |
|
|
RDS for PostgreSQL |
Incremental Full Full+Incremental |
|
|
GaussDB(DWS)
NOTE:
Only whitelisted users can use this function. |
Full+Incremental |
||
|
GaussDB primary/standby |
Incremental Full Full+Incremental
NOTE:
Only whitelisted users can perform the incremental data synchronization. |
||
|
GaussDB distributed |
Incremental Full Full+Incremental
NOTE:
Only whitelisted users can perform the incremental data synchronization. |
||
|
Kafka |
Incremental |
From PostgreSQL to Kafka (self-built - self-built) |
|
RDS for PostgreSQL |
|
Incremental Full Full+Incremental |
From PostgreSQL to PostgreSQL (Out of the cloud) |
|
Kafka |
Incremental |
From PostgreSQL to Kafka (Out of the cloud) |
|
|
DDM |
RDS for MySQL |
Incremental Full Full+Incremental |
From DDM to MySQL (To the cloud) |
|
Incremental Full Full+Incremental |
From DDM to MySQL (Out of the cloud) |
|
|
DDM |
Full+Incremental |
||
|
GaussDB(DWS)
NOTE:
This service is currently not supported. Use DataArts Studio for data synchronization. |
Full+Incremental |
||
|
Incremental Full Full+Incremental |
||
|
Kafka |
Incremental |
||
|
RDS for MySQL |
Incremental Full Full+Incremental |
|
|
GaussDB(for MySQL) |
Full Full+Incremental |
||
|
RDS for PostgreSQL |
Full Full+Incremental |
||
|
GaussDB primary/standby |
Incremental Full Full+Incremental |
From Oracle to GaussDB Primary/Standby (To the cloud) From Oracle to GaussDB Primary/Standby (self-built - self-built) |
|
|
GaussDB distributed |
Incremental Full Full+Incremental |
From Oracle to GaussDB Distributed (To the cloud) From Oracle to GaussDB Distributed (self-built - self-built) |
|
|
DDM |
Full Full+Incremental |
||
|
GaussDB(DWS)
NOTE:
Only whitelisted users can use this function. |
Incremental Full Full+Incremental |
||
|
Kafka |
Incremental |
||
|
GaussDB distributed |
|
Full Incremental Full+Incremental |
From GaussDB Distributed to MySQL (Out of the cloud) From GaussDB Distributed to MySQL (self-built - self-built) |
|
Full Incremental Full+Incremental |
From GaussDB Distributed to Oracle (Out of the cloud) From GaussDB Distributed to Oracle (self-built - self-built) |
|
|
GaussDB(DWS)
NOTE:
Only whitelisted users can use this function. |
Full Incremental Full+Incremental |
||
|
Kafka |
Incremental |
From GaussDB Distributed to Kafka (Out of the cloud) From GaussDB Distributed to Kafka (self-built - self-built) |
|
|
GaussDB distributed |
Full Incremental Full+Incremental |
From GaussDB Distributed to GaussDB Distributed From GaussDB Distributed to GaussDB Distributed (self-built - self-built) |
|
|
GaussDB primary/standby |
Full Incremental Full+Incremental |
From GaussDB Distributed to GaussDB Primary/Standby (Out of the cloud) From GaussDB Distributed to GaussDB Primary/Standby (self-built - self-built) |
|
|
GaussDB primary/standby |
|
Full Incremental Full+Incremental |
From GaussDB Primary/Standby to MySQL (Out of the cloud) From GaussDB Primary/Standby to MySQL (self-built - self-built) |
|
Full Incremental Full+Incremental |
From GaussDB Primary/Standby to Oracle (Out of the cloud) From GaussDB Primary/Standby to Oracle (self-built - self-built) |
|
|
Kafka |
Incremental |
From GaussDB Primary/Standby to Kafka (Out of the cloud) From GaussDB Primary/Standby to Kafka (self-built - self-built) |
|
|
GaussDB(DWS)
NOTE:
Only whitelisted users can use this function. |
Full Incremental Full+Incremental |
||
|
GaussDB distributed |
Full Incremental Full+Incremental |
From GaussDB Primary/Standby to GaussDB Distributed (Out of the cloud) From GaussDB Primary/Standby to GaussDB Distributed (self-built - self-built) |
|
|
GaussDB primary/standby |
Full Incremental Full+Incremental |
From GaussDB Primary/Standby to GaussDB Primary/Standby From GaussDB Primary/Standby to GaussDB Primary/Standby (self-built - self-built) |
|
|
GaussDB(for MySQL) |
GaussDB(for MySQL) |
Incremental Full+Incremental |
|
|
Incremental Full+Incremental |
||
|
GaussDB(DWS)
NOTE:
This service is currently not supported. Use DataArts Studio for data synchronization. |
Full+Incremental |
||
|
Kafka |
Incremental Full+Incremental |
||
|
CSS/ES |
Full+Incremental |
||
|
Full+Incremental |
||
|
DDS |
|
Incremental synchronization supports the following modes: Replica set -> Replica set Cluster -> Cluster (the source cluster version must be 4.0 or later) |
|
|
Kafka |
Incremental |
||
|
DB2 for LUW |
GaussDB distributed |
Full Full+Incremental |
From DB2 for LUW to GaussDB Primary/Standby (To the cloud) From DB2 for LUW to GaussDB Primary/Standby (self-built - self-built) |
|
GaussDB primary/standby |
Full Full+Incremental |
From DB2 for LUW to GaussDB Distributed (To the cloud) From DB2 for LUW to GaussDB Distributed (self-built - self-built) |
|
|
TiDB |
GaussDB(for MySQL) |
Full+Incremental |
|
|
GaussDB(DWS)
NOTE:
Only whitelisted users can use this function. |
Full+Incremental |
|
|
GaussDB primary/standby |
Incremental Full Full+Incremental |
||
|
GaussDB distributed |
Incremental Full Full+Incremental |
||
|
Microsoft SQL Server |
Full+Incremental |
||
|
RDS for MySQL
NOTE:
Only whitelisted users can use this function. |
Incremental Full Full+Incremental |
||
|
GaussDB(for MySQL)
NOTE:
Only whitelisted users can use this function. |
Incremental Full Full+Incremental |
||
|
PostgreSQL
NOTE:
Only whitelisted users can use this function. |
Incremental Full Full+Incremental |
||
|
RDS for SQL Server |
Kafka
NOTE:
Only whitelisted users can use this function. |
Incremental |
From Microsoft SQL Server to Kafka (Out of the cloud) |
|
Kafka
NOTE:
Only whitelisted users can use this function. |
Incremental |
From Microsoft SQL Server to Kafka (self-built - self-built) |
|
DDS |
Full+Incremental synchronization supports the following scenarios: Replica set -> Replica set |
|
|
RDS for MariaDB |
Full+Incremental |
|
|
RDS for MySQL |
Incremental Full+Incremental |
|
|
GaussDB(for MySQL) |
Incremental Full+Incremental |
||
|
RDS for MariaDB |
|
Full+Incremental |
|
|
Cassandra |
GeminiDB Cassandra |
Full |
|
|
DynamoDB on other clouds (web services) |
GeminiDB Dynamo
NOTE:
Only whitelisted users can use this function. |
Full Full+Incremental |
|
|
GeminiDB Redis
NOTE:
Only whitelisted users can use this function. |
Full Full+Incremental |
|
|
GeminiDB Redis
NOTE:
Only whitelisted users can use this function. |
Full+Incremental |
|
|
GeminiDB Redis |
NOTE:
Only whitelisted users can use this function. |
Full+Incremental |
|
|
Full+Incremental |
Other Cloud Synchronization Solutions
DRS allows you to synchronize data from other cloud databases (such as AWS RDS for MySQL and Aurora for MySQL) to Huawei Cloud databases (such as RDS for MySQL).
|
Source Database Cloud Vendor |
Source Database Type |
Destination Database (Huawei Cloud) |
Solution |
|---|---|---|---|
|
AWS |
RDS for MySQL |
RDS for MySQL |
|
|
AWS |
RDS for MySQL |
GaussDB(for MySQL) |
|
|
AWS |
Aurora for MySQL |
RDS for MySQL |
|
|
AWS |
Aurora for MySQL |
GaussDB(for MySQL) |
|
|
AWS |
RDS for MariaDB |
RDS for MariaDB |
|
|
AWS |
RDS for PostgreSQL |
RDS for PostgreSQL |
|
|
AWS |
Aurora for PostgreSQL (Non-serverless) |
RDS for PostgreSQL |
|
|
AWS |
RDS for Oracle |
GaussDB Primary/Standby |
|
|
AWS |
RDS for Oracle |
GaussDB Distributed |
|
|
AWS |
RDS for SQL Server |
RDS for SQL Server |
|
|
AWS |
RDS for SQL Server |
GaussDB Primary/Standby |
|
|
AWS |
RDS for SQL Server |
GaussDB Distributed |
|
|
Azure |
Database for MySQL |
RDS for MySQL |
|
|
Azure |
Database for MySQL |
GaussDB(for MySQL) |
|
|
Azure |
Database for MariaDB |
RDS for MariaDB |
|
|
Azure |
Database for PostgreSQL |
RDS for PostgreSQL |
|
|
Azure |
SQL Server on Azure Virtual Machines |
RDS for SQL Server |
|
|
Azure |
Azure SQL Database(DB) |
RDS for SQL Server |
|
|
Azure |
Azure SQL Managed Insatnce(MI) |
RDS for SQL Server |
|
|
Azure |
SQL Server on Azure Virtual Machines |
GaussDB Primary/Standby |
|
|
Azure |
Azure SQL Database(DB) |
GaussDB Primary/Standby |
|
|
Azure |
Azure SQL Managed Insatnce(MI) |
GaussDB Primary/Standby |
|
|
Azure |
SQL Server on Azure Virtual Machines |
GaussDB Distributed |
|
|
Azure |
Azure SQL Database(DB) |
GaussDB Distributed |
|
|
Azure |
Azure SQL Managed Insatnce(MI) |
GaussDB Distributed |
|
|
|
Cloud SQL for MySQL |
RDS for MySQL |
|
|
|
Cloud SQL for MySQL |
GaussDB(for MySQL) |
|
|
|
Cloud SQL for PostgreSQL |
RDS for PostgreSQL |
|
|
Alibaba Cloud |
ApsaraDB RDS for MySQL |
RDS for MySQL |
|
|
Alibaba Cloud |
ApsaraDB RDS for MySQL |
GaussDB(for MySQL) |
|
|
Alibaba Cloud |
PolarDB for MySQL |
RDS for MySQL |
|
|
Alibaba Cloud |
PolarDB for MySQL |
GaussDB(for MySQL) |
|
|
Alibaba Cloud |
ApsaraDB RDS for MariaDB |
RDS for MariaDB |
|
|
Alibaba Cloud |
ApsaraDB RDS for PostgreSQL |
RDS for PostgreSQL |
|
|
Alibaba Cloud |
PolarDB for PostgreSQL Standard Edition and Enterprise Edition |
RDS for PostgreSQL |
|
|
Tencent Cloud |
TencentDB for MySQL |
RDS for MySQL |
|
|
Tencent Cloud |
TencentDB for MySQL |
GaussDB(for MySQL) |
|
|
Tencent Cloud |
TDSQL-C for MySQL |
RDS for MySQL |
|
|
Tencent Cloud |
TDSQL-C for MySQL |
GaussDB(for MySQL) |
|
|
Tencent Cloud |
TencentDB for PostgreSQL |
RDS for PostgreSQL |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot
