monitor replication

Monitor multiple mysql replication using php: Updated

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 we know commands like: Show slave status; Show master status; Refer: http://dev.mysql.com/doc/refman/5.0/en/sql-syntax-replication.html But when it comes to non-gui interface, it becomes little tedious. With some efforts, I managed to make a php script to monitor mysql servers. It can: Get per second status of slaves. Start / Stop slave from any of the mysql servers in replication. Display error number along with description in case of error in replication. Shows...