MySQL高可用之MHA安装
Preface
MasterHA is a tool which can be used in MySQL HA architecture.I'm gonna implement it and have some tests depend on it later.
Framework
Procedure
Downlaod the rpm package of MasterHA using below web link first:
https://code.google.com/archive/p/mysql-master-ha/downloads
MasterHA's wiki document.
https://github.com/yoshinorim/mha4mysql-manager/wiki
Configure ssh authentication between zlm2 and zlm3 from each other.
扫码关注我们
微信号:SRE实战
拒绝背锅 运筹帷幄
Hostname | IP | Port | Identity | OS Version | MySQL Version |
zlm2 | 192.168.1.101 | 3306 | master | CentOS 7.0 | 5.7.21 |
zlm3 | 192.168.1.102 | 3306 | slave/mha-manager | CentOS 7.0 | 5.7.21 |
null | 192.168.1.200 | null | vip | null | null |
1 [root@zlm2 09:00:44 ~] 2 #ssh-keygen -t rsa 3 Generating public/private rsa key pair. 4 Enter file in which to save the key (/root/.ssh/id_rsa): 5 Enter passphrase (empty for no passphrase): 6 Enter same passphrase again: 7 Your identification has been saved in /root/.ssh/id_rsa. 8 Your public key has been saved in /root/.ssh/id_rsa.pub. 9 The key fingerprint is: 10 48:36:15:af:d7:97:3c:94:f3:0e:bc:ea:34:f1:bc:43 root@zlm2 11 The key's randomart image is: 12 +--[ RSA 2048]----+ 13 | o. | 14 | . . . | 15 | + . + | 16 | o o . . + + | 17 | . S . o B .| 18 | . =E= | 19 | o.+ .| 20 | . o.. | 21 | .o .. | 22 +-----------------+ 23 24 [root@zlm2 09:03:04 ~] 25 #cd .ssh 26 27 [root@zlm2 09:03:09 ~/.ssh] 28 #ls -l 29 total 12 30 -rw------- 1 root root 1675 Aug 2 09:02 id_rsa 31 -rw-r--r-- 1 root root 391 Aug 2 09:02 id_rsa.pub 32 -rw-r--r-- 1 root root 360 Jun 13 09:51 known_hosts 33 34 [root@zlm2 09:03:18 ~/.ssh] 35 #cat id_rsa.pub >> authorized_keys 36 37 [root@zlm2 09:07:51 ~/.ssh] 38 #scp ./* zlm3:~/.ssh/ 39 root@zlm3's password: 40 authorized_keys 100% 391 0.4KB/s 00:00 41 id_rsa 100% 1675 1.6KB/s 00:00 42 id_rsa.pub 100% 391 0.4KB/s 00:00 43 known_hosts 100% 360 0.4KB/s 00:00 44 45 [root@zlm2 09:08:22 ~/.ssh] 46 #ssh zlm3 47 Last login: Thu Aug 2 08:47:54 2018 from 192.168.1.1 48 Welcome to your Vagrant-built virtual machine. 49 50 [root@zlm3 09:10:39 ~] 51 # 52 53 [root@zlm3 09:11:13 ~/.ssh] 54 #ssh zlm2 55 The authenticity of host 'zlm2 (192.168.1.101)' can't be established. 56 ECDSA key fingerprint is 75:06:22:b7:e2:3b:46:88:51:97:c4:4f:27:20:21:26. 57 Are you sure you want to continue connecting (yes/no)? yes 58 Warning: Permanently added 'zlm2,192.168.1.101' (ECDSA) to the list of known hosts. 59 Last login: Thu Aug 2 03:29:04 2018 from 192.168.1.1 60 Welcome to your Vagrant-built virtual machine. 61 62 [root@zlm2 09:11:22 ~] 63 #
Configure a master-slave replication.
1 [root@zlm2 09:18:30 ~] 2 #scp db3306_20180802.sql zlm3:~/ 3 db3306_20180802.sql 100% 8429KB 8.2MB/s 00:00 4 5 [root@zlm3 09:19:55 ~] 6 #mysql < db3306_20180802.sql 7 ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty. 8 9 [root@zlm3 09:20:00 ~] 10 #mysql 11 Welcome to the MySQL monitor. Commands end with ; or \g. 12 Your MySQL connection id is 3 13 Server version: 5.7.21-log MySQL Community Server (GPL) 14 15 Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. 16 17 Oracle is a registered trademark of Oracle Corporation and/or its 18 affiliates. Other names may be trademarks of their respective 19 owners. 20 21 Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 22 23 (zlm@192.168.1.102 3306)[(none)]>reset master; 24 Query OK, 0 rows affected (0.03 sec) 25 26 (zlm@192.168.1.102 3306)[(none)]>exit 27 Bye 28 29 [root@zlm3 09:20:28 ~] 30 #mysql < db3306_20180802.sql 31 32 [root@zlm3 09:20:34 ~] 33 #mysql 34 Welcome to the MySQL monitor. Commands end with ; or \g. 35 Your MySQL connection id is 5 36 Server version: 5.7.21-log MySQL Community Server (GPL) 37 38 Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. 39 40 Oracle is a registered trademark of Oracle Corporation and/or its 41 affiliates. Other names may be trademarks of their respective 42 owners. 43 44 Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 45 46 (zlm@192.168.1.102 3306)[(none)]>change master to \ 47 -> master_host='192.168.1.101',\ 48 -> master_port=3306,\ 49 -> master_user='repl',\ 50 -> master_password='repl4slave',\ 51 -> master_auto_position=1; 52 Query OK, 0 rows affected, 2 warnings (0.02 sec) 53 54 (zlm@192.168.1.102 3306)[(none)]>start slave; 55 Query OK, 0 rows affected (0.00 sec) 56 57 (zlm@192.168.1.102 3306)[(none)]>show slave status\G 58 *************************** 1. row *************************** 59 Slave_IO_State: Waiting for master to send event 60 Master_Host: 192.168.1.101 61 Master_User: repl 62 Master_Port: 3306 63 Connect_Retry: 60 64 Master_Log_File: mysql-bin.000048 65 Read_Master_Log_Pos: 736 66 Relay_Log_File: relay-bin.000002 67 Relay_Log_Pos: 398 68 Relay_Master_Log_File: mysql-bin.000048 69 Slave_IO_Running: Yes 70 Slave_SQL_Running: Yes 71 Replicate_Do_DB: 72 Replicate_Ignore_DB: 73 Replicate_Do_Table: 74 Replicate_Ignore_Table: 75 Replicate_Wild_Do_Table: 76 Replicate_Wild_Ignore_Table: 77 Last_Errno: 0 78 Last_Error: 79 Skip_Counter: 0 80 Exec_Master_Log_Pos: 736 81 Relay_Log_Space: 591 82 Until_Condition: None 83 Until_Log_File: 84 Until_Log_Pos: 0 85 Master_SSL_Allowed: No 86 Master_SSL_CA_File: 87 Master_SSL_CA_Path: 88 Master_SSL_Cert: 89 Master_SSL_Cipher: 90 Master_SSL_Key: 91 Seconds_Behind_Master: 0 92 Master_SSL_Verify_Server_Cert: No 93 Last_IO_Errno: 0 94 Last_IO_Error: 95 Last_SQL_Errno: 0 96 Last_SQL_Error: 97 Replicate_Ignore_Server_Ids: 98 Master_Server_Id: 1013306 99 Master_UUID: 1b7181ee-6eaf-11e8-998e-080027de0e0e 100 Master_Info_File: mysql.slave_master_info 101 SQL_Delay: 0 102 SQL_Remaining_Delay: NULL 103 Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates 104 Master_Retry_Count: 86400 105 Master_Bind: 106 Last_IO_Error_Timestamp: 107 Last_SQL_Error_Timestamp: 108 Master_SSL_Crl: 109 Master_SSL_Crlpath: 110 Retrieved_Gtid_Set: 111 Executed_Gtid_Set: 1b7181ee-6eaf-11e8-998e-080027de0e0e:1-3730247 112 Auto_Position: 1 113 Replicate_Rewrite_DB: 114 Channel_Name: 115 Master_TLS_Version: 116 1 row in set (0.00 sec)
SRE实战 互联网时代守护先锋,助力企业售后服务体系运筹帷幄!一键直达领取阿里云限量特价优惠。
Install dependency packge first.
1 [root@zlm2 09:32:28 ~] 2 #yum install -y perl-Time-HiRes perl-DBD-MySQL perl-Config-Tiny perl-Log-Dispatch perl-Parallel-ForkManager 3 4 [root@zlm2 09:33:56 ~] 5 #ssh zlm3 6 Last login: Thu Aug 2 09:10:39 2018 from 192.168.1.101 7 Welcome to your Vagrant-built virtual machine. 8 9 [root@zlm3 09:34:03 ~] 10 #yum install -y perl-Time-HiRes perl-DBD-MySQL perl-Config-Tiny perl-Log-Dispatch perl-Parallel-ForkManager
Install both manager and node rpm on master and slave.
1 [root@zlm2 09:39:08 ~] 2 #rpm -ivh mha4mysql-manager-0.56-0.el6.noarch.rpm 3 error: Failed dependencies: 4 mha4mysql-node >= 0.54 is needed by mha4mysql-manager-0.56-0.el6.noarch 5 perl(MHA::BinlogManager) is needed by mha4mysql-manager-0.56-0.el6.noarch 6 perl(MHA::NodeConst) is needed by mha4mysql-manager-0.56-0.el6.noarch 7 perl(MHA::NodeUtil) is needed by mha4mysql-manager-0.56-0.el6.noarch 8 perl(MHA::SlaveUtil) is needed by mha4mysql-manager-0.56-0.el6.noarch 9 10 [root@zlm2 09:39:16 ~] 11 #rpm -ivh mha4mysql-node-0.56-0.el6.noarch.rpm 12 Preparing... ################################# [100%] 13 Updating / installing... 14 1:mha4mysql-node-0.56-0.el6 ################################# [100%] 15 16 [root@zlm2 09:39:48 ~] 17 #rpm -ivh mha4mysql-manager-0.56-0.el6.noarch.rpm 18 Preparing... ################################# [100%] 19 Updating / installing... 20 1:mha4mysql-manager-0.56-0.el6 ################################# [100%] 21 22 [root@zlm2 09:39:53 ~] 23 #ssh zlm3 24 Last login: Thu Aug 2 09:34:03 2018 from 192.168.1.101 25 Welcome to your Vagrant-built virtual machine. 26 27 [root@zlm3 09:41:46 ~] 28 #rpm -ivh mha4mysql-node-0.56-0.el6.noarch.rpm 29 Preparing... ################################# [100%] 30 Updating / installing... 31 1:mha4mysql-node-0.56-0.el6 ################################# [100%] 32 33 [root@zlm3 09:42:03 ~] 34 #rpm -ivh mha4mysql-manager-0.56-0.el6.noarch.rpm 35 Preparing... ################################# [100%] 36 Updating / installing... 37 1:mha4mysql-manager-0.56-0.el6 ################################# [100%]
Configure the conf files on each manager node.
1 [root@zlm2 09:48:22 ~] 2 #mkdir -p /var/log/masterha/app1 3 4 [root@zlm2 09:48:28 ~] 5 #mkdir /etc/masterha 6 7 [root@zlm2 09:48:35 ~] 8 #cp /vagrant/masterha/* /etc/masterha/ 9 10 [root@zlm2 09:50:02 ~] 11 #cd /etc/masterha/ 12 13 [root@zlm2 09:50:09 /etc/masterha] 14 #ll 15 total 36 16 -rwxr-xr-x 1 root root 614 Aug 2 09:50 app1.conf 17 -rwxr-xr-x 1 root root 55 Aug 2 09:50 drop_vip.sh 18 -rwxr-xr-x 1 root root 55 Aug 2 09:50 init_vip.sh 19 -rwxr-xr-x 1 root root 384 Aug 2 09:50 masterha_default.conf 20 -rwxr-xr-x 1 root root 4438 Aug 2 09:50 master_ip_failover 21 -rwxr-xr-x 1 root root 10526 Aug 2 09:50 master_ip_online_change 22 23 [root@zlm2 09:51:46 /etc/masterha] 24 #cat masterha_default.conf 25 [server default] 26 #log_level=debug 27 user=zlm 28 password=zlmzlm 29 30 ssh_user=root 31 ssh_port=3306 32 33 repl_user=repl 34 repl_password=repl4slave 35 36 ping_interval=1 37 #shutdown_script="" 38 39 master_ip_failover_script= /etc/masterha/master_ip_failover 40 master_ip_online_change_script= /etc/masterha/master_ip_online_change 41 42 [root@zlm2 09:53:56 /etc/masterha] 43 #cat app1.conf 44 [server default] 45 46 manager_workdir = /var/log/masterha/app1 47 manager_log = /var/log/masterha/app1/app1.log 48 remote_workdir = /var/log/masterha/app1 49 50 [server1] 51 hostname=192.168.1.101 52 master_binlog_dir = /data/mysql/mysql3306/logs 53 candidate_master = 1 54 check_repl_delay = 0 55 56 [server2] 57 hostname=192.168.1.102 58 master_binlog_dir=/data/mysql/mysql3306/logs 59 candidate_master=1 60 check_repl_delay=0 61 62 [root@zlm2 09:56:20 /etc/masterha] 63 #cat init_vip.sh 64 vip="192.168.1.200/24" 65 /sbin/ip addr add $vip dev enp0s8 66 67 [root@zlm2 09:56:23 /etc/masterha] 68 #cat drop_vip.sh 69 vip="192.168.1.200/24" 70 /sbin/ip addr del $vip dev enp0s8 71 72 [root@zlm2 09:57:27 /etc/masterha] 73 #ssh zlm3 74 Last login: Thu Aug 2 09:40:20 2018 from 192.168.1.1 75 Welcome to your Vagrant-built virtual machine. 76 77 [root@zlm3 09:58:04 ~] 78 #mkdir -p /var/log/masterha/app1 79 80 [root@zlm3 09:58:16 ~] 81 #mkdir /etc/masterha 82 83 [root@zlm3 09:58:30 ~] 84 #scp zlm2:/etc/masterha/* /etc/masterha 85 app1.conf 100% 498 0.5KB/s 00:00 86 drop_vip.sh 100% 57 0.1KB/s 00:00 87 init_vip.sh 100% 57 0.1KB/s 00:00 88 masterha_default.conf 100% 387 0.4KB/s 00:00 89 master_ip_failover 100% 4438 4.3KB/s 00:00 90 master_ip_online_change 100% 10KB 10.3KB/s 00:00
Check the masterha status on both nodes..
1 [root@zlm2 10:00:26 /etc/masterha] 2 #masterha_ 3 masterha_check_repl masterha_check_status masterha_manager masterha_master_switch masterha_stop 4 masterha_check_ssh masterha_conf_host masterha_master_monitor masterha_secondary_check 5 6 [root@zlm2 10:00:26 /etc/masterha] 7 #masterha_check_status --conf=./app1.conf 8 app1 is stopped(2:NOT_RUNNING). 9 10 [root@zlm2 10:01:45 /etc/masterha] 11 #masterha_check_ssh --conf=./app1.conf 12 Thu Aug 2 10:02:05 2018 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping. 13 Thu Aug 2 10:02:05 2018 - [info] Reading application default configuration from ./app1.conf.. 14 Thu Aug 2 10:02:05 2018 - [info] Reading server configuration from ./app1.conf.. 15 Thu Aug 2 10:02:05 2018 - [info] Starting SSH connection tests.. 16 Thu Aug 2 10:02:06 2018 - [debug] 17 Thu Aug 2 10:02:05 2018 - [debug] Connecting via SSH from root@192.168.1.101(192.168.1.101:22) to root@192.168.1.102(192.168.1.102:22).. 18 Warning: Permanently added '192.168.1.101' (ECDSA) to the list of known hosts. 19 Thu Aug 2 10:02:06 2018 - [debug] ok. 20 Thu Aug 2 10:02:06 2018 - [debug] 21 Thu Aug 2 10:02:06 2018 - [debug] Connecting via SSH from root@192.168.1.102(192.168.1.102:22) to root@192.168.1.101(192.168.1.101:22).. 22 Thu Aug 2 10:02:06 2018 - [debug] ok. 23 Thu Aug 2 10:02:06 2018 - [info] All SSH connection tests passed successfully. 24 25 [root@zlm2 10:02:06 /etc/masterha] 26 #masterha_check_repl --conf=./app1.conf 27 Thu Aug 2 10:02:15 2018 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping. 28 Thu Aug 2 10:02:15 2018 - [info] Reading application default configuration from ./app1.conf.. 29 Thu Aug 2 10:02:15 2018 - [info] Reading server configuration from ./app1.conf.. 30 Thu Aug 2 10:02:15 2018 - [info] MHA::MasterMonitor version 0.56. 31 Thu Aug 2 10:02:15 2018 - [error][/usr/share/perl5/vendor_perl/MHA/ServerManager.pm, ln301] Got MySQL error when connecting 192.168.1.101(192.168.1.101:3306) :1045:Access denied for user 'root'@'zlm2' (using password: NO), but this is not a MySQL crash. Check MySQL server settings. 32 at /usr/share/perl5/vendor_perl/MHA/ServerManager.pm line 297. 33 Thu Aug 2 10:02:16 2018 - [error][/usr/share/perl5/vendor_perl/MHA/ServerManager.pm, ln301] Got MySQL error when connecting 192.168.1.102(192.168.1.102:3306) :1045:Access denied for user 'root'@'zlm2' (using password: NO), but this is not a MySQL crash. Check MySQL server settings. 34 at /usr/share/perl5/vendor_perl/MHA/ServerManager.pm line 297. 35 Thu Aug 2 10:02:16 2018 - [error][/usr/share/perl5/vendor_perl/MHA/ServerManager.pm, ln309] Got fatal error, stopping operations 36 Thu Aug 2 10:02:16 2018 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln424] Error happened on checking configurations. at /usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm line 326. 37 Thu Aug 2 10:02:16 2018 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln523] Error happened on monitoring servers. 38 Thu Aug 2 10:02:16 2018 - [info] Got exit code 1 (Not master dead). 39 40 MySQL Replication Health is NOT OK! 41 42 [root@zlm2 10:57:47 /etc/masterha] 43 #masterha_check_repl --conf=./app1.conf --global_conf=./masterha_default.conf //The "--global_conf" option is indispensable. 44 Thu Aug 2 10:57:58 2018 - [info] Reading default configuration from /etc/masterha/masterha_default.conf.. 45 Thu Aug 2 10:57:58 2018 - [info] Reading application default configuration from ./app1.conf.. 46 Thu Aug 2 10:57:58 2018 - [info] Reading server configuration from ./app1.conf.. 47 Thu Aug 2 10:57:58 2018 - [info] MHA::MasterMonitor version 0.56. 48 Thu Aug 2 10:57:59 2018 - [info] GTID failover mode = 1 49 Thu Aug 2 10:57:59 2018 - [info] Dead Servers: 50 Thu Aug 2 10:57:59 2018 - [info] Alive Servers: 51 Thu Aug 2 10:57:59 2018 - [info] 192.168.1.101(192.168.1.101:3306) 52 Thu Aug 2 10:57:59 2018 - [info] 192.168.1.102(192.168.1.102:3306) 53 Thu Aug 2 10:57:59 2018 - [info] Alive Slaves: 54 Thu Aug 2 10:57:59 2018 - [info] 192.168.1.102(192.168.1.102:3306) Version=5.7.21-log (oldest major version between slaves) log-bin:enabled 55 Thu Aug 2 10:57:59 2018 - [info] GTID ON 56 Thu Aug 2 10:57:59 2018 - [info] Replicating from 192.168.1.101(192.168.1.101:3306) 57 Thu Aug 2 10:57:59 2018 - [info] Primary candidate for the new Master (candidate_master is set) 58 Thu Aug 2 10:57:59 2018 - [info] Current Alive Master: 192.168.1.101(192.168.1.101:3306) 59 Thu Aug 2 10:57:59 2018 - [info] Checking slave configurations.. 60 Thu Aug 2 10:57:59 2018 - [info] read_only=1 is not set on slave 192.168.1.102(192.168.1.102:3306). 61 Thu Aug 2 10:57:59 2018 - [info] Checking replication filtering settings.. 62 Thu Aug 2 10:57:59 2018 - [info] binlog_do_db= , binlog_ignore_db= 63 Thu Aug 2 10:57:59 2018 - [info] Replication filtering check ok. 64 Thu Aug 2 10:57:59 2018 - [info] GTID (with auto-pos) is supported. Skipping all SSH and Node package checking. 65 Thu Aug 2 10:57:59 2018 - [info] Checking SSH publickey authentication settings on the current master.. 66 ssh_exchange_identification: Connection closed by remote host 67 Thu Aug 2 10:57:59 2018 - [warning] HealthCheck: SSH to 192.168.1.101 is NOT reachable. 68 Thu Aug 2 10:57:59 2018 - [info] 69 192.168.1.101(192.168.1.101:3306) (current master) 70 +--192.168.1.102(192.168.1.102:3306) 71 72 Thu Aug 2 10:57:59 2018 - [info] Checking replication health on 192.168.1.102.. 73 Thu Aug 2 10:57:59 2018 - [info] ok. 74 Thu Aug 2 10:57:59 2018 - [info] Checking master_ip_failover_script status: 75 Thu Aug 2 10:57:59 2018 - [info] /etc/masterha/master_ip_failover --command=status --ssh_user=root --orig_master_host=192.168.1.101 --orig_master_ip=192.168.1.101 --orig_master_port=3306 --orig_master_ssh_port=3306 76 Thu Aug 2 10:57:59 2018 - [info] OK. 77 Thu Aug 2 10:57:59 2018 - [warning] shutdown_script is not defined. 78 Thu Aug 2 10:57:59 2018 - [info] Got exit code 0 (Not master dead). 79 80 MySQL Replication Health is OK. 81 82 //Do these above checking operations on zlm3,too.
Start MasterHA-manager and check the status.
1 [root@zlm2 11:13:24 /etc/masterha] 2 #masterha_manager --conf=./app1.conf --global_conf=./masterha_default.conf & 3 [1] 5091 4 5 [root@zlm2 11:13:55 /etc/masterha] 6 #Thu Aug 2 11:13:56 2018 - [info] Reading default configuration from ./masterha_default.conf.. 7 Thu Aug 2 11:13:56 2018 - [info] Reading application default configuration from ./app1.conf.. 8 Thu Aug 2 11:13:56 2018 - [info] Reading server configuration from ./app1.conf.. 9 ssh_exchange_identification: Connection closed by remote host 10 ^C 11 12 [root@zlm2 11:14:09 /etc/masterha] 13 #masterha_check_status --conf=./app1.conf 14 app1 (pid:5091) is running(0:PING_OK), master:192.168.1.101 15 16 [root@zlm2 10:57:15 /etc/masterha] 17 #cd /var/log/masterha/app1 18 19 [root@zlm2 11:16:17 /var/log/masterha/app1] 20 #ls -l 21 total 8 22 -rw-r--r-- 1 root root 3821 Aug 2 11:13 app1.log 23 -rw-r--r-- 1 root root 35 Aug 2 11:16 app1.master_status.health 24 25 [root@zlm2 11:16:19 /var/log/masterha/app1] 26 #tail app1.log 27 +--192.168.1.102(192.168.1.102:3306) 28 29 Thu Aug 2 11:13:57 2018 - [info] Checking master_ip_failover_script status: 30 Thu Aug 2 11:13:57 2018 - [info] /etc/masterha/master_ip_failover --command=status --ssh_user=root --orig_master_host=192.168.1.101 --orig_master_ip=192.168.1.101 --orig_master_port=3306 --orig_master_ssh_port=3306 31 Thu Aug 2 11:13:57 2018 - [info] OK. 32 Thu Aug 2 11:13:57 2018 - [warning] shutdown_script is not defined. 33 Thu Aug 2 11:13:57 2018 - [info] Set master ping interval 1 seconds. 34 Thu Aug 2 11:13:57 2018 - [warning] secondary_check_script is not defined. It is highly recommended setting it to check master reachability from two or more routes. 35 Thu Aug 2 11:13:57 2018 - [info] Starting ping health check on 192.168.1.101(192.168.1.101:3306).. 36 Thu Aug 2 11:13:57 2018 - [info] Ping(SELECT) succeeded, waiting until MySQL doesn't respond.. 37 38 [root@zlm2 11:16:35 /var/log/masterha/app1] 39 #tail app1.master_status.health 40 5091 0:PING_OK master:192.168.1.101
更多精彩