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
Your cron line:
0 * * * * /home/you/mysqlcheck
Or if it's in /etc/crontab
0 * * * * root /home/you/mysqlcheck
And the script:
#!/bin/sh
# on error send e-mail to
#
adminmail="[EMAIL PROTECTED]"
# or /usr/bin/safe_mysqld, etc.
#
restartCommand="/etc/rc.d/init.d/mysqld start"
if [ ! "`ps au