Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.
Original topic: DM同步工具可以同步mysql-mysql 或者tidb-tidb吗？
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?
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...
I looked at the official CDC documentation and didn’t see that it supports filtering delete operations.
Yes, you need to check the configuration file.
Refer to this:
Okay, thank you. I’ll give it a try and see the results.
TiDB to TiDB is possible, you can refer to https://docs.pingcap.com/zh/tidb/stable/migrate-from-tidb-to-tidb. 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.
Is it necessary to use DM for MySQL to MySQL? Use CloudCanal instead.
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.
|
username: 舞动梦灵
|
username: 
|
username: 
|
username: 
|
username: 
|
username: