本篇内容主要讲解“Mysql自动处理同步报错代码分享”,感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷,实用性强。下面就让小编来带大家学习“Mysql自动处理同步报错代码分享”吧!

exportLANG=zh_CN./root/.bash_profilev_dir=/usr/local/Mysql/bin/v_user=rootv_passwd=123456v_log=/home/logsv_times=10if[-d"${v_log}"];thenecho"${v_log}hasexistedbefore."elsemkdir${v_log}fiecho"">${v_log}/slave_status.logecho"">${v_log}/slave_status_error.logcount=1whiletruedoSeconds_behind_master=$(${v_dir}Mysql-u${v_user}-p${v_passwd}-e"showslavestatus\G;"|awk-F':''/Seconds_behind_master/{print$2}')if[${Seconds_behind_master}!="NULL"];thenecho"slaveisok!"${v_dir}Mysql-u${v_user}-p${v_passwd}-e"showslavestatus\G;">>${v_log}/slave_status.logbreakelseecho"">>${v_log}/slave_status_error.logdate>>${v_log}/slave_status_error.logecho"">>${v_log}/slave_status_error.log${v_dir}Mysql-u${v_user}-p${v_passwd}-e"showslavestatus\G;">>${v_log}/slave_status_error.log${v_dir}Mysql-u${v_user}-p${v_passwd}-e"showslavestatus\G;"|egrep'Delete_rows'>/dev/null2>&1if[$?=0];then${v_dir}Mysql-u${v_user}-p${v_passwd}-e"stopslave;SETGLOBALsql_slave_skip_counter=1;startslave;"else${v_dir}Mysql-u${v_user}-p${v_passwd}-e"showslavestatus\G;"|grep'Last_SQL_Error'breakfiletcount++if[$count-gt${v_times}];thenbreakelse${v_dir}Mysql-u${v_user}-p${v_passwd}-e"showslavestatus\G;">>${v_log}/slave_status_error.logsleep2continuefifidone

到此,相信大家对“Mysql自动处理同步报错代码分享”有了更深的了解,不妨来实际操作一番吧!这里是亿速云网站,更多相关内容可以进入相关频道进行查询,关注我们,继续学习!