Mysql MHA布局怎样进行故障转移
发布时间：2022-01-13 14:17:02 所属栏目：MySql教程 来源：互联网
导读：这篇文章给大家介绍Mysql MHA部署怎样进行故障转移，内容非常详细，感兴趣的小伙伴们可以参考借鉴，希望对大家能有所帮助。 架构说明： 1 主库187查看IP和VIP信息 [root@rac1 ~]# ifconfig enp0s3: flags=4163UP,BROADCAST,RUNNING,MULTICAST mtu 1500 ine
|
这篇文章给大家介绍Mysql MHA部署怎样进行故障转移，内容非常详细，感兴趣的小伙伴们可以参考借鉴，希望对大家能有所帮助。 架构说明： 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 （编辑：随州站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
站长推荐
热点阅读
