Comment 3 for bug 1373937

Revision history for this message
Andrey Ilyin (jemmix) wrote :

Frank, thank you for your response. However, like I said in the original message, in our specific use case, we don't need pt-table-checksum to actually figure out if there are any inconsistencies. We need it to fill in the checksums table on every node, to be checked later by another script written in-house. To fill in the checksums table, it doesn't actually need to know if there are any other nodes in the cluster. It can send its queries to one node and they will get replicated. This scheme works well for us in non-XtraDB Cluster setups we have.

I realise we can add a --replication-method=cluster argument (which doesn't work with non-cluster setups) or fill in the dsns table for pt-table-checksum to use but this is working around the problem. This way, pt-table-checksum would work slower because it'd have to query the other cluster nodes, and we're dismissing its output anyway because we have another solution to figure out if there are any discrepancies between servers in the replication setup.