Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-481

LP #938068: pt-table-checksum doesn't warn if binlog_format=row or mixed on slaves

    XMLWordPrintable

    Details

      Description

      **Reported in Launchpad by Max Bowsher last update 15-01-2015 15:40:10

      If you use pt-table-checksum in --replicate mode on a replication topology like A --> B --> C, then pt-table-checksum will correctly change the binlog_format on A, but B will binlog the checksum queries in row format, which can lead to either false confidence thta C is checksummed correctly, or a break in replication between B and C.

      Perhaps pt-table-checksum should, if changing the binlog_format, also check whether any path-length-1 slaves have path-length-2 slaves, and error if this is the case, unless the user passes an option to say they acknowledge this problem exists.

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            lpjirasync lpjirasync (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Smart Checklist