Hello there, I have 3 masters in circular replication. I run pt-table-checksum in one of the masters only. A->B->C->A The queries do get replicated the “next” server B but I don’t think they are being replicated “properly” to the third server C. The checksums are always identical to the B server. …

Does pt-table-checksum work in circular replication environments?

psong January 9, 2015, 1:56am 2

Please check binlog_format on server B. If it is row-based, then that would be the reason for server C to always have identical checksum to B while it should not.

Topic		Replies	Views
can pt-table-checksum support row-based replication Percona Toolkit	1	2243	June 20, 2013
A bug for pt-table-checksum Percona Toolkit mysql , percona	10	1220	September 2, 2022
pt-table-checksum alternatives Percona Toolkit	1	618	October 24, 2018
pt-table-checksum not working as supposed in mixed format replication Percona Toolkit	4	1460	December 8, 2017
pt-table-checksum with replicate_do_db Percona Toolkit	2	756	April 4, 2016

Does pt-table-checksum work in circular replication environments?

Related topics