[FR] Add recursion-method=dsn in pt-table-sync
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Triaged
|
Wishlist
|
Frank Cizmich |
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-
Please, implement --recursion-
Changed in percona-toolkit: | |
status: | Confirmed → Triaged |
importance: | Undecided → Wishlist |
assignee: | nobody → Frank Cizmich (frank-cizmich) |
Thank you for the reasonable feature request