This topic describes how to synchronize data from an ApsaraDB RDS for MySQL instance to a PolarDB for MySQL cluster by using Data Transmission Service (DTS).
Supported source databases
You can use DTS to synchronize data from the following types of MySQL databases to a PolarDB for MySQL cluster. This topic uses an ApsaraDB RDS for MySQL instance as an example to describe how to configure a data synchronization task. You can also follow the procedure to configure data synchronization tasks for other types of MySQL databases.- ApsaraDB RDS for MySQL instance
- Self-managed database that is hosted on Elastic Compute Service (ECS)
- Self-managed database that is connected over Express Connect, VPN Gateway, or Smart Access Gateway
- Self-managed database that is connected over Database Gateway
- Self-managed database that is connected over Cloud Enterprise Network (CEN)
Prerequisites
- The source ApsaraDB RDS for MySQL instance is created. For more information, see Create an ApsaraDB RDS for MySQL instance.
- The destination PolarDB for MySQL cluster is created. For more information, see Purchase a pay-as-you-go cluster and Purchase a subscription cluster.
- The available storage space of the PolarDB for MySQL cluster is larger than the total size of the data in the ApsaraDB RDS for MySQL instance.
Limits
Category | Description |
---|---|
Limits on the source database |
|
Other limits |
|
Special cases |
If the source database is a self-managed MySQL database, take note of the following
limits:
If you want to configure two-way data synchronization between a MySQL database and
a PolarDB for MySQL cluster, take note of the following limits:
Note You cannot create two-way data synchronization tasks in the new DTS console. To create
two-way data synchronization tasks, you can use the previous version of the DTS console.
|
Supported synchronization topologies
- One-way one-to-one synchronization
- One-way one-to-many synchronization
- One-way cascade synchronization
- One-way many-to-one synchronization
For more information, see Synchronization topologies.
SQL operations that can be synchronized
Operation type | SQL statements |
---|---|
DML | INSERT, UPDATE, and DELETE |
DDL |
|