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 have just installed and setup replication for 3 MySQL 5.5.20 server( 1 Master/ 2 slaves). I intend to add more slaves to the equation.

Which is the best software tool to monitor the replication status ( like SHOW SLAVE STATUS \G;)

Also i want to know, how much is the replication lagging in time and error reports if there is any error in replication.

Thanks in advance

share|improve this question
    
You can refer this link as well : stackoverflow.com/questions/8518811/… –  Vanderberge_MySQLDBA Mar 11 '13 at 11:42

2 Answers 2

up vote 2 down vote accepted

Checkout Percona toolkit. Look at pt-heartbeat, and some of their other tools as well.

share|improve this answer

MONyog has Replication tab which shows all slave and master status at a glance along with their topology. It also sends email notification incase replication problem occurs.

enter image description here

share|improve this answer

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.