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

pt-table-checksum Not checking replication lag...

jjengel11jjengel11 EntrantCurrent User Role Patron
when running pt-table-checksum on a master/slave setup I get this output

Not checking replica lag on hostname because it is a cluster node

there are table differences and the output of the script is not showing the differences. what is that message that is displayed? it is not a cluster node but a slave. I am running this command on the master and it finds the right hostname of the slave but thinks it is a cluster setup?????

pt-table-checksum version is 2.1.4 and percona version 5.5.29

my command is : pt-table-checksum -u user -ppassword --databases test

i have also tried : pt-table-checksum -u user -ppassword --databases test --recursion-method dsn=h=host2,P=3306,u=user,p=pword,D=test,t=junk

and i get dbd::mysql::db selectcol_arrayref failed unknown column 'dsn' in field list' [for Statement "SELECT dsn FROM test.junk order by id

how can i run this tool to show me the differences in the tables? also why does it think the 2nd node is a cluster node and not a slave??

thanks

Comments

  • henn9438henn9438 Entrant Current User Role Beginner
    Try to run pt-table-checksum with
  • mirfanmirfan Database Administrator Inactive User Role Beginner
    Did you tried with latest version of pt-table-checksum ? You may also want to run with PTDEBUG=1 it will generate lots of debug output and will help to identify problem.
    Moreover, your second command with --recursion_method doesn't seems correct. You need to create dsns table under percona database and create a record for slave with host, username,password under dsn column in dsns table and finally need to mention where the dsn table is and specify master credentials. something like as follows.
    pt-table-checksum --recursion-method=dsn=D=percona,t=dsns --host=127.0.0.1
    

    If problem still persists i would suggest to show master and slave my.cnf
  • jjengel11jjengel11 Entrant Current User Role Patron
    Sorry for the delay in the response. The issue as I recall was because I did install the Percona Cluster software but am not using the database in a cluster but rather just in a master/slave scenario. With Percona Server the commands work. For whatever reason we could not cluster our databases
  • naaptolreportnaaptolreport Entrant Current User Role Beginner
    Hi

    I was using maatkit earlier from long time
    Now i want to migrate to percona toolkit

    What is alternative of following command full syntax

    ./mk-table-checksum h=192.168.58.30,P=3306,u=root,p=<password> h=192.168.58.7,P=3306,u=root,p=<password> -d csp --crc --count --float-precision=6 | ./mk-checksum-filter
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.