Questions tagged [pt-table-checksum]

The tag has no usage guidance.

4 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
1answer
372 views

Percona pt-table-checksum output is in infinite loop “Waiting for the --replicate table to replicate”

We have following Multi master replication scenario. We are using Mariadb 10.1.34 and percona 3.0.11 Master: Name: db-master1 (192.168.14.5) Slave: Name: db-slave2 (192.168.15.5) Replica ...
0
votes
2answers
812 views

how to make sure pt-sync-table data is the latest?

the first step is to checksum difference and record into percona.checksum table pt-table-checksum h=xx,P=xx,u=xx,p=xx method=dsn=h=xx,D=xx,t=xx --databases=kobe the second step is to print the ...
0
votes
1answer
50 views

pt-table-checksum toolkit for few databases from file

I've got a question. I'm doing a simple script right now and it isn't working like I want. #!/bin/bash cat /etc/backup.conf | egrep -v "(^#.*|^$|^--.*)" > /tmp/databases while read ...
-1
votes
1answer
305 views

pt-table-checksum show wrong DIFF

I'm try to use pt-table-checksum tool. I have Master/Slave tables, and I add some rows to the slave to check it. pt-table-checksum --ignore-databases mysql S=/tmp/5.6.22_3306_Master/data/mysql.sock --...