Synchronization Overview

Real-time synchronization refers to the real-time flow of key service data from sources to destinations through a synchronization instance 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.

Figure 1 Many-to-one real-time synchronization process

Supported Database Types

Table 1 lists the source database and destination database types supported by DRS in real-time migration.

**Table 1** Synchronization scheme
Source DB	Destination DB Type	Synchronization Mode	Related Documents
On-premises MySQL databases MySQL databases on an ECS MySQL databases on other clouds	RDS for MySQL	Incremental Full+Incremental	From MySQL to MySQL (To the cloud)
	GaussDB(for MySQL)	Incremental Full+Incremental NOTE: Only whitelisted users can perform the incremental synchronization.	From MySQL to GaussDB(for MySQL)
	RDS for PostgreSQL	Full Full+Incremental	From MySQL to PostgreSQL
	GaussDB distributed	Full+Incremental	From MySQL to GaussDB Distributed
	GaussDB primary/standby NOTE: Only whitelisted users can use this function.	Full+Incremental	From MySQL to GaussDB Primary/Standby
	GaussDB(DWS)	Incremental Full Full+Incremental NOTE: Only whitelisted users can perform the incremental synchronization.	From MySQL to GaussDB(DWS)
RDS for MySQL	On-premises MySQL databases MySQL databases on an ECS MySQL databases on other clouds	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)
	On-premises Oracle databases Oracle databases on an ECS	Full+Incremental	From MySQL to Oracle
On-premises MySQL databases MySQL databases on an ECS	Kafka	Incremental Full+Incremental	From MySQL to Kafka (self-built - self-built)
On-premises MySQL databases MySQL databases on an ECS	CSS/ES	Full+Incremental	From MySQL to CSS/ES (self-built - self-built)
On-premises PostgreSQL databases PostgreSQL databases on an ECS PostgreSQL databases on other clouds RDS for PostgreSQL	RDS for PostgreSQL	Incremental Full Full+Incremental	From PostgreSQL to PostgreSQL
	GaussDB(DWS)	Full+Incremental	From PostgreSQL to GaussDB(DWS)
	GaussDB primary/standby	Incremental Full Full+Incremental NOTE: Only whitelisted users can perform the incremental synchronization.	From PostgreSQL to GaussDB Primary/Standby
	GaussDB distributed	Incremental Full Full+Incremental NOTE: Only whitelisted users can perform the incremental synchronization.	From PostgreSQL to GaussDB Distributed
On-premises PostgreSQL databases PostgreSQL databases on an ECS	Kafka	Incremental	From PostgreSQL to Kafka (self-built - self-built)
RDS for PostgreSQL	Kafka	Incremental	From PostgreSQL to Kafka (Out of the cloud)
DDM	RDS for MySQL	Full+Incremental	From DDM to MySQL (To the cloud)
	On-premises MySQL databases MySQL databases on an ECS MySQL databases on other clouds	Full+Incremental	From DDM to MySQL (Out of the cloud)
	DDM	Full+Incremental	From DDM to DDM
	GaussDB(DWS)	Full+Incremental	From DDM to GaussDB(DWS)
	On-premises Oracle databases Oracle databases on an ECS	Full+Incremental	From DDM to Oracle
	Kafka	Incremental	From DDM to Kafka
On-premises Oracle databases Oracle databases on an ECS	RDS for MySQL	Full Full+Incremental	From Oracle to MySQL
	GaussDB(for MySQL)	Full Full+Incremental	From Oracle to GaussDB(for MySQL)
	RDS for PostgreSQL	Full Full+Incremental	From Oracle to PostgreSQL
	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	From Oracle to DDM
	GaussDB(DWS)	Full Full+Incremental	From Oracle to GaussDB(DWS)
	Kafka	Incremental	From Oracle to Kafka
GaussDB distributed	On-premises MySQL databases MySQL databases on an ECS MySQL databases on other clouds RDS for MySQL	Incremental	From GaussDB Distributed to MySQL
	On-premises Oracle databases Oracle databases on an ECS	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	From GaussDB Distributed to GaussDB(DWS)
	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
	GaussDB primary/standby NOTE: Only whitelisted users can use this function.	Full Incremental Full+Incremental	From GaussDB Distributed to GaussDB Primary/Standby
GaussDB primary/standby	On-premises MySQL databases MySQL databases on an ECS MySQL databases on other clouds RDS for MySQL NOTE: Only whitelisted users can use this function.	Full Incremental Full+Incremental	From GaussDB Primary/Standby to MySQL
	On-premises Oracle databases Oracle databases on an ECS	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	From GaussDB Primary/Standby to GaussDB(DWS)
	GaussDB distributed	Full Incremental Full+Incremental	From GaussDB Primary/Standby to GaussDB Distributed
	GaussDB primary/standby	Full Incremental Full+Incremental	From GaussDB Primary/Standby to GaussDB Primary/Standby
GaussDB(for MySQL)	On-premises MySQL databases MySQL databases on an ECS MySQL databases on other clouds RDS for MySQL	Incremental Full+Incremental	From GaussDB(for MySQL) to MySQL
	GaussDB(DWS)	Full+Incremental	From GaussDB(for MySQL) to GaussDB(DWS)
	Kafka	Incremental Full+Incremental	From GaussDB(for MySQL) to Kafka
	CSS/ES	Full+Incremental	From GaussDB(for MySQL) to CSS/ES
	On-premises Oracle databases Oracle databases on an ECS	Full+Incremental	From GaussDB(for MySQL) to Oracle
DDS	Self-built MongoDB MongoDB on other clouds	Incremental synchronization supports the following modes: Replica set -> Replica set Cluster -> Cluster (the source cluster version must be 4.0 or later)	From DDS to MongoDB
DB2 for LUW	GaussDB distributed NOTE: Only whitelisted users can use this function.	Full Full+Incremental	From DB2 for LUW to GaussDB Primary/Standby
	GaussDB primary/standby NOTE: Only whitelisted users can use this function.	Full Full+Incremental	From DB2 for LUW to GaussDB Distributed
	GaussDB(DWS) NOTE: Only whitelisted users can use this function.	Full Full+Incremental	From DB2 for LUW to GaussDB(DWS)
TiDB	GaussDB(for MySQL) NOTE: Only whitelisted users can use this function.	Full+Incremental	From TiDB to GaussDB(for MySQL)
On-premises Microsoft SQL Server database Microsoft SQL Server databases on an ECS Microsoft SQL Server databases on other clouds RDS for SQL Server	GaussDB(DWS) NOTE: Only whitelisted users can use this function.	Full+Incremental	From Microsoft SQL Server to GaussDB(DWS)
	GaussDB primary/standby NOTE: Only whitelisted users can use this function.	Full+Incremental	From Microsoft SQL Server to GaussDB Primary/Standby
	GaussDB distributed NOTE: Only whitelisted users can use this function.	Full+Incremental	From Microsoft SQL Server to GaussDB Distributed
	Microsoft SQL Server NOTE: Only whitelisted users can use this function.	Full+Incremental	From Microsoft SQL Server to Microsoft SQL Server
On-premises MongoDB databases MongoDB databases on an ECS MongoDB database on other clouds DDS	DDS	Full+Incremental synchronization supports the following scenarios: Replica set -> Replica set	From MongoDB to DDS

Next topic: Data Synchronization Topologies

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel