This topic describes how to synchronize data between PolarDB for MySQL clusters by using Data Transmission Service (DTS).
Prerequisites
- The source and destination PolarDB for MySQL clusters are created. For more information, see Purchase a pay-as-you-go cluster and Purchase a subscription cluster.
- The available storage space of the destination PolarDB for MySQL cluster is larger than the total size of the data in the source PolarDB for MySQL cluster.
Limits
Category | Description |
---|---|
Limits on the source database |
|
Other limits |
|
Special cases | If you want to configure two-way data synchronization between PolarDB for MySQL clusters,
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 |
|