Mike(mickalo)Blezien wrote: >Hello, > >Sorry for the OT,.. but I was hoping someone may suggest a script that can >monitor multiple mysql servers. We have two running and I would like to setup a >cron to check the servers once an hour or so to make sure it running and if not, >it would be capable of restart the server automatically in the event someone is >not available to restart it. I'm no shell script write... strictly Perl :) Not >sure this could be done with Perl. > >any suggestions would be appreciated. :) > Moodss (and the moomps daemon) can do that and more. You could set a threshold on an empty status for example for each server, get an email when the server becomes unreachable and execute a user defined script at that time (maybe using ssh to restart each server).
Later, if you like, you can monitor any MySQL state (processes, queries, traffic, ...). Moodss is at http://jfontain.free.fr/ Jean-Luc --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
