keepalived mysql脚本_Mysql检查脚本控制keepalived（2）

#!/bin/bash

mysql -uphpmyadmin -proot -e "select version();" >/dev/null 2>&1

#mysql -uphpmyadmin -proot -e "show status;"#

if [ $? -ne 0 ] ;then

#echo $(date)". mysql error!" >>/etc/keepalived/action.log

sudo service keepalived stop

if [ $? -ne 0 ] ;then

echo $(date +'%Y-%m-%d %H:%M:%S')". mysql error.but ACTION keepalived-stop failed." >>/etc/keepalived/action.log

else

echo $(date +'%Y-%m-%d %H:%M:%S')". mysql error.ACTION keepalived-stop success." >>/etc/keepalived/action.log

fi

else

keepalivedcheck=`ps -C keepalived --no-header | wc -l`

if [ $keepalivedcheck -eq 0 ] ;then

sudo  service keepalived start

if [ $? -ne 0 ] ;then

echo $(date +'%Y-%m-%d %H:%M:%S')". mysql normal,keepalived already stopped.but ACTION keepalived-start failed" >>/etc/keepalived/action.log

else

echo $(date +'%Y-%m-%d %H:%M:%S')". mysql normal,keepalived already stopped.ACTION keepalived-start success" >>/etc/keepalived/action.log

fi

###test code

#else

#echo $(date)". keepalived is running!" >>/etc/keepalived/action.log

##test code

fi

#echo $(date)". mysql running!" >>/etc/keepalived/action.log

fi