Questions tagged [pt-table-checksum]
13 questions
5
votes
2 answers
pt-table-checksum and row-based replication
The set up I work with is MySQL 5.5 in a master-slave replication configuration, but we have to use "MIXED" replication (statement and row-based) because we use an application that requires it, and it happens to be on our same server.
We had…
dmgig
- 291
- 1
- 4
- 10
4
votes
1 answer
pt-table-checksum says there is a difference but pt-table-sync with --print says nothing
I am using pt-table-checksum to ensure master-slave is synchronized.
When I run pt-table-checksum, I see some differences on employee_profile.trigger_log but when I use pt-table-sync with --print, I see nothing.
I resolved some differences on some…
Luke Nguyen
- 749
- 2
- 9
- 22
3
votes
1 answer
Accuracy of mysqldbcompare vs other tools like pt-table-checksum
I was curious to hear what everyone's experiences are with using mysqldbcompare vs pt-table-checksum( from Percona Toolkit ) to find the differences between two MySQL databases.
I have heard that pt-table-checksum is pretty dead-on accurate in…
user1805458
- 281
- 1
- 2
- 10
3
votes
2 answers
Skipping chunk X of Y.Z because MySQL chose no index instead of the word_sid_typeindex
My environment:
# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.8 (Santiago)
# uname -a
Linux A.B.C 2.6.32-642.4.2.el6.x86_64 #1 SMP Mon Aug 15 02:06:41 EDT 2016 x86_64 x86_64 x86_64 GNU/Linux
# rpm -q mysql-server…
alexus
- 625
- 5
- 14
- 28
2
votes
1 answer
pt-table-checksum to compare two tables?
I'm trying to find a way of comparing two tables in two databases (master and slave), as I have applied some slightly different settings to one, and need to see what affect it has (if any) on the data etc.
Ordinarily I would use MySQL Utilities…
IGGt
- 2,266
- 6
- 35
- 49
1
vote
1 answer
pt-table-checksum - Verify MySQL replication integrity
export/import:
$ mysqldump -h6dhdbm01 -p clee2 users > 6dhdbm01-clee2.users.sql
Enter password:
$ echo $?
0
$ mysql clee2 < 6dhdbm01-clee2.users.sql
$ echo $?
0
$
pt-table-checksum:
$ pt-table-checksum --databases=clee2 --tables=users
Error…
alexus
- 625
- 5
- 14
- 28
1
vote
0 answers
Replication between master and slave is running, but still there is a one row difference in a few tables when checked with pt-table-checksum
This is the master status
mysql> show master status;
+------------------+-----------+--------------+------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set…
skiddaa
- 11
- 1
0
votes
1 answer
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 Connection name:
master1 (192.168.14.5)
SHOW SLAVE…
Muhammad Rashid
- 21
- 2
0
votes
1 answer
Validate data between two large tables
I have this scenario. Data files are transferred from multiple stores (transactions) to the head office as they happen. For each store the table in question is pretty big in size. At the head office, that same table contains the same info from all…
JohnG
- 1,093
- 2
- 12
- 27
0
votes
1 answer
Redundant argument in printf at /usr/bin/pt-table-checksum
While pt-table-checksum seems to work well for most tables, a few of the big ones get this:
Error checksumming table mydb.mytable: Redundant argument in printf
at /usr/bin/pt-table-checksum line 8106.
Versions:
pt-table-checksum 2.2.11
Servers…
Collector
- 145
- 5
0
votes
2 answers
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 repair SQL into a file
pt-table-sync --print…
LawrenceLi
- 321
- 1
- 3
- 16
0
votes
1 answer
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 line; do
pt-table-checksum [options] --databases…
-1
votes
1 answer
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 --user=SlaveUser --password=1234
produce this…
ElazarG
- 1