mysql主从编写shell脚本实现邮件报警
1.shell脚本实现主从检测 并邮件报警
编写shell脚本实现邮件报警
1.安装maile
yum -y install mailx
2.配置邮件文件
[root@192 ~]# vim /etc/mail.rc
######################### set from=1423593121@qq.com set smtp=smtp.qq.com set smtp-auth-user=1423593121@qq.com set smtp-auth-password=qplispkqgeqvjied set smtp-auth=login ########################
3.编写代码
#!/bin/bash num=$(mysql -e "show slave status \G"|grep Yes|awk -F ":" '{print $2}'|wc -l) if [ $num -eq 2 ] then echo "mysql主从复制没有毛病" else echo "mysql主从出现故障,请及时就修改" echo "please check mysql"|mail -s "check mail" 1423593121@qq.com fi
4.执行脚本测试
[root@192 ~]# ./mysql.sh mysql主从出现故障,请及时就修改
收到邮件这位成功!!!!