实战:mysql 5.6复制延迟监控
来源:互联网 发布:淘宝c店还可以赚到钱吗 编辑:程序博客网 时间:2024/05/16 03:12
#repdelay.sh#!/bin/sh#ocpyang@126.com#查看复制延迟具体多少event#set mysql evnMYSQL_USER_MASTER=root MYSQL_PASS_MASTER='password' MYSQL_HOST_MASTER=192.168.2.188MYSQL_USER_SLAVE=root MYSQL_PASS_SLAVE='password' MYSQL_HOST_SLAVE=192.168.2.14tmpfile_01="tmp01.`date +%Y%m%d%H%M%S`.txt"tmpfile_02="tmp02.`date +%Y%m%d%H%M%S`.txt"mysql -h${MYSQL_HOST_MASTER} -u${MYSQL_USER_MASTER} -p${MYSQL_PASS_MASTER} -e"SHOW BINARY LOGS;" >${tmpfile_01}mysql -h${MYSQL_HOST_SLAVE} -u${MYSQL_USER_SLAVE} -p${MYSQL_PASS_SLAVE} -e"SHOW SLAVE STATUS\G;" >${tmpfile_02}#tail -1 ${tmpfile_01} | grep -v "Log_name"#cat ${tmpfile_02} | grep -E 'Master_Log_File|Read_Master_Log_Pos|Exec_Master_Log_Pos' | grep -v "Relay_Master_Log_File" |sed 's/^[ ]*//g'a=`tail -1 ${tmpfile_01} | grep -v "Log_name" |awk '{print $1}'|awk -F "." '{print $2}'`b=`sed -n "/\<Master_Log_File\>/p" ${tmpfile_02} |sed 's/^[ ]*//g' |awk -F ":" '{print $2}'|awk -F "." '{print $2}'`bhtime=`sed -n "/\<Seconds_Behind_Master\>/p" ${tmpfile_02} |sed 's/^[ ]*//g' |awk -F ":" '{print $2}'`if [ "$b" = "$a" ];thenc=`tail -1 ${tmpfile_01} | grep -v "Log_name" |awk '{print $2}'`d=`sed -n "/\<Read_Master_Log_Pos\>/p" ${tmpfile_02} |sed 's/^[ ]*//g' |awk -F ":" '{print $2}'` e=`expr $c - $d`if [ "${e}" -eq 0 -a "${bhtime}" -eq 0 ]; thenecho "*****************************************************************************"echo -e "\e[1;31m &&&&&&&Synchronization has been completed!&&&&&&& \e[0m"echo "*****************************************************************************"elif [ "${e}" -eq 0 -o "${bhtime}" -eq 0 ];thenecho "*****************************************************************************"echo -e "\e[1;31m Has been synchronized to the same log file! Wait a moment \e[0m"echo -e "\e[1;31m Not synchronized binlog events is:${e},behind master tims is ${bhtime} \e[0m"echo "*****************************************************************************"fielif [ ${b} -lt ${a} ];thenf=`sed -n "/\<Read_Master_Log_Pos\>/p" ${tmpfile_02} |sed 's/^[ ]*//g' |awk -F ":" '{print $2}'`g=`awk '$1 >= "$b" {print $2}' ${tmpfile_01} |awk 'BEGIN{total=0}{total+=$1}END{print total}'`re=`expr $g - $f` echo -e "\e[1;31m There are multiple log files are not synchronized,the events is:${re} \e[0m"firm -rf ${tmpfile_01}rm -rf ${tmpfile_02}
0 0
- 实战:mysql 5.6复制延迟监控
- mysql复制延迟监控脚本
- MySQL复制中slave延迟监控
- MySQL复制中 slave延迟监控
- [MySQL FAQ]系列 — MySQL复制中slave延迟监控
- 【SHELL】监控Nginx运行,Mysql主从运行,主从复制延迟
- pt-heartbeat监控mysql主从复制延迟整理
- MySQL 复制延迟
- Mysql复制延迟解决方案
- 使用pt-heartbeat监控主从复制延迟
- 利用pt-heartbeat监控复制延迟
- 如何Mysql 复制中的延迟?
- mysql主从复制延迟问题
- mysql主从复制延迟问题
- mysql监控工具实战
- mysql主从复制实战
- MySQL主从复制实战
- MySQL主从复制实战
- 简单的计时器
- 基于optics算法的文本分类程序
- leetcode:Palindrome Partitioning
- db2的rollup和cube函数
- 【译】Android API Guide 之 属性动画
- 实战:mysql 5.6复制延迟监控
- 黑马程序员_Java基础_01环境安装、类编译常见错误、标识符、注释
- Mahalanobis distance in R
- Distinct Subsequences----匹配个串串
- UIWebView与JavaScript相互调用
- Android实现刮刮乐效果
- Oracle官方网站的 MySQL connector,ODBC driver,所有版本jdk下载地址
- android异步处理数据
- android toast 的context探讨(整理,前部分为摘抄)