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?

omhl February 11, 2015, 6:41pm 5

Hey guys,

Our production db are also setup in the same way using mixed. We use mixed due to needing to connect with SQL over linked server connections and other benefits.

Were you able to find the answer to OP’s question?

Thanks,
Oscar

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	617	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