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 Real-time synchronization principle

Supported Database Types

The following table lists the source database and destination database types supported by DRS in real-time synchronization.

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
	GaussDB(DWS)	Incremental Full Full+Incremental	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 MySQL databases ECS-hosted MySQL databases	CSS/ES	Full+Incremental	From MySQL to CSS/ES (self-built - self-built)
On-premises MySQL databases ECS-hosted MySQL databases	On-premises MySQL databases MySQL databases on ECSs	Incremental Full+Incremental	From MySQL to MySQL (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) NOTE: Only whitelisted users can use this function.	Full+Incremental	From PostgreSQL to GaussDB(DWS)
RDS for PostgreSQL	Kafka	Incremental	From PostgreSQL to Kafka (Out of the cloud)
RDS for PostgreSQL	On-premises PostgreSQL databases ECS-hosted PostgreSQL databases	Incremental Full Full+Incremental	From PostgreSQL to PostgreSQL (Out of the cloud)
On-premises PostgreSQL databases PostgreSQL databases on an ECS	Kafka	Incremental	From PostgreSQL to Kafka (self-built - self-built)
DDM	RDS for MySQL	Incremental Full Full+Incremental	From DDM to MySQL (To the cloud)
DDM	On-premises MySQL databases MySQL databases on an ECS MySQL databases on other clouds	Incremental Full Full+Incremental	From DDM to MySQL (Out of the cloud)
On-premises Oracle databases Oracle databases on ECSs	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)
	RDS for PostgreSQL	Full Full+Incremental	From Oracle to PostgreSQL
Cassandra	GeminiDB Cassandra	Full	From Cassandra to GeminiDB Cassandra
GaussDB Distributed	On-premises MySQL databases MySQL databases on an ECS MySQL databases on other clouds RDS for MySQL	Full Incremental Full+Incremental	From GaussDB Distributed to MySQL
	On-premises Oracle databases Oracle databases on an ECS	Full Incremental Full+Incremental	From GaussDB Distributed to Oracle
	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	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)
	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)
On-premises MariaDB databases MariaDB databases on an ECS MariaDB databases on other clouds	RDS for MariaDB	Full+Incremental	From MariaDB to MariaDB
RDS for MariaDB	On-premises MariaDB databases MariaDB databases on an ECS MariaDB databases on other clouds	Full+Incremental	From MariaDB to MariaDB

Parent topic: Real-Time Synchronization

Предыдущая статья

Real-Time Synchronization

Следующая статья

Data Synchronization Topologies

Была ли эта статья полезна?

Поддержка Юридические документы