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

LP #1103675: pt-table-checksum does not list slave hosts

Details

    • Bug
    • Status: Done
    • Low
    • Resolution: Invalid
    • None
    • None
    • None

    Description

      **Reported in Launchpad by Dimitriy last update 15-04-2014 12:44:30

      Someone has already reported that the tool does not fail when no slaves are detected. This bug is somewhat related to that bug.

      Please add an option to display all detected slaves in the output of pt-table-checksum tool. This would output results prior to running the checksum process.

      The output could look something like this (excluding begin/end lines):

          1. BEGIN OUTPUT ###
            Discovered slave hosts:
            SERVER_ID HOST PORT MASTER_ID
            2 hostname 3306 1

      Checksum results:
      TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
      01-23T12:18:17 0 0 0 1 0 0.160 db.table1
      01-23T12:18:17 0 0 1 1 0 0.030 db.table2
      01-23T12:18:18 0 0 0 1 0 0.037 db.table3

          1. END OUTPUT ###

      or like this:

          1. BEGIN OUTPUT ###
            SERVER_ID HOST PORT MASTER_ID
            2 hostname 3306 1

      TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
      01-23T12:18:17 0 0 0 1 0 0.160 db.table1
      01-23T12:18:17 0 0 1 1 0 0.030 db.table2
      01-23T12:18:18 0 0 0 1 0 0.037 db.table3

          1. END 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