mysql主从同步监控自动提取主库的file号及pos
来源:互联网 发布:小学网络课程 编辑:程序博客网 时间:2024/06/03 16:33
mysql主从同步监控自动提取主库的file号及pos
当发现同步出现无法同步的时候”会自动提取主库的file号,以及pos,进行同步主库,脚本内容如下:
#!/bin/sh
#set -x
#file is slave_repl.sh
#Author by Kevin
#date is 2011-11-13
mstool="/usr/local/mysql-3307/bin/mysql -h 192.168.1.106 -uroot daa#@897dkdlie$& -P 3307"
sltool="/usr/local/mysql-3307/bin/mysql -h 192.168.1.107 -uroot daa#@897dkdlie$& -P 3307"
declare -a slave_stat
slave_stat=($($sltool -e "show slave status\G"|grep Running |awk '{print $2}'))
if [ "${slave_stat[0]}" = "Yes" -a "${slave_stat[1]}" = "Yes" ]
then
echo "OK slave is running"
exit 0
else
echo "Critical slave is error"
echo
echo "*********************************************************"
echo "Now Starting replication with Master Mysql!"
file=`$mstool -e "show master status\G"|grep "File"|awk '{print $2}'`
pos=`$mstool -e "show master status\G"|grep "Pos"|awk '{print $2}'`
$sltool -e "slave stop;change master to master_host='192.168.1.106',master_port=3307,master_user='repl',master_password='w!zl7POg27',master_log_file='$file',master_log_pos=$pos;slave start;"
sleep 3
$sltool -e "show slave status\G;"|grep Running
echo
echo "Now Replication is Finished!"
echo
echo "**********************************************************"
exit 2
fi
运行后效果,如下图:
# ./slave_stop3307.sh
*******************************
Now stop Slave Replication!
Slave_IO_Running: No
Slave_SQL_Running: No
*******************************
# ./slave_repl3307.sh
Critical slave is error
*********************************************************
Now Starting replication with Master Mysql!
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Now Replication is Finished!
**********************************************************
当发现同步出现无法同步的时候”会自动提取主库的file号,以及pos,进行同步主库,脚本内容如下:
#!/bin/sh
#set -x
#file is slave_repl.sh
#Author by Kevin
#date is 2011-11-13
mstool="/usr/local/mysql-3307/bin/mysql -h 192.168.1.106 -uroot daa#@897dkdlie$& -P 3307"
sltool="/usr/local/mysql-3307/bin/mysql -h 192.168.1.107 -uroot daa#@897dkdlie$& -P 3307"
declare -a slave_stat
slave_stat=($($sltool -e "show slave status\G"|grep Running |awk '{print $2}'))
if [ "${slave_stat[0]}" = "Yes" -a "${slave_stat[1]}" = "Yes" ]
then
echo "OK slave is running"
exit 0
else
echo "Critical slave is error"
echo
echo "*********************************************************"
echo "Now Starting replication with Master Mysql!"
file=`$mstool -e "show master status\G"|grep "File"|awk '{print $2}'`
pos=`$mstool -e "show master status\G"|grep "Pos"|awk '{print $2}'`
$sltool -e "slave stop;change master to master_host='192.168.1.106',master_port=3307,master_user='repl',master_password='w!zl7POg27',master_log_file='$file',master_log_pos=$pos;slave start;"
sleep 3
$sltool -e "show slave status\G;"|grep Running
echo
echo "Now Replication is Finished!"
echo
echo "**********************************************************"
exit 2
fi
运行后效果,如下图:
# ./slave_stop3307.sh
*******************************
Now stop Slave Replication!
Slave_IO_Running: No
Slave_SQL_Running: No
*******************************
# ./slave_repl3307.sh
Critical slave is error
*********************************************************
Now Starting replication with Master Mysql!
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Now Replication is Finished!
**********************************************************
阅读全文
0 0
- mysql主从同步监控自动提取主库的file号及pos
- 自动监控主从MySQL同步的SHELL脚本
- shell脚本监控mysql主从同步状态并自动修复
- 监控MySQL主从同步延时
- 监控MYSQL主从同步配置中监控从库运行状态的脚本
- nagios 实现Mysql 主从同步状态的监控
- MySQL 5.7.18的安装及主从复制(主从同步)
- Mysql Replication实现mysql主从库自动同步安装指南
- Mysql Replication实现mysql主从库自动同步安装指南
- nagios监控内网mysql主从同步
- nagios 监控 mysql 主从同步状态
- nagios 监控 mysql 主从同步状态
- zabbix3.0.4监控mysql主从同步
- mysql主从同步一致性,延迟性监控
- mysql的主从同步
- mysql主从监控的脚本
- MySQL 主从同步延迟的原因及解决办法
- MySQL 主从同步延迟的原因及解决办法
- 系统环境变量及其Python安装路径
- 关于 static const修饰的变量
- gcc编译器 命令常用选项及工作流程 截图
- java.lang.Error: Unresolved compilation problems:解决方案
- Windows服务的添加与删除
- mysql主从同步监控自动提取主库的file号及pos
- 网络安全法丨信息泄露如何严重,网络安全法实施意义何在?
- 持续更新一些jquery相关内容
- Mac之常用的快捷键
- 将data对象转换为数组
- iOS可复用控件之悬浮按钮
- 快速掌握阿里云 E-MapReduce
- 条件注释判断浏览器<!--[if !IE]><!--[if IE]><!--[if lt IE 6]><!--[if gte IE 6]>
- 信息论, 熵