問題描述:?
創(chuàng)新互聯(lián)公司是一家從事企業(yè)網(wǎng)站建設(shè)、網(wǎng)站設(shè)計(jì)制作、網(wǎng)站設(shè)計(jì)、行業(yè)門戶網(wǎng)站建設(shè)、網(wǎng)頁設(shè)計(jì)制作的專業(yè)網(wǎng)站制作公司,擁有經(jīng)驗(yàn)豐富的網(wǎng)站建設(shè)工程師和網(wǎng)頁設(shè)計(jì)人員,具備各種規(guī)模與類型網(wǎng)站建設(shè)的實(shí)力,在網(wǎng)站建設(shè)領(lǐng)域樹立了自己獨(dú)特的設(shè)計(jì)風(fēng)格。自公司成立以來曾獨(dú)立設(shè)計(jì)制作的站點(diǎn)上千。
在gtid模式下? ,mha發(fā)生故障切換 ,如果Linux主機(jī)還存活? ,不會(huì)去比對(duì)master的日志,獲取差異日志 ,有導(dǎo)致數(shù)據(jù)丟失的風(fēng)險(xiǎn) 。
問題修復(fù):
找到?MasterFailover.pm 文件? ?,將下文! 去掉
????if?(?!$_server_manager->is_gtid_auto_pos_enabled()?)?{ ??????$log->info(); ??????$log->info("*?Phase?3.2:?Saving?Dead?Master's?Binlog?Phase..\n"); ??????$log->info(); ??????save_master_binlog($dead_master); ????}
去掉后的代碼
????if?(?$_server_manager->is_gtid_auto_pos_enabled()?)?{ ??????$log->info(); ??????$log->info("*?Phase?3.2:?Saving?Dead?Master's?Binlog?Phase..\n"); ??????$log->info(); ??????save_master_binlog($dead_master); ????}
找到?apply_binlog_to_master 函數(shù)定義的位置
sub?apply_binlog_to_master($)?{ ??my?$target???=?shift; ??my?$err_file?=?"$g_workdir/MySQL_from_binlog.err"; ??my?$command?= "cat?$_diff_binary_log??|?mysql?--binary-mode?--user=$target->{mysql_escaped_user}?--password=$target->{mysql_escaped_password}?--host=$target->{ip}?--port=$target->{port}?-vvv?--unbuffered?>?$err_file?2>&1"; ??$log->info("Checking?if?super_read_only?is?defined?and?turned?on.."); ??my?($super_read_only_enabled,?$dbh)?= ??????????MHA::SlaveUtil::check_if_super_read_only($target->{hostname},?$target->{ip},?$target->{port},?$target->{user},?$target->{password}); ??if?($super_read_only_enabled)?{ ????MHA::SlaveUtil::disable_super_read_only($dbh); ??}?else?{ ????$log->info("?not?present?or?turned?off,?ignoring.\n"); ??}
修改后的代碼??cat $_diff_binary_log?
sub?apply_binlog_to_master($)?{ ??my?$target???=?shift; ??my?$err_file?=?"$g_workdir/mysql_from_binlog.err"; ??my?$command?= "mysqlbinlog?$_diff_binary_log?--skip-gtids=true?|?mysql?--binary-mode?--user=$target->{mysql_escaped_user}?--password=$target->{mysql_escaped_password}?--host=$target->{ip}?--port=$target->{port}?-vvv?--unbuffered?>?$err_file?2>&1"; ??$log->info("Checking?if?super_read_only?is?defined?and?turned?on.."); ??my?($super_read_only_enabled,?$dbh)?= ??????????MHA::SlaveUtil::check_if_super_read_only($target->{hostname},?$target->{ip},?$target->{port},?$target->{user},?$target->{password}); ??if?($super_read_only_enabled)?{ ????MHA::SlaveUtil::disable_super_read_only($dbh); ??}?else?{ ????$log->info("?not?present?or?turned?off,?ignoring.\n"); ??}
網(wǎng)站標(biāo)題:mha0.58gtid模式下丟數(shù)據(jù)問題修復(fù)
路徑分享:http://www.muchs.cn/article46/jpjshg.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供微信小程序、動(dòng)態(tài)網(wǎng)站、外貿(mào)網(wǎng)站建設(shè)、建站公司、全網(wǎng)營銷推廣、網(wǎng)頁設(shè)計(jì)公司
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請(qǐng)盡快告知,我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場,如需處理請(qǐng)聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時(shí)需注明來源: 創(chuàng)新互聯(lián)