Install and use the Percona Toolkit in the slave?

[maverick28]

Hi,

I am considering to use the toolkit to make checks on the integrity of one replication (1 master, 1 slave) but i don’t know if it is possible to use in the slave, ¿is it possible?

I want to do this because the master is a windows server 2008 and the slave is a ubuntu 12.04 and, as far i understand, it’s not possible to install it in a windows OS.

[miguelangelnieto]

Hi,

You can install percona toolkit on the slave server but then you have to run pt-table-checksum against the master server. That is possible because pt-table-checksum can connect to remote servers. The usage is:

pt-table-checksum [OPTIONS] [DSN]

so from the slave you can run:

pt-table-checksum h=ip_of_the_master,u=user,p=password

Regards.

[maverick28]

Thanks for the answer, now i’m testing it with some extra options:

I’m using it and it only shows the following again and again:

It’s been almost 50 min. since it started, and i have only 4 databases very small and with almost no users making changes

Also the master is mysql 5.1 and the slave is mysql 5.5.

So now my question is, ¿what is making that, at least aparently, it’s not doing anything:
the difference between versions or maybe the innodb_lock_wait_timeout=50 on both servers or is another thing?