We have a replica we use for testing. We’d like to keep is from being checked by ptchecksum. I know we can limit what tables and what databases are checked, but I don’t see a way to skip a replica server? Is there?
Hi Epinc;
To only check certain slaves you can use the “dsn” recursion method:
[url]pt-table-checksum — Percona Toolkit Documentation
The downside to this is that you need to specify all slaves to check, so if you have a large number of slaves or if they change frequently that could become burdensome. However this is the only method I know of to skip specific slaves.
-Scott
Exactly what I need actually. Thanks!