TiDB binlog synchronization to downstream MySQL, no data generated in the checkpoint table

Translated
1

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

Original topic: TiDB binlog同步到下游mysql,checkpoint表没数据产生

| username: gary

【TiDB Usage Environment】Testing environment
【TiDB Version】
v5.4.0
【Encountered Issue】
TiDB binlog synchronizes incremental data to downstream MySQL. The downstream MySQL can receive the data, but no data is generated in the checkpoint table.
There are no errors in drainer.log
image

2
| username: hey-hoho | Original post link

Please share the configuration of drainer.

3
| username: gary | Original post link

drainer.log (18.2 KB)

4
| username: hey-hoho | Original post link

The log contains ["write save point"], indicating that the savepoint was saved successfully. Check if there is a savepoint file in the drainer data directory.

5
| username: gary | Original post link

There is no savepoint file in the drainer data directory.

6
| username: hey-hoho | Original post link

Please provide the configuration file for drainer, including the parameters in the YAML file.

7
| username: gary | Original post link

The image cannot be translated directly. Please provide the text content for translation.

8
| username: hey-hoho | Original post link

Try adding the checkpoint configuration: