This topic describes how to synchronize data from an ApsaraDB RDS for MySQL instance to a PolarDB-X V2.0 instance 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-X V2.0 instance. 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
- A PolarDB-X V2.0 instance is created and the storage type is MySQL 5.x.
- The available storage space of the PolarDB-X V2.0 instance is larger than the total size of the data in the ApsaraDB RDS for MySQL instance.
Limits
Category | Description |
---|---|
Limits on the source database |
|
Precautions |
|
Special cases |
If the source database is a self-managed MySQL database, take note of the following
limits:
|
Supported synchronization topologies
- One-way one-to-one synchronization
- One-way many-to-one synchronization
SQL operations that can be synchronized
Operation type | SQL statements |
---|---|
DML | INSERT, UPDATE, and DELETE |
DDL |
|