You can use Data Transmission Service (DTS) to synchronize data between homogeneous
and heterogeneous data sources. DTS provides the following extract, transform, and
load (ETL) capabilities: object name mapping for columns, tables, and databases, and
data filtering. The data synchronization feature is applicable to scenarios such as
active geo-redundancy, geo-disaster recovery, zone-disaster recovery, cross-border
data synchronization, query load balancing, cloud BI systems, and real-time data warehousing.
The following table lists the topics for configuring data synchronization in various
scenarios.
Data synchronization scenarios
For more information about the databases that are supported by data synchronization,
see.
| Scenario |
Topic |
| Synchronize data between MySQL databases |
Configure two-way data synchronization between ApsaraDB RDS for MySQL instances |
| Configure one-way data synchronization between ApsaraDB RDS for MySQL instances |
| Synchronize data from an ECS-hosted user-created MySQL instance to an ApsaraDB RDS for MySQL instance |
| Synchronize data from a user-created MySQL database connected over Express Connect, VPN Gateway, or Smart Access Gateway to an ApsaraDB RDS for MySQL instance |
| Synchronize data from an ApsaraDB RDS for MySQL instance to a user-created MySQL database connected over Express Connect, VPN Gateway, or Smart Access Gateway |
| Synchronize data between ApsaraDB RDS for MySQL instances that belong to different Alibaba Cloud accounts |
| Synchronize data from a MySQL database to a different type of database |
Synchronize data from an ApsaraDB RDS for MySQL instance to an Apsara PolarDB for MySQL cluster |
| Synchronize data from an ApsaraDB RDS for MySQL instance to an AnalyticDB for MySQL cluster |
| Synchronize data from an ApsaraDB RDS for MySQL instance to an AnalyticDB for PostgreSQL instance |
| Synchronize data from a user-created MySQL database hosted on ECS to an AnalyticDB for PostgreSQL instance |
| Synchronize data from a user-created MySQL database connected over Express Connect, VPN Gateway, or Smart Access Gateway to an AnalyticDB for PostgreSQL instance |
| Synchronize data from a user-created MySQL database hosted on ECS to Elasticsearch |
| Synchronize data from an ApsaraDB RDS MySQL instance to a MaxCompute project |
| Synchronize data from a user-created MySQL database to Message Queue for Apache Kafka |
| Synchronize data from an ApsaraDB RDS for MySQL instance to a user-created Kafka cluster |
| Synchronize data from a user-created MySQL database hosted on ECS to a user-created Kafka cluster |
| Synchronize data from a user-created MySQL database connected over Express Connect, VPN Gateway, or Smart Access Gateway to a user-created Kafka cluster |
| Synchronize data to or from a PolarDB cluster |
Configure two-way data synchronization between Apsara PolarDB for MySQL clusters |
| Configure one-way data synchronization between Apsara PolarDB for MySQL clusters |
| Synchronize data between PolarDB clusters compatible with Oracle |
| Synchronize data from an Apsara PolarDB for MySQL cluster to an ApsaraDB RDS for MySQL instance |
| Synchronize data from a PolarDB for MySQL cluster to an Elasticsearch cluster |
| Synchronize data from an Apsara PolarDB for MySQL cluster to a user-created Kafka cluster |
| Synchronize data from an Apsara PolarDB for MySQL cluster to an AnalyticDB for MySQL cluster |
| Synchronize data from a PolarDB for MySQL cluster to an AnalyticDB for PostgreSQL instance |
| Synchronize data from a user-created MySQL database hosted on ECS to an Apsara PolarDB for MySQL cluster |
| Synchronize data from a user-created MySQL database connected over Express Connect, VPN Gateway, or Smart Access Gateway to an Apsara PolarDB for MySQL cluster |
| Synchronize data to or from a DRDS instance |
Synchronize data between DRDS instances |
| Synchronize data from a DRDS instance to an AnalyticDB for MySQL cluster |
| Synchronize data from a DRDS instance to an AnalyticDB for PostgreSQL instance |
| Synchronize data between Redis databases |
Configure one-way data synchronization between ApsaraDB for Redis instances |
| Synchronize data between ApsaraDB for Redis cluster instances across Alibaba Cloud accounts |
| Configure two-way data synchronization between ApsaraDB for Redis Enhanced Edition instances |
| Synchronize data from a user-created Redis database hosted on ECS to an ApsaraDB for Redis instance |
| Synchronize data from a user-created Redis database connected over Express Connect, VPN Gateway, or Smart Access Gateway to a user-created Redis database hosted on ECS |
| Synchronize data from a user-created Redis cluster to an ApsaraDB for Redis cluster instance |
| Synchronize data from a Codis cluster hosted on ECS to an ApsaraDB for Redis instance |
| Synchronize data from a Twemproxy Redis cluster hosted on ECS to an ApsaraDB for Redis instance |
| Synchronize data between PostgreSQL databases |
Synchronize data from an ApsaraDB RDS for PostgreSQL instance to an AnalyticDB for PostgreSQL instance |
| Synchronize data from a user-created PostgreSQL database to an AnalyticDB for PostgreSQL instance |