any way to tell ptchecksum to skip a replica server

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:

http://www.percona.com/doc/percona-toolkit/2.2/pt-table-checksum.html#cmdoption-pt-table-checksum–recursion-method

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!