Mysql MHA部署-05故障轉移

一 Mysql MHA部署-01介紹

二 Mysql MHA部署-02主從複製

三 Mysql MHA部署-03MHA軟體安裝

四 Mysql MHA部署-04MHA配置

五 Mysql MHA部署-05故障轉移

六 Mysql MHA部署-06手動切換

七 Mysql MHA部署-07常見問題

架構說明：

參考：

1 主庫187檢視IP和VIP資訊

[root@rac1 ~]# ifconfig

enp0s3: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500

inet 192.168.2.187 netmask 255.255.255.0 broadcast 192.168.2.255

inet6 fe80::c3b0:4e87:f38f:d640 prefixlen 64 scopeid 0x20<link>

inet6 fe80::a3a6:33e0:1848:f prefixlen 64 scopeid 0x20<link>

inet6 fe80::63c7:f30:11a7:4216 prefixlen 64 scopeid 0x20<link>

ether 08:00:27:83:9e:5c txqueuelen 1000 (Ethernet)

RX packets 12552 bytes 909017 (887.7 KiB)

RX errors 0 dropped 996 overruns 0 frame 0

TX packets 391 bytes 47354 (46.2 KiB)

TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

enp0s3:2: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500

inet 192.168.2.189 netmask 255.255.255.0 broadcast 192.168.2.255

ether 08:00:27:83:9e:5c txqueuelen 1000 (Ethernet)

2 從庫檢視當前同步資訊

---188：

mysql> show slave status \G;

*************************** 1. row ***************************

Slave_IO_State: Waiting for master to send event

Master_Host: 192.168.2.187

Master_User: repl

Master_Port: 3306

Connect_Retry: 60

Master_Log_File: mysql-bin.000010

Read_Master_Log_Pos: 250

Relay_Log_File: mysql-relay.000002

Relay_Log_Pos: 320

Relay_Master_Log_File: mysql-bin.000010

Slave_IO_Running: Yes

Slave_SQL_Running: Yes

---223：

mysql> show slave status \G;

*************************** 1. row ***************************

Slave_IO_State: Waiting for master to send event

Master_Host: 192.168.2.187

Master_User: repl

Master_Port: 3306

Connect_Retry: 60

Master_Log_File: mysql-bin.000010

Read_Master_Log_Pos: 250

Relay_Log_File: mysql-relay.000002

Relay_Log_Pos: 320

Relay_Master_Log_File: mysql-bin.000010

Slave_IO_Running: Yes

Slave_SQL_Running: Yes

Replicate_Do_DB:

3 管理節點檢視資訊

222：

[root@rac4 ~]# masterha_check_status --conf=/etc/mha/mha.conf

mha (pid:3057) is running(0:PING_OK), master:rac1

4 主庫手動停止mysql

187：

[mysql@rac1 ~]$ service mysqld stop

Shutting down MySQL..............[ OK ]

5 管理節點檢視故障轉移過程

222：

[root@rac4 manager]# tail -f mha.log

......

---(1) 確認主庫狀態(not reachable)

Sun Mar 15 14:01:16 2020 - [warning] Got error on MySQL select ping: 2006 (MySQL server has gone away)

Sun Mar 15 14:01:16 2020 - [info] Executing secondary network check script: /usr/bin/masterha_secondary_check -s 192.168.2.188 -s 192.168.2.223 --user=root --master_host=192.168.2.187 --master_ip=192.168.2.187 --master_port=3306 --user=root --master_host=rac1 --master_ip=192.168.2.187 --master_port=3306 --master_user=monitor --master_password=123456 --ping_type=SELECT

Sun Mar 15 14:01:16 2020 - [info] Executing SSH check script: save_binary_logs --command=test --start_pos=4 --binlog_dir=/datalog/mysql/binlog --output_file=/etc/mha/node/save_binary_logs_test --manager_version=0.56 --binlog_prefix=mysql-bin

Sun Mar 15 14:01:17 2020 - [info] HealthCheck: SSH to rac1 is reachable.

Monitoring server 192.168.2.188 is reachable, Master is not reachable from 192.168.2.188. OK.

Monitoring server 192.168.2.223 is reachable, Master is not reachable from 192.168.2.223. OK.

Sun Mar 15 14:01:17 2020 - [info] Master is not reachable from all other monitoring servers. Failover should start.

