I am very new to the Percona Toolkit and have been trying to test out table sync and checksum but I cant seem to get them to work. I have a 2 node test cluster. I have deleted a table on node 2 (slave) and wanted to see if checksum would pick it up. I ran the following command on the master
pt-table-checksum --replicate=percona.checksums --replicate-check-only --ignore-databases mysql h-localhost,u=user,p=password
I got the following error:
install_driver(mysql) failed: Attempt to reload DBD/mysql.pm aborted.
Compilation failed in require at (eval 23) line 3.
at /usr/bin/pt-table-checksum line 1581
When I run the same command on node 2 it runs just fine but since it is the salve it doesn’t see a problem.
So I check both mysql drivers and they are the same version.
So I am a little lost as to what the issues could be.
Please note I am running an older version of mysql on node 2 but I don’t think that would make a difference would it?
5.6.29-76.2 (Node1) 5.6.22-71.0 (Node2)