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

LP #1169853: pt-table-checksum: recursion method default is not correct for clusters

Details

    Description

      **Reported in Launchpad by Daniƫl van Eeden last update 12-11-2013 12:01:38

      The documentation says that the default recursion method is "processlist,hosts", but this does not seem to be true.

      The "cluster" recursion method also seems to be used.

      This can be tested by running pt-table-checksum on:

      • a 3 node PXC setup which uses MySQL Replication to replicate to another 3 node PXC setup.
      • Then run pt-table-checksum against the node which has the master role in the MySQL Replication setup.

      Expected result:
      pt-table-checksum detects "regular" mysql replication with 1 master and 1 slave.

      Actual result:
      Cluster setup is detected
      "xxx is a cluster node but no other nodes or regular replicas were found. Use --recursion-method=dsn to specify the other nodes in the cluster."

      According to PT_DEBUG output it does connect to the slave.
      I can't upload PT_DEBUG output.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist