Percona Tools : Software Designed for Advanced MySQL/PerconaServer Tasks, Maintenance, and Monitoring
1
vote
1answer
50 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 ...
0
votes
0answers
47 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
432 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
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 ...
2
votes
1answer
95 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
50 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:
# ...
1
vote
1answer
135 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
2answers
91 views
Does pt-table-checksum point out rows that are different between Master and Slave?
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
0answers
144 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
197 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
429 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 ...
1
vote
1answer
133 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 ...
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 ...
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 ...
