mysql_ping.sh
#!/bin/bash
# host为你需要检测的MySQL主机的IP地址,user为MySQL账户名,passwd 为密码
# 这些信息需要根据实际情况修改后方可使用
host=192.168.10.244
user=root
passwd=root
mysqladmin -h '$host' -u '$user' -p'$passwd' ping &>/dev/null
if [ $? -eq 0 ];then
echo "MySQL is UP"
else
echo "MySQL is down"
fi
验证:
[root@logstash ~]# sh mysql_ping.sh
MySQL is down
[root@logstash ~]#