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 |
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 |
Full+Incremental |
||
GaussDB primary/standby |
Full+Incremental |
From MySQL to GaussDB Primary/Standby (To the cloud) From MySQL to GaussDB Primary/Standby (self-built - self-built) |
|
GaussDB(DWS) |
Incremental Full Full+Incremental
NOTE:
Only whitelisted users can perform the incremental data synchronization. |
||
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 |
||
|
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) |
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
NOTE:
Only whitelisted users can perform the incremental data synchronization. |
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) |
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) |
Incremental Full Full+Incremental |
||
Kafka |
Incremental |
||
GaussDB distributed |
|
Full Incremental Full+Incremental |
|
|
Full Incremental Full+Incremental |
From GaussDB Distributed to Oracle (Out of the cloud) From GaussDB Distributed to Oracle (self-built - self-built) |
|
GaussDB(DWS) |
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 |
||
GaussDB primary/standby |
|
Full Incremental Full+Incremental |
|
|
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) |
Full Incremental Full+Incremental |
||
GaussDB distributed |
Full Incremental Full+Incremental |
||
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) |
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) |
|
GaussDB(DWS) |
Full Full+Incremental |
||
TiDB |
GaussDB(for MySQL)
NOTE:
Only whitelisted users can use this function. |
Full+Incremental |
|
|
GaussDB(DWS) |
Full+Incremental |
|
GaussDB primary/standby |
Full+Incremental |
||
GaussDB distributed |
Full+Incremental |
||
Microsoft SQL Server
NOTE:
Only whitelisted users can use this function. |
Full+Incremental |
||
|
DDS |
Full+Incremental synchronization supports the following scenarios: Replica set -> Replica set |
|
|
RDS for MariaDB |
Full+Incremental |
|
RDS for MariaDB |
|
Full+Incremental |
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