Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
add comment

1 Answer 1

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

Then You will be clear with the

Seconds_Behind_Master

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
add comment

Your Answer

 
discard

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.