Real-Time Synchronization
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.
Supported Database Types
DRS supports real-time synchronization between databases of various types, and many-to-one synchronization.
Synchronization Direction |
Data Flow |
Source DB |
Destination DB |
Destination DB Type |
---|---|---|---|---|
To the cloud |
MySQL->MySQL |
|
RDS for MySQL DB instances |
|
To the cloud |
MySQL->PostgreSQL |
|
RDS PostgreSQL DB instances |
|
To the cloud |
MySQL -> GaussDB Centralized |
|
GaussDB Centralized |
|
To the cloud |
PostgreSQL->PostgreSQL |
|
RDS PostgreSQL DB instances |
|
To the cloud |
Oracle->PostgreSQL |
|
RDS PostgreSQL DB instances |
|
To the cloud |
Oracle->MySQL |
|
RDS for MySQL DB instances |
|
To the cloud |
Oracle->TaurusDB |
|
TaurusDB |
|
To the cloud |
Oracle -> GaussDB Centralized |
|
GaussDB Centralized |
Centralized |
To the cloud |
Oracle -> GaussDB Distributed |
|
GaussDB Distributed |
Cluster |
To the cloud |
Oracle->DDM |
|
DDM |
- |
To the cloud |
DDM->MySQL |
DDM |
RDS for MySQL DB instances |
|
To the cloud |
DDM->DDM |
DDM |
DDM |
Cluster |
To the cloud |
MongoDB->DDS |
|
DDS instances |
Replica set |
To the cloud |
TaurusDB->TaurusDB |
TaurusDB |
TaurusDB |
|
From the cloud |
MySQL->MySQL |
RDS for MySQL DB instances |
|
- |
From the cloud |
MySQL->Kafka |
RDS for MySQL DB instances |
|
|
From the cloud |
MySQL->Oracle |
RDS for MySQL DB instances |
|
- |
From the cloud |
DDM->MySQL |
DDM |
|
|
From the cloud |
DDM->Oracle |
DDM |
|
- |
From the cloud |
DDM->Kafka |
DDM |
Kafka |
|
From the cloud |
DDS->MongoDB |
DDS instances |
|
|
From the cloud |
DDS->Kafka |
DDS instances |
Kafka |
|
From the cloud |
GaussDB Centralized -> MySQL |
GaussDB Centralized |
|
- |
From the cloud |
GaussDB Centralized -> Oracle |
GaussDB Centralized |
|
- |
From the cloud |
GaussDB Centralized -> Kafka |
GaussDB Centralized |
Kafka |
|
From the cloud |
GaussDB Distributed -> Kafka |
GaussDB Distributed |
Kafka |
|
From the cloud |
GaussDB Distributed -> GaussDB Distributed |
GaussDB Distributed |
GaussDB Distributed |
Cluster |
From the cloud |
GaussDB Distributed -> GaussDB Centralized |
GaussDB Distributed |
GaussDB Centralized |
Cluster |
From the cloud |
TaurusDB->MySQL |
TaurusDB |
|
- |
From the cloud |
TaurusDB->Kafka |
TaurusDB |
Kafka |
|
From the cloud |
TaurusDB->Oracle |
TaurusDB |
|
- |
Self-built -> Self-built |
Oracle->Kafka |
|
Kafka |
|
Self-built -> Self-built |
Oracle -> GaussDB Centralized |
|
GaussDB Centralized |
|
Self-built -> Self-built |
MySQL->Kafka |
|
|
|
Self-built -> Self-built |
GaussDB Centralized -> GaussDB Centralized |
GaussDB Centralized |
GaussDB Centralized |
Cluster |
Self-built -> Self-built |
GaussDB Distributed -> GaussDB Distributed |
GaussDB Distributed |
GaussDB Distributed |
Cluster |
Self-built -> Self-built |
GaussDB Distributed -> GaussDB Centralized |
GaussDB Distributed |
GaussDB Centralized |
Cluster |
Synchronization Methods
DRS supports three synchronization modes: full synchronization, incremental synchronization, and full+incremental synchronization.
Full synchronization: All objects and data in non-system databases are synchronized to the destination database at a time. This mode is applicable to scenarios where service interruption is acceptable.
Incremental synchronization: Through log parsing, DRS replicates incremental data to keep sources and destinations in sync.
Full+Incremental synchronization: DRS allows you to synchronize data in real time. After a full synchronization initializes the destination database, an incremental synchronization parses logs to ensure data consistency between the source and destination databases.
Synchronization Direction |
Data Flow |
Incremental |
Full |
Full+Incremental |
One-way/Two-way Sync |
---|---|---|---|---|---|
To the cloud |
MySQL->MySQL |
Supported |
Supported |
Supported |
One-way sync |
To the cloud |
PostgreSQL->PostgreSQL |
Supported |
Supported |
Supported |
One-way sync |
To the cloud |
DDM->MySQL |
Supported |
Supported |
Supported |
One-way sync |
From the cloud |
MySQL->MySQL |
Supported |
Not supported |
Supported |
One-way sync |
From the cloud |
DDM->MySQL |
Supported |
Supported |
Supported |
One-way sync |
Database Versions

Data cannot be synchronized from a newer version database to an older version database.
Synchronization Direction |
Data Flow |
Source Database Version |
Destination DB Version |
---|---|---|---|
To the cloud |
MySQL->MySQL |
|
|
To the cloud |
PostgreSQL->PostgreSQL |
|
|
To the cloud |
DDM->MySQL |
Based on the live network |
|
From the cloud |
MySQL->MySQL |
|
|
From the cloud |
DDM->MySQL |
Based on the live network |
|
Network Types
DRS supports real-time synchronization through a Virtual Private Cloud (VPC), Virtual Private Network (VPN), Direct Connect, or public network. Table 4 lists the application scenarios of each network type and required preparations.
Synchronization Direction |
Data Flow |
VPC |
Public Network |
VPN or Direct Connect |
---|---|---|---|---|
To the cloud |
MySQL->MySQL |
Supported |
Supported |
Supported |
To the cloud |
PostgreSQL->PostgreSQL |
Supported |
Supported |
Supported |
To the cloud |
DDM->MySQL |
Supported |
Supported |
Supported |
From the cloud |
MySQL->MySQL |
Supported |
Supported |
Supported |
From the cloud |
DDM->MySQL |
Supported |
Supported |
Supported |
Supported Synchronization Objects
DRS allows you to synchronize different objects. The following table lists the supported objects.
Synchronization Direction |
Data Flow |
Table-level |
Database-level |
Importing an Object File |
---|---|---|---|---|
To the cloud |
MySQL->MySQL |
Supported |
Supported |
Supported |
To the cloud |
PostgreSQL->PostgreSQL |
Supported |
Supported |
Supported |
To the cloud |
DDM->MySQL |
Supported |
Not supported |
Not supported |
From the cloud |
MySQL->MySQL |
Supported |
Supported |
Not supported |
From the cloud |
DDM->MySQL |
Supported |
Not supported |
Not supported |
Advanced Features
DRS supports multiple features to ensure successful data synchronization.
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