Shell monitors whether the mysql master and slave is normal.

This article shows you whether the shell monitoring mysql master and follower is normal, the content is concise and easy to understand, it can definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

Set scheduled tasks on master:

#! / bin/shif [- f / root/mysql_slave_status.txt] then rm-f / root/mysql_slave_status.txt mysql-uroot-pxxxxxx-e "show slave status\ G" | egrep "_ Running: | Behind_Master" | awk'{print $2}'> / root/mysql_slave_status.txt array= ($(cat / root/mysql_slave_status.txt | xargs)) if ["${array [0]}" = "Yes"-a " ${array [1]} "=" Yes "- a" ${array [2]} "=" 0 "] then echo" mysql slave is ok "``else char=" mysql slave is not ok "sleep 3 echo" $char "| mail-s" xxxxx mysql_slave is error "111111111@qq.com fifi above is shell monitoring whether the mysql master and slave is normal. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.