How to migrate changefeed in CDC using migration and upgrade method, and how to determine the TSO of the new and old clusters?

Translated
1

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

Original topic: 采用迁移升级的方式，cdc 里面的changefeed 如何迁移，如何确定新集群和旧集群的tso

| username: Tiny

【TiDB Usage Environment】Production Environment
【TiDB Version】Upgraded from v5.4.3 to v8.1.0
Using a migration upgrade method, set up a new 8.1.0 cluster and then migrate the data from the v5.4.3 cluster.
How to migrate the cdc changefeed in the 5.4.3 cluster? How to determine the start tso of the changefeed in the new cluster?

2
| username: 像风一样的男子 | Original post link

You can see the TSO of CDC synchronization in many places, such as logs and Grafana monitoring.

3
| username: 小于同学 | Original post link

Logs,

4
| username: wakaka | Original post link

If you migrate and upgrade, your 5.4.3 cluster and 8.1.0 cluster data will be completely consistent. Then you can directly use the current TSO to start the CDC changefeed in the 8.1.0 cluster.

5
| username: 小龙虾爱大龙虾 | Original post link

It’s fine to go back a bit, anyway, ticdc replication is idempotent.

6
| username: TIDB-Learner | Original post link

If it’s not a 24-hour business, create a new task in the new cluster after the data is fully consistent. Otherwise, you can get the start ts from logs, monitoring, etc.