How to Implement Real-time Synchronization of the tt Table in the aa Database of TiDB to the aa Table in the bb Database of MySQL

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

Original topic: tidb aa库的tt表 实时同步到mysql中的bb库aa表如何实施

| username: kevinkelly1898

[TiDB Usage Environment] Poc
[TiDB Version] 5.4.3
[Problem Encountered: How to implement real-time synchronization of the tt table in the aa database of TiDB to the aa table in the bb database of MySQL]
The PUMP cluster has been set up.

| username: TiDBer_pkQ5q1l0 | Original post link

It seems that TiDB Binlog synchronization does not support this type of synchronization mapping.

| username: TiDBer_pkQ5q1l0 | Original post link

DM can configure filtering rules, but the upstream is MySQL, and TiCDC also does not have synchronization mapping, so it seems that your requirement cannot be achieved.

| username: 啦啦啦啦啦 | Original post link

TiCDC + Kafka

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

The above can be implemented.

| username: Kongdom | Original post link

Is the data volume large? If not, use the ETL tool Kettle to implement it. :thinking: