Well basically I'm looking for a good way to monitor MySQL from the server itself and then proactively act on any issues. SIM can check if the service is up and if mysql.sock is there but this doesn't mean mysql is running well. Really I'm looking if anyone knows something that checks if MySQL will allow connections and can execute a query. Right now when MySQL stops working in that sense we're not even aware of it until we see a support ticket but I'd really love to automate the process and have mysql restarted when this sort of thing happens.
So any suggestions would be great I don't like reinventing the wheel on this sort of stuff but if I have to I guess I'll probably make something myself.
