Monitor multiple mysql replication using php: Updated
Kedar
Monitoring a replication is an important aspect. As replication includes multiple nodes, it is essential to track activity and status across all mysql servers involved in replication. To monitor replication…
12 responses to “Monitor multiple mysql replication using php: Updated”
Hi Kedar,
Emails were not sent, through script. Please help.
Based upon your script, I have created a simple commandline utility that checks for properly running replication and re-synchronizes the slave to the master if there is an error.
You can find it on GitHub:
https://github.com/k1mgy/MySql-Replication-UtilitiesThanks Mark for visiting and sharing.
– Kedar.
I can’t make typical replication Master-Slave (I dont have acces to external dbase conf files). How can I make a replication from the local mysql (winamp server) to outside mysql server only via (PHP?) script solution?
🙂 not possible if you don’t have access to one of the server considering not every thing is preconfigured.
– Kedar.
Hey Kedar,
This is awesome. I was going to write my own until I found yours! Thanks this is so great!
The slave status is working fine using the replmon_conf.txt file but the detailed link isn’t working for me. I’m getting a can’t connect to server. Should I just put the login creds directly into the get_status function?
Thanks again!!!
Hi, same problem with the detailed link. Any solution?
@Michael,
Check updated mysql replication monitoring script at the end of the article. I hope this fixes our issue 🙂
Thanks Kedar. Works perfectly.
Galen,
Took too long but seems like I’ve modified the script! let me know if you LIKE it 🙂
Hey James,
Check the update! I hope it will work for you.
Great Script!
do you know how I could include everything again in the same page to connect to another pair of servers?