测试mysql主从_mysql主从检测脚本 分手后的思念是犯贱 2023-01-11 08:25 78阅读 0赞 \#!/bin/bash \# check mysql slave status USER="check" PSW="\*\*\*" RUNTIME=3600 ADDR="192.168.\*.\*" declare -a slave\_is for IP in $ADDR do slave\_is=($(/usr/local/mysql/bin/mysql -h$IP -u$\{USER\} -p$\{PSW\} -e "show slave status\\G"|grep Running|awk ‘\{print $2\}‘)) if \[ "$\{slave\_is\[0\]\}" = "Yes" -a "$\{slave\_is\[1\]\}" = "Yes" \] then echo -e "$\{IP\} - Slave Status: \\e\[1;32m \[ OK \] \\e\[0m" > /app/sqlstatus else echo "$\{IP\} - Slave Status: \\e\[1;31m \[ ERROR \] \\e\[0m" > /app/sqlstatus cat "/app/sqlstatus" |mutt -s "mysql slave" \[email protected\] fi sleep $RUNTIME done ![e87a2e5dfc9a05d45f02c360e0579243.png][] 间隔一小时检查一次，如果出错，发送邮件 原文：http://bbotte.blog.51cto.com/6205307/1410008 [e87a2e5dfc9a05d45f02c360e0579243.png]: /images/20221119/ffb2766c26b643a59991776f55e01acf.png
还没有评论，来说两句吧...