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

Install and use the Percona Toolkit in the slave?

maverick28maverick28 EntrantCurrent User Role Beginner
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.

Comments

  • miguelangelnietomiguelangelnieto Member Inactive User Role Beginner
    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.
  • maverick28maverick28 Entrant Current User Role Beginner
    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?
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.