To use pt-table-checksum on a cluster you have to specify a "--recursion-method".
This must be either "cluster" or "dsn".
If you set it to "none" the tool will not try to discover any other node. I suspect that with your fix, the tool ran without error, but was unable to find any differences because it didn't find the other nodes.
The easiest method to use is --recursion-method=cluster , since this will autodiscover all the other nodes; BUT... you must make sure that every node has a distinct server_id, otherwise , repeated server_id's will be discarded!
( very soon we'll post a fix for this, but for the moment the server_id's must be different )
The other method is "dsn", which is a bit more involved and requires creating a table with information about the addresses of all the nodes and informing the tool the location of that table via the dsn parameter. Same restriction applies though, server_id's must be different!
Hi Andrey,
To use pt-table-checksum on a cluster you have to specify a "--recursion- method" .
This must be either "cluster" or "dsn".
If you set it to "none" the tool will not try to discover any other node. I suspect that with your fix, the tool ran without error, but was unable to find any differences because it didn't find the other nodes.
The easiest method to use is --recursion- method= cluster , since this will autodiscover all the other nodes; BUT... you must make sure that every node has a distinct server_id, otherwise , repeated server_id's will be discarded!
( very soon we'll post a fix for this, but for the moment the server_id's must be different )
The other method is "dsn", which is a bit more involved and requires creating a table with information about the addresses of all the nodes and informing the tool the location of that table via the dsn parameter. Same restriction applies though, server_id's must be different!
You can find info about this here: www.percona. com/doc/ percona- toolkit/ 2.2/pt- table-checksum. html#cmdoption- pt-table- checksum- -recursion- method
http://