溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務條款》
您好，登錄后才能下訂單哦！
1、切換過程，注意需要關閉masterha_manager
[root@es3?~]#??masterha_master_switch?--master_state=alive?--conf=/root/app1.cnf?--new_master_host=es3?--orig_master_is_new_slave Tue?Aug?20?10:12:02?2019?-?[info]?MHA::MasterRotate?version?0.58. Tue?Aug?20?10:12:02?2019?-?[info]?Starting?online?master?switch.. Tue?Aug?20?10:12:02?2019?-?[info]? Tue?Aug?20?10:12:02?2019?-?[info]?*?Phase?1:?Configuration?Check?Phase.. Tue?Aug?20?10:12:02?2019?-?[info]? Tue?Aug?20?10:12:02?2019?-?[warning]?Global?configuration?file?/etc/masterha_default.cnf?not?found.?Skipping. Tue?Aug?20?10:12:02?2019?-?[info]?Reading?application?default?configuration?from?/root/app1.cnf.. Tue?Aug?20?10:12:02?2019?-?[info]?Reading?server?configuration?from?/root/app1.cnf.. Tue?Aug?20?10:12:03?2019?-?[info]?GTID?failover?mode?=?1 Tue?Aug?20?10:12:03?2019?-?[info]?Current?Alive?Master:?es1(192.168.56.14:3306) Tue?Aug?20?10:12:03?2019?-?[info]?Alive?Slaves: Tue?Aug?20?10:12:03?2019?-?[info]???es2(192.168.56.15:3306)??Version=5.7.24-log?(oldest?major?version?between?slaves)?log-bin:enabled Tue?Aug?20?10:12:03?2019?-?[info]?????GTID?ON Tue?Aug?20?10:12:03?2019?-?[info]?????Replicating?from?192.168.56.14(192.168.56.14:3306) Tue?Aug?20?10:12:03?2019?-?[info]???es3(192.168.56.16:3306)??Version=5.7.24-log?(oldest?major?version?between?slaves)?log-bin:enabled Tue?Aug?20?10:12:03?2019?-?[info]?????GTID?ON Tue?Aug?20?10:12:03?2019?-?[info]?????Replicating?from?es1(192.168.56.14:3306) It?is?better?to?execute?FLUSH?NO_WRITE_TO_BINLOG?TABLES?on?the?master?before?switching.?Is?it?ok?to?execute?on?es1(192.168.56.14:3306)??(YES/no):?yes Tue?Aug?20?10:12:06?2019?-?[info]?Executing?FLUSH?NO_WRITE_TO_BINLOG?TABLES.?This?may?take?long?time.. Tue?Aug?20?10:12:06?2019?-?[info]??ok. Tue?Aug?20?10:12:06?2019?-?[info]?Checking?MHA?is?not?monitoring?or?doing?failover.. Tue?Aug?20?10:12:06?2019?-?[info]?Checking?replication?health?on?es2.. Tue?Aug?20?10:12:06?2019?-?[info]??ok. Tue?Aug?20?10:12:06?2019?-?[info]?Checking?replication?health?on?es3.. Tue?Aug?20?10:12:06?2019?-?[info]??ok. Tue?Aug?20?10:12:06?2019?-?[info]?es3?can?be?new?master. Tue?Aug?20?10:12:06?2019?-?[info]? From: es1(192.168.56.14:3306)?(current?master) ?+--es2(192.168.56.15:3306) ?+--es3(192.168.56.16:3306) To: es3(192.168.56.16:3306)?(new?master) ?+--es2(192.168.56.15:3306) ?+--es1(192.168.56.14:3306) Starting?master?switch?from?es1(192.168.56.14:3306)?to?es3(192.168.56.16:3306)??(yes/NO):?yes Tue?Aug?20?10:12:11?2019?-?[info]?Checking?whether?es3(192.168.56.16:3306)?is?ok?for?the?new?master.. Tue?Aug?20?10:12:11?2019?-?[info]??ok. Tue?Aug?20?10:12:11?2019?-?[info]?es1(192.168.56.14:3306):?SHOW?SLAVE?STATUS?returned?empty?result.?To?check?replication?filtering?rules,?temporarily?executing?CHANGE?MASTER?to?a?dummy?host. Tue?Aug?20?10:12:11?2019?-?[info]?es1(192.168.56.14:3306):?Resetting?slave?pointing?to?the?dummy?host. Tue?Aug?20?10:12:11?2019?-?[info]?**?Phase?1:?Configuration?Check?Phase?completed. Tue?Aug?20?10:12:11?2019?-?[info]? Tue?Aug?20?10:12:11?2019?-?[info]?*?Phase?2:?Rejecting?updates?Phase.. Tue?Aug?20?10:12:11?2019?-?[info]? Tue?Aug?20?10:12:11?2019?-?[info]?Executing?master?ip?online?change?script?to?disable?write?on?the?current?master: Tue?Aug?20?10:12:11?2019?-?[info]???/usr/local/bin/master_ip_online_change?--command=stop?--orig_master_host=es1?--orig_master_ip=192.168.56.14?--orig_master_port=3306?--orig_master_user='repl'?--new_master_host=es3?--new_master_ip=192.168.56.16?--new_master_port=3306?--new_master_user='repl'?--orig_master_ssh_user=root?--new_master_ssh_user=root???--orig_master_is_new_slave?--orig_master_password=xxx?--new_master_password=xxx *************************************************************** Disabling?the?VIP?-?192.168.56.191/24?on?old?master:?es1 *************************************************************** Tue?Aug?20?10:12:12?2019?-?[info]??ok. Tue?Aug?20?10:12:12?2019?-?[info]?Locking?all?tables?on?the?orig?master?to?reject?updates?from?everybody?(including?root): Tue?Aug?20?10:12:12?2019?-?[info]?Executing?FLUSH?TABLES?WITH?READ?LOCK.. Tue?Aug?20?10:12:12?2019?-?[info]??ok. Tue?Aug?20?10:12:12?2019?-?[info]?Orig?master?binlog:pos?is?mysqlbin.000005:194. Tue?Aug?20?10:12:12?2019?-?[info]??Waiting?to?execute?all?relay?logs?on?es3(192.168.56.16:3306).. Tue?Aug?20?10:12:12?2019?-?[info]??master_pos_wait(mysqlbin.000005:194)?completed?on?es3(192.168.56.16:3306).?Executed?0?events. Tue?Aug?20?10:12:12?2019?-?[info]???done. Tue?Aug?20?10:12:12?2019?-?[info]?Getting?new?master's?binlog?name?and?position.. Tue?Aug?20?10:12:12?2019?-?[info]??mysqlbin.000004:154 Tue?Aug?20?10:12:12?2019?-?[info]??All?other?slaves?should?start?replication?from?here.?Statement?should?be:?CHANGE?MASTER?TO?MASTER_HOST='es3?or?192.168.56.16',?MASTER_PORT=3306,?MASTER_AUTO_POSITION=1,?MASTER_USER='repl',?MASTER_PASSWORD='xxx'; Tue?Aug?20?10:12:12?2019?-?[info]?Executing?master?ip?online?change?script?to?allow?write?on?the?new?master: Tue?Aug?20?10:12:12?2019?-?[info]???/usr/local/bin/master_ip_online_change?--command=start?--orig_master_host=es1?--orig_master_ip=192.168.56.14?--orig_master_port=3306?--orig_master_user='repl'?--new_master_host=es3?--new_master_ip=192.168.56.16?--new_master_port=3306?--new_master_user='repl'?--orig_master_ssh_user=root?--new_master_ssh_user=root???--orig_master_is_new_slave?--orig_master_password=xxx?--new_master_password=xxx *************************************************************** Enabling?the?VIP?-?192.168.56.191/24?on?new?master:?es3? *************************************************************** Tue?Aug?20?10:12:13?2019?-?[info]??ok. Tue?Aug?20?10:12:13?2019?-?[info]? Tue?Aug?20?10:12:13?2019?-?[info]?*?Switching?slaves?in?parallel.. Tue?Aug?20?10:12:13?2019?-?[info]? Tue?Aug?20?10:12:13?2019?-?[info]?--?Slave?switch?on?host?es2(192.168.56.15:3306)?started,?pid:?4076 Tue?Aug?20?10:12:13?2019?-?[info]? Tue?Aug?20?10:12:14?2019?-?[info]?Log?messages?from?es2?... Tue?Aug?20?10:12:14?2019?-?[info]? Tue?Aug?20?10:12:13?2019?-?[info]??Waiting?to?execute?all?relay?logs?on?es2(192.168.56.15:3306).. Tue?Aug?20?10:12:13?2019?-?[info]??master_pos_wait(mysqlbin.000005:194)?completed?on?es2(192.168.56.15:3306).?Executed?0?events. Tue?Aug?20?10:12:13?2019?-?[info]???done. Tue?Aug?20?10:12:13?2019?-?[info]??Resetting?slave?es2(192.168.56.15:3306)?and?starting?replication?from?the?new?master?es3(192.168.56.16:3306).. Tue?Aug?20?10:12:13?2019?-?[info]??Executed?CHANGE?MASTER. Tue?Aug?20?10:12:13?2019?-?[info]??Slave?started. Tue?Aug?20?10:12:14?2019?-?[info]?End?of?log?messages?from?es2?... Tue?Aug?20?10:12:14?2019?-?[info]? Tue?Aug?20?10:12:14?2019?-?[info]?--?Slave?switch?on?host?es2(192.168.56.15:3306)?succeeded. Tue?Aug?20?10:12:14?2019?-?[info]?Unlocking?all?tables?on?the?orig?master: Tue?Aug?20?10:12:14?2019?-?[info]?Executing?UNLOCK?TABLES.. Tue?Aug?20?10:12:14?2019?-?[info]??ok. Tue?Aug?20?10:12:14?2019?-?[info]?Starting?orig?master?as?a?new?slave.. Tue?Aug?20?10:12:14?2019?-?[info]??Resetting?slave?es1(192.168.56.14:3306)?and?starting?replication?from?the?new?master?es3(192.168.56.16:3306).. Tue?Aug?20?10:12:14?2019?-?[info]??Executed?CHANGE?MASTER. Tue?Aug?20?10:12:14?2019?-?[info]??Slave?started. Tue?Aug?20?10:12:14?2019?-?[info]?All?new?slave?servers?switched?successfully. Tue?Aug?20?10:12:14?2019?-?[info]? Tue?Aug?20?10:12:14?2019?-?[info]?*?Phase?5:?New?master?cleanup?phase.. Tue?Aug?20?10:12:14?2019?-?[info]? Tue?Aug?20?10:12:14?2019?-?[info]??es3:?Resetting?slave?info?succeeded. Tue?Aug?20?10:12:14?2019?-?[info]?Switching?master?to?es3(192.168.56.16:3306)?completed?successfully. [root@es3?~]#?ip?addr 1:?lo:?<LOOPBACK,UP,LOWER_UP>?mtu?65536?qdisc?noqueue?state?UNKNOWN?group?default?qlen?1000 ????link/loopback?00:00:00:00:00:00?brd?00:00:00:00:00:00 ????inet?127.0.0.1/8?scope?host?lo ???????valid_lft?forever?preferred_lft?forever ????inet6?::1/128?scope?host? ???????valid_lft?forever?preferred_lft?forever 2:?enp0s3:?<BROADCAST,MULTICAST,UP,LOWER_UP>?mtu?1500?qdisc?pfifo_fast?state?UP?group?default?qlen?1000 ????link/ether?08:00:27:ed:8b:51?brd?ff:ff:ff:ff:ff:ff ????inet?10.0.2.15/24?brd?10.0.2.255?scope?global?noprefixroute?dynamic?enp0s3 ???????valid_lft?84197sec?preferred_lft?84197sec ????inet6?fe80::c377:b5dd:2937:f269/64?scope?link?noprefixroute? ???????valid_lft?forever?preferred_lft?forever 3:?enp0s8:?<BROADCAST,MULTICAST,UP,LOWER_UP>?mtu?1500?qdisc?pfifo_fast?state?UP?group?default?qlen?1000 ????link/ether?08:00:27:1f:f9:c8?brd?ff:ff:ff:ff:ff:ff ????inet?192.168.56.16/24?brd?192.168.56.255?scope?global?noprefixroute?dynamic?enp0s8 ???????valid_lft?1030sec?preferred_lft?1030sec ????inet?192.168.56.191/24?brd?192.168.56.255?scope?global?secondary?enp0s8:1 ???????valid_lft?forever?preferred_lft?forever ????inet6?fe80::90e0:253d:ab32:8ba4/64?scope?link?noprefixroute? ???????valid_lft?forever?preferred_lft?forever [root@es3?~]#
免責聲明：本站發布的內容（圖片、視頻和文字）以原創、轉載和分享為主，文章觀點不代表本網站立場，如果涉及侵權請聯系站長郵箱：is@yisu.com進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
