0

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.

2

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.