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

closed as off-topic by Paul White, Philᵀᴹ, RolandoMySQLDBA, Michael Green, dezso Jan 26 '15 at 13:00

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Paul White, Philᵀᴹ, RolandoMySQLDBA, Michael Green, dezso
If this question can be reworded to fit the rules in the help center, please edit the question.


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

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