Write a shell script to Check if mysqld is alive. Here is command line version
Code:
mysqladmin -u root -h dbserver1.mycorp.com -p 'MyPASSWORD' ping
And a script:
Code:
#!/bin/bash
mysqladmin -u root -h dbserver1.mycorp.com -p 'MyPASSWORD' ping
if [ $? -ne 0 ]; then
echo "Send email, mysql not running"
else
echo "Do nothing everything is working"
fi
done