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

pt-table-checksum alternatives

mareksogimareksogi EntrantInactive User Role Participant
Hey all.
We are in need of tool, which will be checking replication data for consistency. This tool would be great, but its limitation is ROW/MIXED based replication doesn't work...
Do you guys have any idea of possible alternatives?
Many thanks in advance!

Comments

  • sydneysydney Entrant Legacy User Role Participant
    I am wondering the same thing.
  • jriverajrivera Percona Support Engineer Percona Staff Role
    You can use the tool with --no-check-binlog-format so it will still work even on RBR format.
  • mareksogimareksogi Entrant Inactive User Role Participant
    jrivera wrote: »
    You can use the tool with --no-check-binlog-format so it will still work even on RBR format.

    ok, what if we do have master-master topology? Will it break the replication?
    If yes, what could be the issue? It is going to be something just like Duplicate entry error? Or we will need to start over with slave?
    Thanks
  • jriverajrivera Percona Support Engineer Percona Staff Role
    It should not break replication however you should take extra precaution when running the tool on a master-master topology. If at all possible we recommend you to test on some staging environment first.
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.