MySQL Simple ReplicAtion Monitor
#KUDOS
This is derived work based on "PHP MySQL Master/Slave Replication Monitor" https://code.google.com/p/php-mysql-master-slave-replication-monitor by 2010 Alan Blount (alan[at]zeroasterisk[dot]com). Thank you for your great work.
- Refactored some vars.
- Added config file.
- Added multiple topologies.
- Improved web interface.
- Updated testing and healing.
- Removed destructive operations.
- Updated codebase.
- Monitor MySQL replication status using web interface.
- Monitor MySQL replication using cron > Send email if issues are detected.
- Monitor and heal MySQL replication using cron > Send email if issues are detected > Report progress of healing.
- Passive (Slave status) and active (add record to replicated DB and record time of propagation to Slave from Master).
- Get index.php, cron.php, replication-monitor.class.php and config.php to your internal server. Note: Web interface is not protected - anyone can stop/break replication using SRaM.
- Download https://github.com/PHPMailer/PHPMailer and extract to Libs directory.
- Configure email settings, topologies and other settings in config.php.
- Make sure DB credentials have create db/table, update and delete.
- Add "util_replication" (or defined in config.php) to a list of replicated data bases.
- Add cron task to access cron.php at predefined intervals.
- Complain, patch and share your improvements 8)