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

Pt-table-checksum deos not start verification

posnerposner EntrantCurrent User Role Beginner
Hi All,

I have Mysql replication setup between two server (Master Server A and Slave Server B) which i want to check the discrepancy between.
I have installed the percona toolkit on Server C and try to verify A and B.

Here are the server details:

Master Server
[email protected]:~$
Mysql: Server version: 5.5.28-29.1-log Percona Server (GPL), Release 29.1
OS : Description: Ubuntu 11.10 Codename: oneiric
Port : 3306

Slave Server :
[email protected]:~$
Mysql: Server version: 5.6.20-68.0 Percona Server (GPL), Release 68.0, Revision 656
OS : Description: Ubuntu 12.04.4 LTS Codename: precise
Port: 3306

Remote server with toolkit installed.
[email protected]:~$ pt-table-checksum --version
pt-table-checksum 2.2.10


Here is the result when i run the tool

[email protected]:~$ date ; pt-table-checksum -h 172.16.1.1 -P 3306 --user=root -pXXXX --replicate=temp.checksum --create-replicate-table --databases==voddw --no-check-replication-filters ;date
Fri Sep 26 12:09:15 EDT 2014
Fri Sep 26 12:09:16 EDT 2014
[email protected]:~$


so the table "checksum" is created and its empty. nothing is started.

Please can someone tell me what is the issue here.

Thanks


PS:
Master A has 6 instances running on port (3306/7/8/9/10/11)
Slave B has 2 instances running on port (3306/11)

replication is between Master A (3306) and Slave B (3306).

Comments

  • posnerposner Entrant Current User Role Beginner
    i looked at it again now and see the issue

    --databases==voddw
    changed it to
    --databases=voddw

    date ; pt-table-checksum -h 172.16.1.1 -P 3306 --user=root -pXXXX --replicate=temp.checksum --create-replicate-table --databases=voddw --no-check-replication-filters ;date

    Its working
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.