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

Does pt-table-checksum need access to the slave?

mbramptonmbrampton EntrantCurrent User Role Beginner
This sems an awfully dumb question, but I can't see the answer to it. Does pt-table-checksum need access to the slave? Every time I run it, a message is displayed "Diffs cannot be detected because no slaves were found". It seems happy that it is connecting to the local (master) DB, and if I connect to the DB, then processlist includes:
1884 | replicator | localhost:57545 | NULL | Binlog Dump | 108036 | Master has sent all binlog to slave; waiting for binlog to be updated | NULL
and show slave hosts gives:
101 | | 3306 | 1
Now it is certainly not possible to connect to the slave. It is heavily firewalled with an SSH tunnel to the master which will not work in the opposite direction. (All deliberate!) Is it possible to run pt-table-checksum in that environment, or do I have to provide the ability to connect to the slave?

Comments

  • carlos.salguerocarlos.salguero Percona Toolkit Developer Percona Staff Role
    Hi,

    You can specify to skip checking the slaves.


    According to the documentation here:
    The none method makes the tool ignore all slaves and cluster nodes. This method is not recommended because it effectively disables the “REPLICA CHECKS” and no differences can be found. It is useful, however, if you only need to write checksums on the master or a single cluster node. The safer alternative is --no-replicate-check: the tool finds replicas and cluster nodes, performs the “REPLICA CHECKS”, but does not check for differences. See --[no]replicate-check.

    Regards
  • mbramptonmbrampton Entrant Current User Role Beginner
    Is that a "yes"?
  • carlos.salguerocarlos.salguero Percona Toolkit Developer Percona Staff Role
    Yo can run it but it won't generate diff against the slaves.
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.