Issue with TiDB Binlog Synchronizing Data to MySQL in Batches

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

Original topic: tidb binlog分批同步数据到mysql中问题

| username: 刘亚欣1

[TiDB Usage Environment] Production Environment
[TiDB Version]
[Reproduction Path]
Use TiDB Binlog to batch synchronize data from TiDB to MySQL.
Enable drainer1 to synchronize part of the database from tidb1 to mysql1;
Enable drainer2 to synchronize another part of the database from tidb1 to mysql1;
[Encountered Problem: Problem Phenomenon and Impact]
Drainer status in tidb:


tidb_binlog.checkpoint in mysql:

Question: The checkpoint table in mysql does not distinguish between the two synchronization tasks and only has one checkpoint record. When pausing/restarting one drainer, will it affect each other and cause inaccurate data? How should this situation be handled?

[Resource Configuration]
[Attachment: Screenshot/Log/Monitoring]

| username: weixiaobing | Original post link

Drainer can configure different checkpoint schemas.

| username: 刘亚欣1 | Original post link

[syncer.to.checkpoint]
type = “mysql”
schema = “tidb_binlog_2”
host = “xxx”
user = “admin”
password = “xxx”
port = 60788

| username: system | Original post link

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