Hi,
Charles Jones wrote :
I just got bit hard by a MySQL replication error, so I'm about to write a Hobbit client-side ext script that will check the local servers slave status (CHECK SLAVE STATUS \G), parse the output, and alert appropriately (red if Slave Running = No, or if Seconds Behind Master
300, yellow if Seconds Behind Master <300 but > 60...otherwise green).
I have one, and I believe there's one included in the perl script package (already on the shire).
However, here's mine. It runs on the server side, so you need to give access to a specific user.
There's an obvious improvement to do: the slave status shows on the master line (column mysqlrep). It should show on the slave's line too, and the master replication status should stay green if a slave is blue (that is, a small dependency check).
Regards,
-- Charles Goyard - charles.goyard at orange-ftgroup.com - (+33) 1 45 38 01 31 Orange Business Services - online multimedia // ingénierie