Not the answer you need?
Register and ask your own question!

Does pt-table-checksum follow slaves in a 2-hop ("chained") replication?

SQLGuySQLGuy ContributorCurrent User Role Beginner
We've been using pt-table-checksum for several years to check replication consistency. Just recently we started getting errors for slaves that are 2 hops away from the master. I was under the impression that pt-table-checksum only checks a master and its IMMEDIATE (i.e. 1 hop) slaves. I looked through the documentation and googled for a while but couldn't find anything saying whether pt-table-checksum finds all slaves in a chained replication topology. Can someone clarify this issue? btw, we are using the "hosts" method of slave discovery in case that makes any difference.


Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.