Sun Mar 15 14:01:17 2020 - [warning] Got error on MySQL connect: 2003 (Can't connect to MySQL server on '192.168.2.187' (111))

Sun Mar 15 14:01:17 2020 - [warning] Connection failed 2 time(s)..

Sun Mar 15 14:01:18 2020 - [warning] Got error on MySQL connect: 2003 (Can't connect to MySQL server on '192.168.2.187' (111))

Sun Mar 15 14:01:18 2020 - [warning] Connection failed 3 time(s)..

Sun Mar 15 14:01:19 2020 - [warning] Got error on MySQL connect: 2003 (Can't connect to MySQL server on '192.168.2.187' (111))

Sun Mar 15 14:01:19 2020 - [warning] Connection failed 4 time(s)..

Sun Mar 15 14:01:19 2020 - [warning] Master is not reachable from health checker!

Sun Mar 15 14:01:19 2020 - [warning] Master rac1(192.168.2.187:3306) is not reachable!

Sun Mar 15 14:01:19 2020 - [warning] SSH is reachable.

---(2) 重新檢查主從(rac1,rac2,rac3)伺服器狀態

---確定master is down，從庫rac2,rac3可用

Sun Mar 15 14:01:19 2020 - [info] Connecting to a master server failed. Reading configuration file /etc/masterha_default.cnf and /etc/mha/mha.conf again, and trying to connect to all servers to check server status..

Sun Mar 15 14:01:19 2020 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping.

Sun Mar 15 14:01:19 2020 - [info] Reading application default configuration from /etc/mha/mha.conf..

Sun Mar 15 14:01:19 2020 - [info] Reading server configuration from /etc/mha/mha.conf..

Sun Mar 15 14:01:20 2020 - [info] GTID failover mode = 0

Sun Mar 15 14:01:20 2020 - [info] Dead Servers:

Sun Mar 15 14:01:20 2020 - [info] rac1(192.168.2.187:3306)

Sun Mar 15 14:01:20 2020 - [info] Alive Servers:

Sun Mar 15 14:01:20 2020 - [info] rac2(192.168.2.188:3306)

Sun Mar 15 14:01:20 2020 - [info] rac3(192.168.2.223:3306)

Sun Mar 15 14:01:20 2020 - [info] Alive Slaves:

Sun Mar 15 14:01:20 2020 - [info] rac2(192.168.2.188:3306) Version=5.7.28-log (oldest major version between slaves) log-bin:enabled

Sun Mar 15 14:01:20 2020 - [info] Replicating from 192.168.2.187(192.168.2.187:3306)

Sun Mar 15 14:01:20 2020 - [info] Primary candidate for the new Master (candidate_master is set)

Sun Mar 15 14:01:20 2020 - [info] rac3(192.168.2.223:3306) Version=5.7.28-log (oldest major version between slaves) log-bin:enabled

Sun Mar 15 14:01:20 2020 - [info] Replicating from 192.168.2.187(192.168.2.187:3306)

Sun Mar 15 14:01:20 2020 - [info] Not candidate for the new Master (no_master is set)

Sun Mar 15 14:01:20 2020 - [info] Checking slave configurations..

Sun Mar 15 14:01:20 2020 - [warning] relay_log_purge=0 is not set on slave rac2(192.168.2.188:3306).

Sun Mar 15 14:01:20 2020 - [warning] relay_log_purge=0 is not set on slave rac3(192.168.2.223:3306).

Sun Mar 15 14:01:20 2020 - [info] Checking replication filtering settings..

Sun Mar 15 14:01:20 2020 - [info] Replication filtering check ok.

Sun Mar 15 14:01:20 2020 - [info] Master is down!

Sun Mar 15 14:01:20 2020 - [info] Terminating monitoring script.

Sun Mar 15 14:01:20 2020 - [info] Got exit code 20 (Master dead).

---(3) MasterFailover配置檔案確認

Sun Mar 15 14:01:20 2020 - [info] MHA::MasterFailover version 0.56.

Sun Mar 15 14:01:20 2020 - [info] Starting master failover.

Sun Mar 15 14:01:20 2020 - [info]

Sun Mar 15 14:01:20 2020 - [info] * Phase 1: Configuration Check Phase..

Sun Mar 15 14:01:20 2020 - [info]

Sun Mar 15 14:01:22 2020 - [info] GTID failover mode = 0

Sun Mar 15 14:01:22 2020 - [info] Dead Servers:

Sun Mar 15 14:01:22 2020 - [info] rac1(192.168.2.187:3306)

Sun Mar 15 14:01:22 2020 - [info] Checking master reachability via MySQL(double check)...

Sun Mar 15 14:01:22 2020 - [info] ok.

Sun Mar 15 14:01:22 2020 - [info] Alive Servers:

Sun Mar 15 14:01:22 2020 - [info] rac2(192.168.2.188:3306)

Sun Mar 15 14:01:22 2020 - [info] rac3(192.168.2.223:3306)

Sun Mar 15 14:01:22 2020 - [info] Alive Slaves:

Sun Mar 15 14:01:22 2020 - [info] rac2(192.168.2.188:3306) Version=5.7.28-log (oldest major version between slaves) log-bin:enabled

Sun Mar 15 14:01:22 2020 - [info] Replicating from 192.168.2.187(192.168.2.187:3306)

Sun Mar 15 14:01:22 2020 - [info] Primary candidate for the new Master (candidate_master is set)

Sun Mar 15 14:01:22 2020 - [info] rac3(192.168.2.223:3306) Version=5.7.28-log (oldest major version between slaves) log-bin:enabled

Sun Mar 15 14:01:22 2020 - [info] Replicating from 192.168.2.187(192.168.2.187:3306)

Sun Mar 15 14:01:22 2020 - [info] Not candidate for the new Master (no_master is set)

Sun Mar 15 14:01:22 2020 - [info] Starting Non-GTID based failover.

Sun Mar 15 14:01:22 2020 - [info]

---(4) 禁用rac1上的VIP,停止rac1

沒有定義shutdown_script，所以沒有呼叫

Sun Mar 15 14:01:22 2020 - [info] ** Phase 1: Configuration Check Phase completed.

Sun Mar 15 14:01:22 2020 - [info]

Sun Mar 15 14:01:22 2020 - [info] * Phase 2: Dead Master Shutdown Phase..

Sun Mar 15 14:01:22 2020 - [info]

Sun Mar 15 14:01:22 2020 - [info] Forcing shutdown so that applications never connect to the current master..

Sun Mar 15 14:01:22 2020 - [info] Executing master IP deactivation script:

Sun Mar 15 14:01:22 2020 - [info] /etc/mha/script/master_ip_failover --orig_master_host=rac1 --orig_master_ip=192.168.2.187 --orig_master_port=3306 --command=stopssh --ssh_user=root

Disabling the VIP an old master: rac1

---禁用VIP失敗了(估計是網路卡設定有問題)

SIOCSIFFLAGS: Cannot assign requested address

Sun Mar 15 14:01:22 2020 - [info] done.

Sun Mar 15 14:01:22 2020 - [warning] shutdown_script is not set. Skipping explicit shutting down of the dead master.

Sun Mar 15 14:01:22 2020 - [info] * Phase 2: Dead Master Shutdown Phase completed.

Sun Mar 15 14:01:22 2020 - [info]

---(5)主庫恢復獲取最新的slave

Sun Mar 15 14:01:22 2020 - [info] * Phase 3: Master Recovery Phase..

Sun Mar 15 14:01:22 2020 - [info]

Sun Mar 15 14:01:22 2020 - [info] * Phase 3.1: Getting Latest Slaves Phase..

Sun Mar 15 14:01:22 2020 - [info]

Sun Mar 15 14:01:22 2020 - [info] The latest binary log file/position on all slaves is mysql-bin.000015:250

Sun Mar 15 14:01:22 2020 - [info] Latest slaves (Slaves that received relay log files to the latest):

Sun Mar 15 14:01:22 2020 - [info] rac2(192.168.2.188:3306) Version=5.7.28-log (oldest major version between slaves) log-bin:enabled

Sun Mar 15 14:01:22 2020 - [info] Replicating from 192.168.2.187(192.168.2.187:3306)

Sun Mar 15 14:01:22 2020 - [info] Primary candidate for the new Master (candidate_master is set)

Sun Mar 15 14:01:22 2020 - [info] rac3(192.168.2.223:3306) Version=5.7.28-log (oldest major version between slaves) log-bin:enabled

Sun Mar 15 14:01:22 2020 - [info] Replicating from 192.168.2.187(192.168.2.187:3306)

Sun Mar 15 14:01:22 2020 - [info] Not candidate for the new Master (no_master is set)

Sun Mar 15 14:01:22 2020 - [info] The oldest binary log file/position on all slaves is mysql-bin.000015:250

Sun Mar 15 14:01:22 2020 - [info] Oldest slaves:

Sun Mar 15 14:01:22 2020 - [info] rac2(192.168.2.188:3306) Version=5.7.28-log (oldest major version between slaves) log-bin:enabled

Sun Mar 15 14:01:22 2020 - [info] Replicating from 192.168.2.187(192.168.2.187:3306)

Sun Mar 15 14:01:22 2020 - [info] Primary candidate for the new Master (candidate_master is set)

Sun Mar 15 14:01:22 2020 - [info] rac3(192.168.2.223:3306) Version=5.7.28-log (oldest major version between slaves) log-bin:enabled

Sun Mar 15 14:01:22 2020 - [info] Replicating from 192.168.2.187(192.168.2.187:3306)

Sun Mar 15 14:01:22 2020 - [info] Not candidate for the new Master (no_master is set)

Sun Mar 15 14:01:22 2020 - [info]

Sun Mar 15 14:01:22 2020 - [info] * Phase 3.2: Saving Dead Master's Binlog Phase..

Sun Mar 15 14:01:22 2020 - [info]

Sun Mar 15 14:01:22 2020 - [info] Fetching dead master's binary logs..

Sun Mar 15 14:01:22 2020 - [info] Executing command on the dead master rac1(192.168.2.187:3306): save_binary_logs --command=save --start_file=mysql-bin.000015 --start_pos=250 --binlog_dir=/datalog/mysql/binlog --output_file=/etc/mha/node/saved_master_binlog_from_rac1_3306_20200315140120.binlog --handle_raw_binlog=1 --disable_log_bin=0 --manager_version=0.56

Creating /etc/mha/node if not exists.. ok.

Concat binary/relay logs from mysql-bin.000015 pos 250 to mysql-bin.000015 EOF into /etc/mha/node/saved_master_binlog_from_rac1_3306_20200315140120.binlog ..

Binlog Checksum enabled

Dumping binlog format description event, from position 0 to 250.. ok.

No need to dump effective binlog data from /datalog/mysql/binlog/mysql-bin.000015 (pos starts 250, filesize 250). Skipping.

ERROR: Error in Log_event::read_log_event(): 'Found invalid event in binary log', data_len: 127, event_type: 35

Binlog Checksum enabled

/etc/mha/node/saved_master_binlog_from_rac1_3306_20200315140120.binlog has no effective data events.

Event not exists.

Sun Mar 15 14:01:23 2020 - [info] Additional events were not found from the orig master. No need to save.

Sun Mar 15 14:01:23 2020 - [info]

---(6)決定新的主庫188

Sun Mar 15 14:01:23 2020 - [info] * Phase 3.3: Determining New Master Phase..

Sun Mar 15 14:01:23 2020 - [info]

Sun Mar 15 14:01:23 2020 - [info] Finding the latest slave that has all relay logs for recovering other slaves..

Sun Mar 15 14:01:23 2020 - [info] All slaves received relay logs to the same position. No need to resync each other.

Sun Mar 15 14:01:23 2020 - [info] Searching new master from slaves..

Sun Mar 15 14:01:23 2020 - [info] Candidate masters from the configuration file:

Sun Mar 15 14:01:23 2020 - [info] rac2(192.168.2.188:3306) Version=5.7.28-log (oldest major version between slaves) log-bin:enabled

Sun Mar 15 14:01:23 2020 - [info] Replicating from 192.168.2.187(192.168.2.187:3306)

Sun Mar 15 14:01:23 2020 - [info] Primary candidate for the new Master (candidate_master is set)

Sun Mar 15 14:01:23 2020 - [info] Non-candidate masters:

Sun Mar 15 14:01:23 2020 - [info] rac3(192.168.2.223:3306) Version=5.7.28-log (oldest major version between slaves) log-bin:enabled

Sun Mar 15 14:01:23 2020 - [info] Replicating from 192.168.2.187(192.168.2.187:3306)

Sun Mar 15 14:01:23 2020 - [info] Not candidate for the new Master (no_master is set)

Sun Mar 15 14:01:23 2020 - [info] Searching from candidate_master slaves which have received the latest relay log events..

Sun Mar 15 14:01:23 2020 - [info] New master is rac2(192.168.2.188:3306)

Sun Mar 15 14:01:23 2020 - [info] Starting master failover..

Sun Mar 15 14:01:23 2020 - [info]

From:

rac1(192.168.2.187:3306) (current master)

+--rac2(192.168.2.188:3306)

+--rac3(192.168.2.223:3306)

To:

rac2(192.168.2.188:3306) (new master)

+--rac3(192.168.2.223:3306)

Sun Mar 15 14:01:23 2020 - [info]

Sun Mar 15 14:01:23 2020 - [info] * Phase 3.3: New Master Diff Log Generation Phase..

Sun Mar 15 14:01:23 2020 - [info]

Sun Mar 15 14:01:23 2020 - [info] This server has all relay logs. No need to generate diff files from the latest slave.

Sun Mar 15 14:01:23 2020 - [info]

Sun Mar 15 14:01:23 2020 - [info] * Phase 3.4: Master Log Apply Phase..

Sun Mar 15 14:01:23 2020 - [info]

Sun Mar 15 14:01:23 2020 - [info] *NOTICE: If any error happens from this phase, manual recovery is needed.

Sun Mar 15 14:01:23 2020 - [info] Starting recovery on rac2(192.168.2.188:3306)..

Sun Mar 15 14:01:23 2020 - [info] This server has all relay logs. Waiting all logs to be applied..

Sun Mar 15 14:01:23 2020 - [info] done.

Sun Mar 15 14:01:23 2020 - [info] All relay logs were successfully applied.

Sun Mar 15 14:01:23 2020 - [info] Getting new master's binlog name and position..

Sun Mar 15 14:01:23 2020 - [info] mysql-bin.000012:234

Sun Mar 15 14:01:23 2020 - [info] All other slaves should start replication from here. Statement should be: CHANGE MASTER TO MASTER_HOST='rac2 or 192.168.2.188', MASTER_PORT=3306, MASTER_LOG_FILE='mysql-bin.000012', MASTER_LOG_POS=234, MASTER_USER='repl', MASTER_PASSWORD='xxx';

Sun Mar 15 14:01:23 2020 - [info] Executing master IP activate script:

Sun Mar 15 14:01:23 2020 - [info] /etc/mha/script/master_ip_failover --command=start --ssh_user=root --orig_master_host=rac1 --orig_master_ip=192.168.2.187 --orig_master_port=3306 --new_master_host=rac2 --new_master_ip=192.168.2.188 --new_master_port=3306 --new_master_user='monitor' --new_master_password='123456'

Set read_only=0 on the new master.

Enabling the VIP 192.168.2.189 on the new master: rac2

Sun Mar 15 14:01:23 2020 - [info] OK.

Sun Mar 15 14:01:23 2020 - [info] ** Finished master recovery successfully.

Sun Mar 15 14:01:23 2020 - [info] * Phase 3: Master Recovery Phase completed.

Sun Mar 15 14:01:23 2020 - [info]

Sun Mar 15 14:01:23 2020 - [info] * Phase 4: Slaves Recovery Phase..

Sun Mar 15 14:01:23 2020 - [info]

Sun Mar 15 14:01:23 2020 - [info] * Phase 4.1: Starting Parallel Slave Diff Log Generation Phase..

Sun Mar 15 14:01:23 2020 - [info]

Sun Mar 15 14:01:23 2020 - [info] -- Slave diff file generation on host rac3(192.168.2.223:3306) started, pid: 10164. Check tmp log /etc/mha/manager/rac3_3306_20200315140120.log if it takes time..

Sun Mar 15 14:01:24 2020 - [info]

Sun Mar 15 14:01:24 2020 - [info] Log messages from rac3 ...

Sun Mar 15 14:01:24 2020 - [info]

Sun Mar 15 14:01:23 2020 - [info] This server has all relay logs. No need to generate diff files from the latest slave.

Sun Mar 15 14:01:24 2020 - [info] End of log messages from rac3.

Sun Mar 15 14:01:24 2020 - [info] -- rac3(192.168.2.223:3306) has the latest relay log events.

Sun Mar 15 14:01:24 2020 - [info] Generating relay diff files from the latest slave succeeded.

Sun Mar 15 14:01:24 2020 - [info]

Sun Mar 15 14:01:24 2020 - [info] * Phase 4.2: Starting Parallel Slave Log Apply Phase..

Sun Mar 15 14:01:24 2020 - [info]

Sun Mar 15 14:01:24 2020 - [info] -- Slave recovery on host rac3(192.168.2.223:3306) started, pid: 10166. Check tmp log /etc/mha/manager/rac3_3306_20200315140120.log if it takes time..

Sun Mar 15 14:01:25 2020 - [info]

Sun Mar 15 14:01:25 2020 - [info] Log messages from rac3 ...

Sun Mar 15 14:01:25 2020 - [info]

Sun Mar 15 14:01:24 2020 - [info] Starting recovery on rac3(192.168.2.223:3306)..

Sun Mar 15 14:01:24 2020 - [info] This server has all relay logs. Waiting all logs to be applied..

Sun Mar 15 14:01:24 2020 - [info] done.

Sun Mar 15 14:01:24 2020 - [info] All relay logs were successfully applied.

Sun Mar 15 14:01:24 2020 - [info] Resetting slave rac3(192.168.2.223:3306) and starting replication from the new master rac2(192.168.2.188:3306)..

Sun Mar 15 14:01:24 2020 - [info] Executed CHANGE MASTER.

Sun Mar 15 14:01:24 2020 - [info] Slave started.

Sun Mar 15 14:01:25 2020 - [info] End of log messages from rac3.

Sun Mar 15 14:01:25 2020 - [info] -- Slave recovery on host rac3(192.168.2.223:3306) succeeded.

Sun Mar 15 14:01:25 2020 - [info] All new slave servers recovered successfully.

Sun Mar 15 14:01:25 2020 - [info]

---(7) 清理階段

Sun Mar 15 14:01:25 2020 - [info] * Phase 5: New master cleanup phase..

Sun Mar 15 14:01:25 2020 - [info]

Sun Mar 15 14:01:25 2020 - [info] Resetting slave info on the new master..

Sun Mar 15 14:01:25 2020 - [info] rac2: Resetting slave info succeeded.

Sun Mar 15 14:01:25 2020 - [info] Master failover to rac2(192.168.2.188:3306) completed successfully.

Sun Mar 15 14:01:25 2020 - [info] Deleted server1 entry from /etc/mha/mha.conf .

Sun Mar 15 14:01:25 2020 - [info]

---(8) failover報告

- ---- Failover Report -----

mha: MySQL Master failover rac1(192.168.2.187:3306) to rac2(192.168.2.188:3306) succeeded

Master rac1(192.168.2.187:3306) is down!

Check MHA Manager logs at rac4:/etc/mha/manager/mha.log for details.

Started automated(non-interactive) failover.

Invalidated master IP address on rac1(192.168.2.187:3306)

The latest slave rac2(192.168.2.188:3306) has all relay logs for recovery.

Selected rac2(192.168.2.188:3306) as a new master.

rac2(192.168.2.188:3306): OK: Applying all logs succeeded.

rac2(192.168.2.188:3306): OK: Activated master IP address.

rac3(192.168.2.223:3306): This host has the latest relay log events.

Generating relay diff files from the latest slave succeeded.

rac3(192.168.2.223:3306): OK: Applying all logs succeeded. Slave started, replicating from rac2(192.168.2.188:3306)

rac2(192.168.2.188:3306): Resetting slave info succeeded.

Master failover to rac2(192.168.2.188:3306) completed successfully.

6 檢視223從庫對應的主庫已經由187自動切換成188

223:

mysql> show slave status \G;

*************************** 1. row ***************************

Slave_IO_State: Waiting for master to send event

Master_Host: 192.168.2.188

Master_User: repl

Master_Port: 3306

Connect_Retry: 60

Master_Log_File: mysql-bin.000009

Read_Master_Log_Pos: 234

Relay_Log_File: mysql-relay.000008

Relay_Log_Pos: 407

Relay_Master_Log_File: mysql-bin.000009

Slave_IO_Running: Yes

Slave_SQL_Running: Yes

7 檢視VIP189已經從187節點漂移到188

188:

[root@rac2 ~]# ifconfig |grep 192

inet 192.168.2.188 netmask 255.255.255.0 broadcast 192.168.2.255

inet 192.168.2.189 netmask 255.255.255.0 broadcast 192.168.2.255

inet 192.168.122.1 netmask 255.255.255.0 broadcast 192.168.122.255

歡迎關注我的微信公眾號"IT小Chen"，共同學習，共同成長！！！

Mysql MHA部署-05故障轉移

Mysql MHA部署-05故障轉移

相關文章