Not the answer you need?
Register and ask your own question!

pt-table-checksum/sync issue with MySQL driver

mrunrealmrunreal EntrantCurrent User Role Beginner
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.
perl-DBD-MySQL-4.013-3.el6.x86_64

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)
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.