The tag has no wiki summary.

learn more… | top users | synonyms

3
votes
2answers
1k views

mk-table-sync in a master-slave scenario: Changes not replicated to the slave

I have being employing mk-table-sync to synchronise tables from a master to slave on mysql 5.1. Unfortunately, while differences are correctly detected, modifications done on the master ...
0
votes
3answers
148 views

MySQL RESET [integer]

In an audit of queries running on our databases using tcpdump and Maatkit tools, the number one query is RESET [int] Running this statement from the MySQL command line results in an error as RESET ...
1
vote
1answer
173 views

mysql & maatkit: What kind of blocking will mk-table-checksum do?

We have two MySQL servers set up with simple master-slave replication. We currently use all MyISAM tables, but may move to InnoDB in the future. Our largest tables are more then 2GB. I would like to ...
2
votes
2answers
1k views

MySQL binlog analyzing and reporting tool

One of the databases I maintain has recently increased its write load by 2x. In order to find out what insert/update statements are causing that load increase, I'm looking for a tool to report and ...
1
vote
2answers
499 views

A few tables are still out of sync after running mk-table-sync

I have 1 master and 2 slaves. I am using MySQL 5.1.42 on all servers. I am attempting to use mk-table-checksum to verify that their data is in sync, but I am getting unexpected results on one of ...
1
vote
5answers
5k views

MySQL slave out of sync with master

Our slave, which is just used for backups, is out of sync. It has crashed out on a key restraint. I would like to find a way to resync up the slave without taking the master offline, I know I can do ...
2
votes
3answers
2k views

Help me understand mk-heartbeat

Seconds_Behind_Master from SHOW SLAVE STATUS is considered an unreliable measure of Slave lag. mk-heartbeat is often offered as a reliable alternative. Now mk-heartbeat does not even need the Slave ...
1
vote
2answers
756 views

How to install a local .deb file

I'm trying to install the last version of maatkit in debian Lenny. I couldn't find a repository with the last version, so I got the .deb file. The problem is How to I install this file? man aptitude ...
0
votes
2answers
1k views

how to sync mysql tables using maatkit tools

I know my slave is at least a little out of sync from the master... and reading I found that many places say that mk-table-checksum + mk-table-sync from maatkit are the tool I should use to fix this. ...