Can the DM synchronization tool synchronize MySQL-MySQL or TiDB-TiDB?

This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: DM同步工具可以同步mysql-mysql 或者tidb-tidb吗?

| username: 舞动梦灵

Can the DM tool synchronize MySQL to MySQL and TiDB to TiDB with the same source and target databases?
I want to migrate historical data to the local data center, thinking of using the DM tool for real-time synchronization, then delete historical data from the source, and filter out DELETE operations through the local DM to achieve the goal. I have only done and know that DM is for MySQL to TiDB synchronization. Can it work with the same databases on both ends?

| username: xfworld | Original post link

TiDB Data Migration (DM) is a convenient data migration tool that supports full data migration and incremental data synchronization from databases compatible with the MySQL protocol (MySQL, MariaDB, Aurora MySQL) [upstream] to TiDB [downstream]. Using the DM tool helps simplify the data migration process and reduce data migration operation and maintenance costs.

For MySQL synchronization, using binlog is sufficient... 
For more advanced needs, you can use canal to receive events for custom processing, or handle it through Flink CDC.
For TiDB to TiDB, there is an official solution, TiCDC.

Please refer to...
| username: 舞动梦灵 | Original post link

I looked at the official CDC documentation and didn’t see that it supports filtering delete operations.

| username: xfworld | Original post link

Yes, you need to check the configuration file.

Refer to this:

| username: 舞动梦灵 | Original post link

Okay, thank you. I’ll give it a try and see the results.

| username: Fly-bird | Original post link


| username: 随缘天空 | Original post link

TiDB to TiDB is possible, you can refer to However, DM for MySQL to MySQL is not possible, as DM’s downstream database is TiDB. But you can try converting by generating SQL or CSV files to see if you can synchronize between two MySQL databases.

| username: tidb菜鸟一只 | Original post link

Is it necessary to use DM for MySQL to MySQL? Use CloudCanal instead.

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.