The percona-tools tag has no wiki summary.
1
vote
1answer
82 views
Does Pt-table-checksum point out rows that are different from that of the Master
Trying to verify replication integrity of my replica. And I found that pt-table-checksum is one of the best ways of doing it.
I have a simple Master->Slave set up. Have created a sample table with 10 ...
1
vote
1answer
44 views
pt-table-sync error: Called not_in_left in state 0
I have setup a Mysql replication between 2 servers, using Percona Xtrabackup:
Master is a MySQL 5.0.91 Community Edition (CentOS 4.8)
Slave is a MySQL 5.1.68 Community Edition (CentOS 6.4)
When ...
1
vote
0answers
49 views
pt-table-checksum generates no output
I've been using pt-table-checksum on our staging server successfully, but when I run
./pt-table-checksum h=localhost,u=user --ask-pass --lock-wait-time=50 --databases prod
It just sits there. No ...
0
votes
0answers
44 views
Multiple restores using incrementals and xtrabackup
I'm using Percona's innobackupex/xtrabackup tools to maintain backups of some innodb only mysql instances.
I've run into a situation where it seems after I do an initial restore the act of applying ...
1
vote
2answers
382 views
Which hot backup tools for MySQL InnoDB database : Percona XtraBackup, Zmanda Recovery Manager Enterprise or Community or…?
I manage a PHP/MySQL website :
max 500 simultaneous users / average of 4000 per hour in update/read
1 MySQL Community Server (5.1) - (Xeon / 16 Go RAM)
InnoDB Storage engine on 100 tables for 1.4 Go ...
1
vote
1answer
130 views
pt-table-checksum from remote server
I am using pt-table-checksum for the first time and have some questions that I can't seem to resolve by reading the documentation on Percona's website.
Per the documentation, pt-table-checksum ...
1
vote
1answer
49 views
Why does pt-table-checksum gives exit status 0 if slave is unreachable?
I'm using pt-table-checksum version 2.1.4 for checking my master-slave set up. In the case when I forget to set up the right privileges on the slave, it writes an error to stderr like this:
# ...
2
votes
1answer
90 views
Maatkit shows the MySQL replication error in one table, but won't fix it
We use MySQL 5.1 with a primary/secondary replication setup. I use mk-table-checksum from Maatkit to generate checksums on the master and perform consistency checks on the replica.
mk-table-checksum ...
1
vote
1answer
117 views
Do I have to filter the percona.checksums table in replication for use with pt-table-checksum?
I've set up MySQL replication, one master and one slave. Now I just starting to check the data for integrity on both sides by using Percona's pt-table-checksum. Wonderful tool to detect any changes or ...
1
vote
0answers
139 views
Finding differences between a master and slave when pt-table-sync fails
I have a table that's showing some differences on a master and slave according to pt-table-checksum (PTC). I've found some verifying differences beyond that.
Certain tables in the mix have composite ...
3
votes
3answers
191 views
Is it possible to pass parameters to pt-table-checksum using an options file?
We're using Percona's pt-table-checksum for MySQL replication integrity check.
Is it possible to pass some or all of the options using some sort of configuration file?
For instance, can we write the ...
3
votes
2answers
1k views
pt-table-checksum help required
I am trying to figure out pt-table-checksum, as I am using it for the first time.
It look likes the documentation is complex and not easy to understand stuff.
I have a complex replication topology ...
3
votes
1answer
423 views
MySQL Handler_read_rnd_next == tablescans without indexes?
I am in the process of tuning our Percona 5.5 server, and have been using percona's tools to plot our database's performance.
In the MySQL Handlers Plot, i have been noticing alot of ...
3
votes
1answer
3k views
Fixing tables out of sync as reported by pt-table-checksum, pt-table-sync is not working
I have several tables being reported by pt-table-checksum with CRC_DIFF between my master and slave servers using the following commands:
$ pt-table-checksum h=master,u=user,p=password ...
3
votes
2answers
1k views
pt-table-checksum with slaves using non-standard ports
Trying to run pt-table-checksum to detect slave drift in MySQL replication. My slaves are not using the standard TCP listening port however, and so when I run the tool I get an error:
Cannot connect ...
