溫馨提示×
您好，登錄后才能下訂單哦！
點(diǎn)擊 登錄注冊(cè) 即表示同意《億速云用戶服務(wù)條款》
您好，登錄后才能下訂單哦！
部署計(jì)劃
| mysql_master | 192.168.2.74 | centos6.9 | mysql5.5/mha-node |
| mysql_salve1 | 192.168.2.75 | centos6.9 | mysql5.5/mha-node |
| mysql_salve2 | 192.168.2.76 | centos6.9 | mysql5.5/mha-node/mha-man |
本次部署采用3臺(tái)服務(wù)器，mha-manager不單獨(dú)使用一臺(tái)服務(wù)器安裝，生產(chǎn)上可以單獨(dú)出來，本次使用采用centos6.9系統(tǒng)（使用 http://youprince.blog.51cto.com/9272426/1974967 優(yōu)化 ），mysql5.5（使用ansible安裝，本次不做介紹），3臺(tái)都參與競(jìng)爭(zhēng)，并使用VIP:192.168.2.199。
安裝提前
a) 配置好主機(jī)名
b) 設(shè)置host文件
####3臺(tái)主機(jī)分別執(zhí)行 cat >> /etc/hosts <<EFO 192.168.2.74 mysql_master 192.168.2.75 mysql_slave1 192.168.2.76 mysql_slave2 EFO
c) 3臺(tái)主機(jī)之間使用免密碼登陸認(rèn)證
ssh-kekgen -t rsa #一直回車就行 ssh-copy-id -i mysql_master #輸入yes之后輸入密碼 ssh-copy-id -i mysql_slave1 #輸入yes之后輸入密碼 ssh-copy-id -i mysql_slave2 #輸入yes之后輸入密碼
3臺(tái)主機(jī)安裝mysql并設(shè)置同步mysql安裝這邊就不做介紹了?，F(xiàn)在開始mysql同步設(shè)置在mysql_master上執(zhí)行 查看同步bin文件和pos信號(hào)
mysql> show master status; +------------------+----------+--------------+------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +------------------+----------+--------------+------------------+ | mysql-bin.000003 | 107 | | | +------------------+----------+--------------+------------------+ 1 row in set (0.00 sec) mysql> grant replication slave on *.* to 'repl'@'192.168.2.75' identified by 'admin123'; Query OK, 0 rows affected (0.00 sec) mysql> grant replication slave on *.* to 'repl'@'192.168.2.76' identified by 'admin123'; Query OK, 0 rows affected (0.00 sec)
在mysql_salve1和 mysql_slave2上配置同步
mysql> change master to master_host='192.168.2.74',master_port=55555,master_user='repl',master_password='admin123',master_log_file='mysql-bin.000003',master_log_pos=107; Query OK, 0 rows affected (0.00 sec) mysql> start salve; mysql> show slave status\G;
在mysql_master上安裝插件
mysql> install plugin rpl_semi_sync_master soname 'semisync_master.so'; Query OK, 0 rows affected (0.02 sec) mysql> install plugin rpl_semi_sync_slave soname 'semisync_slave.so'; Query OK, 0 rows affected (0.01 sec) mysql> set global rpl_semi_sync_master_enabled=on ; Query OK, 0 rows affected (0.00 sec)
在mysql_salve1和mysql_slave2上安裝插件
mysql> install plugin rpl_semi_sync_master soname 'semisync_master.so'; Query OK, 0 rows affected (0.01 sec) mysql> install plugin rpl_semi_sync_slave soname 'semisync_slave.so'; Query OK, 0 rows affected (0.00 sec) mysql> set global rpl_semi_sync_slave_enabled=on ; Query OK, 0 rows affected (0.00 sec) mysql> set global relay_log_purge=0; Query OK, 0 rows affected (0.00 sec)
4.開始安裝mha-node
3臺(tái)mysql都需要安裝 先安裝依賴 yum install perl-DBD-MySQL
[root@mysql_master ~]# rpm -ivh mha4mysql-node-0.54-0.el6.noarch.rpm Preparing... ########################################### [100%] 1:mha4mysql-node ########################################### [100%] [root@mysql_master ~]#
在需要參與選舉的mysql上新建賬號(hào)(我這邊3個(gè)都選舉所以3個(gè)都要執(zhí)行下面的.我不需要的只讀的庫)，mha賬號(hào)是mha-man用來管理數(shù)據(jù)庫的權(quán)限比較大生產(chǎn)的時(shí)候需要注意，repl是用來的同步的賬號(hào)
grant all privileges on *.* to 'mha'@'192.168.2.74' identified by 'admin123'; grant all privileges on *.* to 'mha'@'192.168.2.75' identified by 'admin123'; grant all privileges on *.* to 'mha'@'192.168.2.76' identified by 'admin123'; grant replication slave on *.* to 'repl'@'192.168.2.74' identified by 'admin123'; grant replication slave on *.* to 'repl'@'192.168.2.75' identified by 'admin123'; grant replication slave on *.* to 'repl'@'192.168.2.76' identified by 'admin123'; flush privileges;
執(zhí)行情況如下（只是列舉了其中一臺(tái)）
mysql> grant all privileges on *.* to 'mha'@'192.168.2.74' identified by 'admin123'; Query OK, 0 rows affected (0.00 sec) mysql> grant all privileges on *.* to 'mha'@'192.168.2.75' identified by 'admin123'; Query OK, 0 rows affected (0.00 sec) mysql> grant all privileges on *.* to 'mha'@'192.168.2.76' identified by 'admin123'; Query OK, 0 rows affected (0.00 sec) mysql> grant replication slave on *.* to 'repl'@'192.168.2.74' identified by 'admin123'; Query OK, 0 rows affected (0.00 sec) mysql> grant replication slave on *.* to 'repl'@'192.168.2.75' identified by 'admin123'; Query OK, 0 rows affected (0.00 sec) mysql> grant replication slave on *.* to 'repl'@'192.168.2.76' identified by 'admin123'; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec)
5. 開始安裝mha-manager 節(jié)點(diǎn)（可以單獨(dú)拿一臺(tái)主機(jī)安裝，我這里使用的是其中一個(gè)節(jié)點(diǎn)mysql_slave2）
安裝依賴
yum install -y perl-DBD-MySQL yum install -y perl-Config-Tiny yum install -y perl-Log-Dispatch yum install -y perl-Parallel-ForkManager yum install -y perl-Time-HiRes yum install -y perl-devel
安裝mha-manager
[root@mysql_slave2 ~]# rpm -ivh mha4mysql-manager-0.55-0.el6.noarch.rpm Preparing... ########################################### [100%] 1:mha4mysql-manager ########################################### [100%]
創(chuàng)建配置文件
mkdir -p /etc/mha/{conf,logs,work} #創(chuàng)建的mha-manager使用目錄 conf放配置文件
##### 創(chuàng)建app1.conf###文件
cat > /etc/mha/conf/app1.cnf <<EFO
[server default]
manager_workdir=/etc/mha/work
manager_log=/etc/mha/logs/manager.log
master_binlog_dir=/data/mysql/55555/logs/
user=mha
password=admin123
ssh_user=root
ping_interval=1
repl_user=repl
repl_password=admin123
[server1]
hostname=mysql_master
port = 55555
candidate_master=1
[server2]
hostname=mysql_slave1
port=55555
candidate_master=1
[server3]
hostname=mysql_slave2
port=55555
candidate_master=1
EFO檢測(cè)ssh連接
[root@mysql_slave2 conf]# masterha_check_ssh --conf=/etc/mha/conf/app1.cnf Sat Nov 4 00:49:15 2017 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping. Sat Nov 4 00:49:15 2017 - [info] Reading application default configurations from /etc/mha/conf/app1.cnf.. Sat Nov 4 00:49:15 2017 - [info] Reading server configurations from /etc/mha/conf/app1.cnf.. Sat Nov 4 00:49:15 2017 - [info] Starting SSH connection tests.. Sat Nov 4 00:49:16 2017 - [debug] Sat Nov 4 00:49:15 2017 - [debug] Connecting via SSH from root@mysql_master(192.168.2.74:22) to root@mysql_slave1(192.168.2.75:22).. Sat Nov 4 00:49:15 2017 - [debug] ok. Sat Nov 4 00:49:15 2017 - [debug] Connecting via SSH from root@mysql_master(192.168.2.74:22) to root@mysql_slave2(192.168.2.76:22).. Sat Nov 4 00:49:16 2017 - [debug] ok. Sat Nov 4 00:49:16 2017 - [debug] Sat Nov 4 00:49:16 2017 - [debug] Connecting via SSH from root@mysql_slave1(192.168.2.75:22) to root@mysql_master(192.168.2.74:22).. Sat Nov 4 00:49:16 2017 - [debug] ok. Sat Nov 4 00:49:16 2017 - [debug] Connecting via SSH from root@mysql_slave1(192.168.2.75:22) to root@mysql_slave2(192.168.2.76:22).. Sat Nov 4 00:49:16 2017 - [debug] ok. Sat Nov 4 00:49:17 2017 - [debug] Sat Nov 4 00:49:16 2017 - [debug] Connecting via SSH from root@mysql_slave2(192.168.2.76:22) to root@mysql_master(192.168.2.74:22).. Sat Nov 4 00:49:16 2017 - [debug] ok. Sat Nov 4 00:49:16 2017 - [debug] Connecting via SSH from root@mysql_slave2(192.168.2.76:22) to root@mysql_slave1(192.168.2.75:22).. Sat Nov 4 00:49:17 2017 - [debug] ok. Sat Nov 4 00:49:17 2017 - [info] [root@mysql_slave2 conf]#
這說明開始的ssh免密碼配置ok
檢測(cè)mysql同步配置
[root@mysql_slave2 conf]# masterha_check_repl --conf=/etc/mha/conf/app1.cnf Sat Nov 4 00:57:03 2017 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping. Sat Nov 4 00:57:03 2017 - [info] Reading application default configurations from /etc/mha/conf/app1.cnf.. Sat Nov 4 00:57:03 2017 - [info] Reading server configurations from /etc/mha/conf/app1.cnf.. Sat Nov 4 00:57:03 2017 - [info] MHA::MasterMonitor version 0.55. Sat Nov 4 00:57:03 2017 - [info] Dead Servers: Sat Nov 4 00:57:03 2017 - [info] Alive Servers: Sat Nov 4 00:57:03 2017 - [info] mysql_master(192.168.2.74:55555) Sat Nov 4 00:57:03 2017 - [info] mysql_slave1(192.168.2.75:55555) Sat Nov 4 00:57:03 2017 - [info] mysql_slave2(192.168.2.76:55555) Sat Nov 4 00:57:03 2017 - [info] Alive Slaves: Sat Nov 4 00:57:03 2017 - [info] mysql_slave1(192.168.2.75:55555) Version=5.5.57-log (oldest major version between slaves) log-bin:enabled Sat Nov 4 00:57:03 2017 - [info] Replicating from 192.168.2.74(192.168.2.74:55555) Sat Nov 4 00:57:03 2017 - [info] Primary candidate for the new Master (candidate_master is set) Sat Nov 4 00:57:03 2017 - [info] mysql_slave2(192.168.2.76:55555) Version=5.5.57-log (oldest major version between slaves) log-bin:enabled Sat Nov 4 00:57:03 2017 - [info] Replicating from 192.168.2.74(192.168.2.74:55555) Sat Nov 4 00:57:03 2017 - [info] Primary candidate for the new Master (candidate_master is set) Sat Nov 4 00:57:03 2017 - [info] Current Alive Master: mysql_master(192.168.2.74:55555) Sat Nov 4 00:57:03 2017 - [info] Checking slave configurations.. Sat Nov 4 00:57:03 2017 - [info] read_only=1 is not set on slave mysql_slave1(192.168.2.75:55555). Sat Nov 4 00:57:03 2017 - [info] read_only=1 is not set on slave mysql_slave2(192.168.2.76:55555). Sat Nov 4 00:57:03 2017 - [info] Checking replication filtering settings.. Sat Nov 4 00:57:03 2017 - [info] binlog_do_db= , binlog_ignore_db= Sat Nov 4 00:57:03 2017 - [info] Replication filtering check ok. Sat Nov 4 00:57:03 2017 - [info] Starting SSH connection tests.. Sat Nov 4 00:57:04 2017 - [info] All SSH connection tests passed successfully. Sat Nov 4 00:57:04 2017 - [info] Checking MHA Node version.. Sat Nov 4 00:57:05 2017 - [info] Version check ok. Sat Nov 4 00:57:05 2017 - [info] Checking SSH publickey authentication settings on the current master.. Sat Nov 4 00:57:05 2017 - [info] HealthCheck: SSH to mysql_master is reachable. Sat Nov 4 00:57:05 2017 - [info] Master MHA Node version is 0.54. Sat Nov 4 00:57:05 2017 - [info] Checking recovery script configurations on the current master.. Sat Nov 4 00:57:05 2017 - [info] Executing command: save_binary_logs --command=test --start_pos=4 --binlog_dir=/data/mysql/55555/logs/ --output_file=/var/tmp/save_binary_logs_test --manager_version=0.55 --start_file=mysql-bin.000006 Sat Nov 4 00:57:05 2017 - [info] Connecting to root@mysql_master(mysql_master).. Creating /var/tmp if not exists.. ok. Checking output directory is accessible or not.. ok. Binlog found at /data/mysql/55555/logs/, up to mysql-bin.000006 Sat Nov 4 00:57:05 2017 - [info] Master setting check done. Sat Nov 4 00:57:05 2017 - [info] Checking SSH publickey authentication and checking recovery script configurations on all alive slave servers.. Sat Nov 4 00:57:05 2017 - [info] Executing command : apply_diff_relay_logs --command=test --slave_user='mha' --slave_host=mysql_slave1 --slave_ip=192.168.2.75 --slave_port=55555 --workdir=/var/tmp --target_version=5.5.57-log --manager_version=0.55 --relay_log_info=/data/mysql/55555/relay-log.info --relay_dir=/data/mysql/55555/ --slave_pass=xxx Sat Nov 4 00:57:05 2017 - [info] Connecting to root@192.168.2.75(mysql_slave1:22).. Checking slave recovery environment settings.. Opening /data/mysql/55555/relay-log.info ... ok. Relay log found at /data/mysql/55555, up to 55555-relay-bin.000002 Temporary relay log file is /data/mysql/55555/55555-relay-bin.000002 Testing mysql connection and privileges.. done. Testing mysqlbinlog output.. done. Cleaning up test file(s).. done. Sat Nov 4 00:57:05 2017 - [info] Executing command : apply_diff_relay_logs --command=test --slave_user='mha' --slave_host=mysql_slave2 --slave_ip=192.168.2.76 --slave_port=55555 --workdir=/var/tmp --target_version=5.5.57-log --manager_version=0.55 --relay_log_info=/data/mysql/55555/relay-log.info --relay_dir=/data/mysql/55555/ --slave_pass=xxx Sat Nov 4 00:57:05 2017 - [info] Connecting to root@192.168.2.76(mysql_slave2:22).. Checking slave recovery environment settings.. Opening /data/mysql/55555/relay-log.info ... ok. Relay log found at /data/mysql/55555, up to 55555-relay-bin.000002 Temporary relay log file is /data/mysql/55555/55555-relay-bin.000002 Testing mysql connection and privileges.. done. Testing mysqlbinlog output.. done. Cleaning up test file(s).. done. Sat Nov 4 00:57:05 2017 - [info] Slaves settings check done. Sat Nov 4 00:57:05 2017 - [info] mysql_master (current master) +--mysql_slave1 +--mysql_slave2 Sat Nov 4 00:57:05 2017 - [info] Checking replication health on mysql_slave1.. Sat Nov 4 00:57:05 2017 - [info] ok. Sat Nov 4 00:57:05 2017 - [info] Checking replication health on mysql_slave2.. Sat Nov 4 00:57:05 2017 - [info] ok. Sat Nov 4 00:57:05 2017 - [warning] master_ip_failover_script is not defined. Sat Nov 4 00:57:05 2017 - [warning] shutdown_script is not defined. Sat Nov 4 00:57:05 2017 - [info] Got exit code 0 (Not master dead). MySQL Replication Health is OK. [root@mysql_slave2 conf]#
滿足上面的條件下，現(xiàn)在就開始使用開啟manager了
[root@mysql_slave2 conf]# masterha_manager --conf=/etc/mha/conf/app1.cnf --remove_dead_master_conf --ignore_last_failover ## 前臺(tái)啟動(dòng) [root@mysql_slave2 ~]# masterha_check_status --conf=/etc/mha/conf/app1.cnf app1 (pid:2575) is running(0:PING_OK), master:mysql_master #說明啟動(dòng)OK [root@mysql_slave2 ~]#
6. 配置VIP
在/etc/mha/conf/app1.cnf中 server default中加入一行配置 master_ip_failover_script=/etc/mha/conf/master_ip_failover cat /etc/mha/conf/master_ip_failover #!/usr/bin/env perl # Copyright (C) 2011 DeNA Co.,Ltd. # # This program is free software; you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation; either version 2 of the License, or # (at your option) any later version. # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this program; if not, write to the Free Software # Foundation, Inc., # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA ## Note: This is a sample script and is not complete. Modify the script based on your environment. use strict; use warnings FATAL => 'all'; use Getopt::Long; use MHA::DBHelper; my ( $command, $ssh_user, $orig_master_host, $orig_master_ip, $orig_master_port, $new_master_host, $new_master_ip, $new_master_port, $new_master_user, $new_master_password ); my $vip = '192.168.2.199'; my $gateway = '255.255.248.0'; my $ssh_start_vip = "sudo ifconfig eth0:1 $vip;sudo arping -c 3 -I eth0 -s $vip $gateway"; my $ssh_stop_vip = 'sudo ifconfig eth0:1 down'; GetOptions( 'command=s' => \$command, 'ssh_user=s' => \$ssh_user, 'orig_master_host=s' => \$orig_master_host, 'orig_master_ip=s' => \$orig_master_ip, 'orig_master_port=i' => \$orig_master_port, 'new_master_host=s' => \$new_master_host, 'new_master_ip=s' => \$new_master_ip, 'new_master_port=i' => \$new_master_port, 'new_master_user=s' => \$new_master_user, 'new_master_password=s' => \$new_master_password, ); exit &main(); sub main { if ( $command eq "stop" || $command eq "stopssh" ) { # $orig_master_host, $orig_master_ip, $orig_master_port are passed. # If you manage master ip address at global catalog database, # invalidate orig_master_ip here. my $exit_code = 1; eval { &stop_vip(); # updating global catalog, etc $exit_code = 0; }; if ($@) { warn "Got Error: $@\n"; exit $exit_code; } exit $exit_code; } elsif ( $command eq "start" ) { # all arguments are passed. # If you manage master ip address at global catalog database, # activate new_master_ip here. # You can also grant write access (create user, set read_only=0, etc) here. my $exit_code = 10; eval { &start_vip(); $exit_code = 0; }; if ($@) { warn $@; # If you want to continue failover, exit 10. exit $exit_code; } exit $exit_code; } elsif ( $command eq "status" ) { print "Checking the status of the script: ssh -t $ssh_user\@$orig_master_host \"$ssh_start_vip\"\n"; `ssh -t $ssh_user\@$orig_master_host \"$ssh_start_vip\"`; exit 0; } else { &usage(); exit 1; } } sub usage { print "Usage: master_ip_failover --command=start|stop|stopssh|status --orig_master_host=host --orig_master_ip=ip --orig_master_port=port --new_master_host=host --new_master_ip=ip --new_master_port=port\n"; } sub start_vip() { print "Checking the start of the script: ssh -t $ssh_user\@$new_master_host \"$ssh_start_vip\"\n"; `ssh -t $ssh_user\@$new_master_host \"$ssh_start_vip\"`; } sub stop_vip() { print "Checking the stop/stopssh of the script: ssh -t $ssh_user\@$orig_master_host \"$ssh_stop_vip\"\n"; `ssh -t $ssh_user\@$orig_master_host \"$ssh_stop_vip\"`; }
重啟managrer
masterha_stop --conf=/etc/mha/conf/app1.cnf masterha_manager --conf=/etc/mha/conf/app1.cnf --remove_dead_master_conf --ignore_last_failover
查看 mysql_master 看到vip已經(jīng)在master上了
[root@mysql_master ~]# ifconfig eth0 Link encap:Ethernet HWaddr 00:0C:29:74:4D:FB inet addr:192.168.2.74 Bcast:192.168.7.255 Mask:255.255.248.0 UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:108407 errors:0 dropped:0 overruns:0 frame:0 TX packets:7780 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:18041186 (17.2 MiB) TX bytes:789173 (770.6 KiB) eth0:1 Link encap:Ethernet HWaddr 00:0C:29:74:4D:FB inet addr:192.168.2.199 Bcast:192.168.2.255 Mask:255.255.255.0 UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 eth2 Link encap:Ethernet HWaddr 00:0C:29:74:4D:05 inet addr:172.16.16.1 Bcast:172.16.16.15 Mask:255.255.255.240 UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:96363 errors:0 dropped:0 overruns:0 frame:0 TX packets:220 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:6307546 (6.0 MiB) TX bytes:9240 (9.0 KiB) lo Link encap:Local Loopback inet addr:127.0.0.1 Mask:255.0.0.0 UP LOOPBACK RUNNING MTU:65536 Metric:1 RX packets:84 errors:0 dropped:0 overruns:0 frame:0 TX packets:84 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:0 RX bytes:14900 (14.5 KiB) TX bytes:14900 (14.5 KiB) [root@mysql_master ~]#
7.測(cè)試
注：上面我的mha-manager是使用的screen啟動(dòng)的。
現(xiàn)在將master停掉。觀察 mha-maager日志/etc/mha/logs/manager.log、
----- Failover Report ----- app1: MySQL Master failover mysql_master to mysql_slave1 succeeded Master mysql_master is down! Check MHA Manager logs at mysql_slave2:/etc/mha/logs/manager.log for details. Started automated(non-interactive) failover. Invalidated master IP address on mysql_master. The latest slave mysql_slave1(192.168.2.75:55555) has all relay logs for recovery. Selected mysql_slave1 as a new master. mysql_slave1: OK: Applying all logs succeeded. mysql_slave1: OK: Activated master IP address. mysql_slave2: This host has the latest relay log events. Generating relay diff files from the latest slave succeeded. mysql_slave2: OK: Applying all logs succeeded. Slave started, replicating from mysql_slave1. mysql_slave1: Resetting slave info succeeded. Master failover to mysql_slave1(192.168.2.75:55555) completed successfully.
從日志中看到已經(jīng)遷移到了 192.168.2.75（mysql_slave1）上.
[root@mysql_slave1 ~]# ifconfig eth0 Link encap:Ethernet HWaddr 00:0C:29:FB:B5:98 inet addr:192.168.2.75 Bcast:192.168.7.255 Mask:255.255.248.0 UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:110418 errors:0 dropped:0 overruns:0 frame:0 TX packets:6705 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:18166949 (17.3 MiB) TX bytes:709681 (693.0 KiB) eth0:1 Link encap:Ethernet HWaddr 00:0C:29:FB:B5:98 inet addr:192.168.2.199 Bcast:192.168.2.255 Mask:255.255.255.0 UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 eth2 Link encap:Ethernet HWaddr 00:0C:29:FB:B5:A2 inet addr:172.16.16.2 Bcast:172.16.16.15 Mask:255.255.255.240 UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:100427 errors:0 dropped:0 overruns:0 frame:0 TX packets:230 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:6577954 (6.2 MiB) TX bytes:9660 (9.4 KiB) lo Link encap:Local Loopback inet addr:127.0.0.1 Mask:255.0.0.0 UP LOOPBACK RUNNING MTU:65536 Metric:1 RX packets:201 errors:0 dropped:0 overruns:0 frame:0 TX packets:201 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:0 RX bytes:17985 (17.5 KiB) TX bytes:17985 (17.5 KiB) [root@mysql_slave1 ~]#
VIP已經(jīng)飄逸過來了。此時(shí)在查看下manager的狀態(tài)
[root@mysql_slave2 logs]# masterha_check_status --conf=/etc/mha/conf/app1.cnf app1 is stopped(2:NOT_RUNNING). [root@mysql_slave2 logs]#
果然看到manager已經(jīng)停掉了，這個(gè)是screen啟動(dòng)的一個(gè)bug,解決這樣的問題官方是建議使用daemontools這里就不詳細(xì)介紹了。
免責(zé)聲明：本站發(fā)布的內(nèi)容（圖片、視頻和文字）以原創(chuàng)、轉(zhuǎn)載和分享為主，文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如果涉及侵權(quán)請(qǐng)聯(lián)系站長郵箱：is@yisu.com進(jìn)行舉報(bào)，并提供相關(guān)證據(jù)，一經(jīng)查實(shí)，將立刻刪除涉嫌侵權(quán)內(nèi)容。
億速云公眾號(hào)
手機(jī)網(wǎng)站二維碼