MySQL数据库可用性监控脚本
方法一:通过测试账号ping命令返回的信息判断数据库可以通过网络连接
[root@host-39-108-217-12 scripts]# cat mysql-available-status.sh
#!/bin/bash
MYSQL_PING=`/usr/bin/mysqladmin -uroot -p123456 -P3306 ping`
MYSQL_OK="mysqld is alive"
if [[ "$MYSQL_PING" != "$MYSQL_OK" ]];then
echo "MySQL is not ok !"
sleep 5
systemctl restart mariadb
else
echo "MySQL is ok !"
fi