11 Star 95 Fork 23

万里数据库 / gt-checksum

 / 详情

Not working with load on the replication source server

意向
需求
创建于  
2023-03-30 02:12

If there is workload on the replication source, the checksum will see a lot of differences due to the asynchronous nature of replication.

pt-table-checksum uses replication in STATEMENT base but I prefer to not use that binlog row format.

However to lower the differences, maybe you could try to use WAIT_FOR_EXECUTED_GTID_SET() (see https://dev.mysql.com/doc/refman/8.0/en/gtid-functions.html#function_wait-for-executed-gtid-set)

This will allow the checksum on the replica to wait for some missing transactions to be applied.

Of course GTID must be enabled.

评论 (2)

lefred 创建了需求

We expect to add this feature in future versions.
Thank you for your attention and suggestions.

登录 后才可以发表评论

状态
负责人
项目
里程碑
Pull Requests
关联的 Pull Requests 被合并后可能会关闭此 issue
分支
开始日期   -   截止日期
-
置顶选项
优先级
预计工期 (小时)
参与者(3)
8779455 greatsql 1615290631
Go
1
https://gitee.com/GreatSQL/gt-checksum.git
git@gitee.com:GreatSQL/gt-checksum.git
GreatSQL
gt-checksum
gt-checksum

搜索帮助