[FR] Add recursion-method=dsn in pt-table-sync

Reported by Przemek on 2013-11-21
14
This bug affects 3 people
Affects Status Importance Assigned to Milestone
Percona Toolkit
Undecided
Unassigned

Bug Description

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.

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers