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

pt-table-checksum not detecting diff

nhadsallnhadsall EntrantInactive User Role Novice
I have a very simple setup: 1 master with 2 replicas. I turned one of the replicas off and changed a row on the master. I ran
pt-table-checksum --databases=db_main --user=user --pass='pass'
but do not get and diffs. I read the documentation a few times, but can't seem to find what I might be missing.



  • BarrettBarrett Percona Percona Staff Role
    If the replica that you turned off is still down, then pt-table-checksum is not going to be able to check it.
    Once you turn it back on, it will likely replicate and you will be unable to view differences.
    You can test this by adding a delay to your replication setup, or change a row on a replica and run the checksum again.

    I hope this helps.
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.