mysql replication monitoring

MySQL master master replication monitor with php code

For monitoring replication we know a lot of tools and codes – but this one is different because I wrote it 😉 Well this is fairly simple php code for monitoring a master master replication setup. It requires a single shared login id available on both MySQL servers. It will display in tabular format following details: File: Present binary log Position: Binary log position Io run: Slave IO Thread Running status Sql run: SQL Thread Running status ErrorNum: Error number ErrorMeg: Error message You can easily stop / start each server’s slave (STOP SLAVE / START SLAVE) with a single...