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