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

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.

You can refer this link as well :… – user21109 Mar 11 '13 at 11:42
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

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