Does TiCDC support obtaining the upstream and downstream TSO relationship?

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

Original topic: TiCDC是否支持获取上下游TSO关系

| username: eastfisher

【TiDB Usage Environment】POC
【TiDB Version】v5
【Encountered Problem】Does TiCDC support a ts-map similar to TiDB Binlog to obtain the upstream and downstream TSO relationship? https://docs.pingcap.com/zh/tidb/stable/upstream-downstream-diff
【Reproduction Path】
【Problem Phenomenon and Impact】

| username: eastfisher | Original post link

Reading the source code is supported:

https://github.com/pingcap/tiflow/blob/master/cdc/sink/mysql/mysql_syncpoint_store.go#L201

You need to query through the downstream tidb_cdc.syncpoint_v1 table.

| username: xiaohetao | Original post link

According to the documentation, it is supported, and you can see the upstream in the downstream.

| username: xiaohetao | Original post link

Do you have any specific requirements? Are you looking to monitor upstream and downstream latency?

| username: eastfisher | Original post link

Thank you! Could you please send the document link?

| username: eastfisher | Original post link

Yes, monitoring upstream and downstream latency, and performing some data validation based on TSO.

| username: xiaohetao | Original post link

Are these two monitoring items not meeting the requirements?

| username: eastfisher | Original post link

It is necessary to obtain the upstream and downstream associated TSO.

| username: eastfisher | Original post link

I have compiled the solution into a blog post: 专栏 - 基于TiCDC同步的主从集群数据校验 | TiDB 社区

| username: xiaohetao | Original post link

:+1::+1::+1:

| username: xiaohetao | Original post link

Impressive, impressive.

| username: alfred | Original post link

Learned, :+1:

| username: wisdom | Original post link

Impressive, impressive.

| username: system | Original post link

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