Buy Percona ServicesBuy Now!

pt-table-checksum alternatives

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • pt-table-checksum alternatives

    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!

  • #2
    I am wondering the same thing.

    Comment


    • #3
      You can use the tool with --no-check-binlog-format so it will still work even on RBR format.

      Comment


      • #4
        Originally posted by jrivera View Post
        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

        Comment


        • #5
          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.

          Comment

          Working...
          X