I am using pt-table-sync to determine whether our replicated databases are in sync. All servers are running the same version of CentOS (6.2) and the same version of MySQL (Percona 5.5.20-55-log). The version of pt-table-sync we are using is 2.1.1.
Our replication setup is like this:
A -> B (high-speed connection)
B -> C (high-speed connection)
B -> D (LOW-speed connection)
D -> E (high-speed connection)
D -> F (high-speed connection)
Here’s the pt-table-sync command I am using:
pt-table-sync --print --wait 12000 --no-check-triggers
I have not had any problems using this command where there is a high-speed network connection, but I get the following error message every time I use it over our LOW-speed connection:
DBD::mysql::db commit failed: MySQL server has gone away at /usr/bin/pt-table-sync line 8821.
Issuing rollback() for database handle being DESTROY’d without explicit disconnect().
I have increased the “–wait” to the current 12000, but that does not seem to help.
Am I using the command incorrectly? Is there another parameter that I need to be using? I will appreciate any assistance.