pt-table-checksum alternatives

mareksogimareksogi Entrant 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 Reader Participant
    I am wondering the same thing.
  • jriverajrivera Percona Support Engineer Percona
    You can use the tool with --no-check-binlog-format so it will still work even on RBR format.
  • mareksogimareksogi Entrant 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
    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.