#!/bin/bash
    
pgrep -x mysqld &> /dev/null
    
if [ $? -ne 0 ]
    
then
    
echo "At time: `date` :MySQL is stop .">> /var/log/mysql_messages
    
service mysql start
    
#echo "At time: `date` :MySQL server is stop."
    
else
    
echo "MySQL server is running ."
    
fi
   

将上述脚本保存到mysql.sh中，上传到服务器，运行该脚本可以发现输出数据库服务正在运行

    

     
# sh mysql.sh
     
MySQL server is running 
    

Sublime Text2 默认语言格式（windows/unix）设置，快捷键 - 鸿网互联[68IDC.CN]脚本如果还执行不了的可能性是文件没有执行权限

每隔一定时间自动运行脚本

linux上定期执行脚本用的是cron进程

Centos7-mqtt消息中间件mosquitto的安装和配置

借助mosquitto服务可以将消息推送到管理员客户端。

   

    
#!/bin/bash
    
pgrep -x mysqld &> /dev/null
    
 
    
if [ $? -ne 0 ]
    
 
    
then
    
 
    
mosquitto_pub -t mysql_status -m "Failed"
    
 
    
service mysql start
    
#echo "At time: `date` :MySQL server is stop."
    
 
    
else
    
 
    
mosquitto_pub -t mysql_status -m "Running"
    
 
    
fi
   

服务器发布主题为“mysql_status”的消息，再使用客户端来接收该消息。

   

    
import paho.mqtt.client as mqtt
    
# The callback for when the client receives a CONNACK response from the server.
    
def on_connect(client, userdata, flags, rc):
    
 print("Connected with result code "+str(rc))
    
 # Subscribing in on_connect() means that if we lose the connection and
    
 # reconnect then subscriptions will be renewed.
    
 client.subscribe("mysql_status")
    
 #订阅，第一个参数是订阅的主题
    
# The callback for when a PUBLISH message is received from the server.
    
def on_message(client, userdata, msg):
    
 print(msg.topic+" "+str(msg.payload))
    
client = mqtt.Client()
    
client.on_connect = on_connect
    
client.on_message = on_message
    
client.connect("主机名或ip", 1883, 60)
    
#第一个参数为主机名，及Mosquitto所在服务器，第二个参数是端口
    
# Blocking call that processes network traffic, dispatches callbacks and
    
# handles reconnecting.
    
# Other loop*() functions are available that give a threaded interface and a
    
# manual interface.
    
client.loop_forever()
   

参考： shell脚本：监控MySQL服务是否正常_数据库技术_Linux公社-Linux系统门户网站
Linux下定时任务的查看及取消 - Brin的日志 - 网易博客






来自为知笔记(Wiz)