This topic describes how to synchronize data between ApsaraDB RDS for MySQL instances by using Data Transmission Service (DTS).
Supported source and destination databases
You can use DTS to synchronize data between the following types of source and destination MySQL databases. This topic describes how to synchronize data between ApsaraDB RDS for MySQL instances. You can also follow the procedure to configure data synchronization tasks for other types of MySQL databases.Source database | Destination database |
---|---|
|
|
Prerequisites
- The source and destination ApsaraDB RDS for MySQL instances are created. For more information, see Create an ApsaraDB RDS for MySQL instance.
- The available storage space of the destination ApsaraDB RDS for MySQL instance is larger than the total size of the data in the source 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 MySQL databases, 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
- Two-way one-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 |
|