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

LP #1253537: [FR] Add recursion-method=dsn in pt-table-sync

    Details

      Description

      **Reported in Launchpad by Przemek last update 27-04-2015 15:20:32

      In some cases, available recursion methods in pt-table-sync are not capable of discovering the slave hosts. The mysqlsandbox replication sandbox is a good example, where both TCP port and report_host are custom:

      master [localhost]

      {msandbox} ((none)) > show processlist;
      --------------------------------------------------------------------------------------------------------------------------------------------------------------------
      | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined | Rows_read |
      --------------------------------------------------------------------------------------------------------------------------------------------------------------------
      | 1 | rsandbox | localhost:49943 | NULL | Binlog Dump | 73470 | Master has sent all binlog to slave; waiting for binlog to be updated | NULL | 0 | 0 | 0 |
      | 2 | rsandbox | localhost:49944 | NULL | Binlog Dump | 73468 | Master has sent all binlog to slave; waiting for binlog to be updated | NULL | 0 | 0 | 0 |
      | 125 | msandbox | localhost | NULL | Query | 0 | NULL | show processlist | 0 | 0 | 0 |
      --------------------------------------------------------------------------------------------------------------------------------------------------------------------
      3 rows in set (0.00 sec)

      master [localhost] {msandbox}

      ((none)) > show slave hosts;
      ---------------------------------+

      Server_id Host Port Master_id

      ---------------------------------+

      101 SBslave1 23189 1
      102 SBslave2 23190 1

      ---------------------------------+
      2 rows in set (0.00 sec)

      In the same case, you can successfully use --recursion-method=dsn=... in pt-table-checksum.

      Please, implement --recursion-method=dsn also in pt-table-sync.

        Attachments

          Expenses

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                3 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: