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.

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

Supported Database Types

The following table 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)
	RDS for PostgreSQL	Full Full+Incremental	From MySQL to PostgreSQL
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)
	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 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
On-premises Oracle databases Oracle databases on an ECS	RDS for MySQL	Full Full+Incremental	From Oracle to MySQL
	RDS for PostgreSQL	Full Full+Incremental	From Oracle to PostgreSQL
	Kafka	Incremental	From Oracle to Kafka