Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am not a DBA, but I am interested in knowing how replication monitoring is done on MySQL severs.

In order to know if a slave is in sync with its master, one would typically check Seconds_Behind_Master, Slave_SQL_Running, Slave_IO_Running.

There are tools available like mk-table-checksum to verify replication integrity.

My question is, how else would a DBA like to monitor replication?

share|improve this question

Once I have asked the similar question there was ultimate Answer.Please have a look at it.

Then You will be clear with the


The Seconds_Behind_Master is not a good Parameter for monitoring the replication.

Try to use mk-heartbeat monitoring script i use that and is really reliable.

For Documentation of mk-heartbeat click here.

UPDATE Shows <code>Replication topology</code> in MONyog Try MONyog Web based application which has separate Replication tab and pretty easy to use, with lots of features

This will let you know Status of all slaves and Master on Replication tab for example: Replication topology, Master detail, Slave detail in a tabular format. Also Using Monitors page you can get alert if seconds_behind_master lags behind certain threshold value.

You can also use the MySQL Community Replication Monitor

The community driven MySQL replication monitoring tools is a collection of scripts in SQL and other languages, to achieve the same result that others can get with expensive applications.

share|improve this answer
Thanks! I agree with you! But other than mk-heartbeat, do you have any other suggestion? – omggs Feb 23 '12 at 6:28
@omggs : Do you need tools for that..? – Abdul Manaf Feb 23 '12 at 6:37
I dont need tools for that, I Just need to know if there is any other metric that I should check to monitor replication and its integrity. – omggs Feb 23 '12 at 6:47

I also recommend (as mentioned in first reply) to monitor data consistency across all servers binded to your master, becouse for variety of reasons sometimes replicas are not 100% copies.

Some nice PHP script, that checks data integrity can be found here:

It is an open source tool, very similar to "mk-table-checksum" but with one huge difference: it can check consistency on all binary log configuration modes: “statement”, “row” and “mixed”.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.