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

pt-table-checksum can't complete from slave to slave

liranliran EntrantInactive User Role Beginner
We try to migration from the MySQL 5.5 to the MySQL 5.6. Since the Master is under a really heavy duty, we could only validate the date between one MySQL 5.5 slave and one MySQL 5.6 slave.

But when I try the pt-table-checksum, it is show the waiting for several hours.

Waiting to check replicas for differences: 0% 00:00 remain

Waiting to check replicas for differences: 0% 00:00 remain

Waiting to check replicas for differences: 0% 00:00 remain

Waiting to check replicas for differences: 0% 00:00 remain

Waiting to check replicas for differences: 0% 00:00 remain

Waiting to check replicas for differences: 0% 00:00 remain

Waiting to check replicas for differences: 0% 00:00 remain

Waiting to check replicas for differences: 0% 00:00 remain

Waiting to check replicas for differences: 0% 00:00 remain

Waiting to check replicas for differences: 0% 00:00 remain

Waiting to check replicas for differences: 0% 00:00 remain

Waiting to check replicas for differences: 0% 00:00 remain

Waiting to check replicas for differences: 0% 00:00 remain

Waiting to check replicas for differences: 0% 00:00 remain

Waiting to check replicas for differences: 0% 00:00 remain


My Command is:

pt-table-checksum --socket=/apollo/env/AWSManagementDatastore/var/mysql/state/mysql.sock -u "root" -p "password" -h "localhost" -P 8895 --recursion-method=dsn=D=test,t=dsns --nocheck-replication-filters --no-check-binlog-format --databases=management --replicate=management.liranchecksums

And I set the dsn table like below:
*************************** 1. row ***************************

id: 1

parent_id: NULL

dsn: h=mdb-gamma.cluster-cmur5xirflse.us-east-1.rds.amazonaws.com,P=8895,u=root,p=password
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.