|
企业真实shell面试题,一起来挑战把!
声明:如有雷同,纯属抄袭
1、开发一个守护进程脚本,每30秒执行一次,检查mysql主从同步
[root@xiaoya scripts]# cat check_mysql_slave_status.sh
#!/bin/bash
# date 2016-1-5
# author tom
# mail 402753795@qq.com
# function check_mysql_slave_status
# version 4.1.2
####do it behind start mysql####
#grep "slave-skip-errors = " /data/3307/my.cnf |awk -F "[ ]" '{print $3}'|sed -i "s#.*#1158\,1159\,1007\,1008\,1062#g"
####define $IP $DATE####
IP=$(ifconfig eth0|awk '{if(NR==2)print $0}'|awk -F "[ :]+" '{print $4}')
DATE=$(date "+%F %H:%M:%S")
####check mysql_slave_status####
mysql_slave_status=$(mysql -uroot -p123456 -S /data/3307/mysql.sock -e "show slave status\G"|sed -n '12,13p'|awk -F ":" '{print $2}'|uniq -c)
if [ "$mysql_slave_status" == " 2 Yes" ]
then
echo "mysql slave is runing ok"
else
echo "#####################$DATE $IP##########################" >>~/oldboy.txt
echo "warn:mysql slave is not runing " >>~/oldboy.txt && mail -s "check_mysql_slave_status"402753795@qq.com |
|
|