MHA安装配置
1. 前言
MHA可以在较短的时间内实现自己主动故障检測和故障转移，通常在10-30秒以内;在复制框架中，MHA可以非常好地解决复制过程中的数据一致性问题，因为不须要在现有的replication中加入额外的server，仅须要一个manager节点，而一个Manager能管理多套复制。所以能大大地节约server的数量;另外，安装简单，无性能损耗，以及不须要改动现有的复制部署也是它的优势之处。
MHA还提供在线主库切换的功能，可以安全地切换当前执行的主库到一个新的主库中(通过将从库提升为主库),大概0.5-2秒内就可以完毕。
MHA提供了上述功能。使得其在适用于对高可用性。数据完整性要求高的场合。还有要求差点儿non-stop的主库维护。
这次主要是解说MHA的高速部署和简单配置。兴许补充高级特性以及相关架构吧。
2. 环境介绍
环境有限。我使用的是vmware虚拟机，搭建三台server，1主2从结构。
当中manager管理节点放在当中一台从库中。
1）server1（node节点）
OS：CentOS 6.4 X64
IPADDR：172.16.21.12（eth0）；192.168.8.6（eth1）
HOSTNAME：mysql-mha01
DB：Mysql 5.5.43-log MySQL Community Server (GPL)
SOFTWARE：mha4mysql-node-0.56-0.el6.noarch.rpm
防火墙关闭；selinux关闭。
2）server2（node节点）
OS：CentOS 6.4 X64
IPADDR：172.16.21.13（eth2）。192.168.8.7（eth3）
HOSTNAME：mysql-mha02
DB：Mysql 5.5.43-log MySQL Community Server (GPL)
SOFTWARE：mha4mysql-node-0.56-0.el6.noarch.rpm
防火墙关闭。selinux关闭；
3）server3（node节点。manager节点）
OS：CentOS 6.4 X64
IPADDR：172.16.21.15（eth2）；192.168.8.8（eth3）
HOSTNAME：mysql-mha01
DB：Mysql 5.5.43-log MySQL Community Server (GPL)
SOFTWARE：mha4mysql-node-0.56-0.el6.noarch.rpm。mha4mysql-manager-0.56-0.el6.noarch.rpm
防火墙关闭；selinux关闭；
3. 软件安装
3.1 Node节点安装
在3个节点上安装node软件包。首先安装依赖包
yum install perl-DBD-MySQL
安装node软件包
rpm -ivh mha4mysql-node-0.56-0.el6.noarch.rpm
3.2 Manager节点安装
安装依赖包
yum install perl-Params-Validate perl-LWP-Simple perl-Config-Tiny perl-Time-HiRes perl-Log-Dispatch perl-Parallel-ForkManager
我当时配置的163的yum源没有perl-Log-Dispatch和perl-Parallel-ForkManager，所以就自己下载的rpm包安装，大家能够到http://pkgs.repoforge.org/ 下载自己须要的包。
rpm -ivh perl-Log-Dispatch-2.26-1.el6.rf.noarch.rpm perl-Parallel-ForkManager-0.7.5-2.2.el6.rf.noarch.rpm
安装manager软件包
rpm -ivh mha4mysql-manager-0.56-0.el6.noarch.rpm
4. MHA配置
4.1 Mysql复制配置
此处就不具体说明了，大家能够參考我曾经的文章。http://blog.csdn.net/wjf870128/article/details/45170089 和 http://blog.csdn.net/wjf870128/article/details/45149573。
我搭建的是半同步复制的一主双从结构。当中mysql-mha02为master节点，其它为slave节点。
复制账户passwordrepl/slavepass。（PS我们公司环境是5.5的所以这里的虚拟机也是用到的mysql5.5。如今MHA支持5.6的GTID复制。因此大家能够考虑使用5.6的gtid搭建。能够方便master因为崩溃恢复后又一次增加集群管理）
4.2 MHA配置
在管理节点mysql-mha02中建立配置文件
mkdir -p /etc/MHA touch /etc/MHA/MHAmanager.conf查看manager配置文件
[server default] # mysql user and password user=root password=123456 ssh_user=root # mysql replication user and password repl_user=repl repl_password=slavepass # working directory on the manager manager_workdir=/var/log/masterha/manager # working directory on MySQL servers remote_workdir=/var/log/masterha/node #Master Binlog dir master_binlog_dir=/var/lib/mysql/logs #secondary route to detect the reachable of master secondary_check_script= masterha_secondary_check -s mysql-mha03 --user=root --master_host=mysql-mha02 --master_ip=172.16.21.13 --master_port=3306 #define the manager log manager_log=/var/log/masterha/manager.log [server1] hostname=mysql-mha01 [server2] hostname=mysql-mha02 [server3] hostname=mysql-mha03
MHA其中具体參数大家能够參考 https://code.google.com/p/mysql-master-ha/wiki/Parameters。
master_binlog_dir标志着master节点binlog的存放位置。假设大家没有使用默认的/var/lib/mysql的话须要单独制定。MHA在故障切换的时候假设master节点能够ssh联通的话会自己主动到该文件夹抓取日志文件来防止slave节点日志不完整。
workdir是manager节点和node节点的工作文件夹。在MHA管理启动时候。假设文件夹不存在，会通过ssh来进行创建。请保证ssh用户的权限。
4.3 主机信任
MHA环境须要保证manager和node之间的信任。
ssh-keygen -t rsa ssh-copy-id -i /root/.ssh/id_rsa.pub root@192.168.8.6 ssh-copy-id -i /root/.ssh/id_rsa.pub root@192.168.8.7 ssh-copy-id -i /root/.ssh/id_rsa.pub root@192.168.8.8
验证机器信任
[root@mysql-mha03 ~]# masterha_check_ssh --conf=/etc/MHA/MHAmanager.conf Thu Jul 23 14:33:26 2015 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping. Thu Jul 23 14:33:26 2015 - [info] Reading application default configuration from /etc/MHA/MHAmanager.conf.. Thu Jul 23 14:33:26 2015 - [info] Reading server configuration from /etc/MHA/MHAmanager.conf.. Thu Jul 23 14:33:26 2015 - [info] Starting SSH connection tests.. Thu Jul 23 14:33:26 2015 - [debug] Thu Jul 23 14:33:26 2015 - [debug] Connecting via SSH from root@mysql-mha01(192.168.8.6:22) to root@mysql-mha02(192.168.8.7:22).. Thu Jul 23 14:33:26 2015 - [debug] ok. Thu Jul 23 14:33:26 2015 - [debug] Connecting via SSH from root@mysql-mha01(192.168.8.6:22) to root@mysql-mha03(192.168.8.8:22).. Thu Jul 23 14:33:26 2015 - [debug] ok. Thu Jul 23 14:33:27 2015 - [debug] Thu Jul 23 14:33:26 2015 - [debug] Connecting via SSH from root@mysql-mha02(192.168.8.7:22) to root@mysql-mha01(192.168.8.6:22).. Thu Jul 23 14:33:26 2015 - [debug] ok. Thu Jul 23 14:33:26 2015 - [debug] Connecting via SSH from root@mysql-mha02(192.168.8.7:22) to root@mysql-mha03(192.168.8.8:22).. Thu Jul 23 14:33:27 2015 - [debug] ok. Thu Jul 23 14:33:27 2015 - [debug] Thu Jul 23 14:33:27 2015 - [debug] Connecting via SSH from root@mysql-mha03(192.168.8.8:22) to root@mysql-mha01(192.168.8.6:22).. Thu Jul 23 14:33:27 2015 - [debug] ok. Thu Jul 23 14:33:27 2015 - [debug] Connecting via SSH from root@mysql-mha03(192.168.8.8:22) to root@mysql-mha02(192.168.8.7:22).. Thu Jul 23 14:33:27 2015 - [debug] ok. Thu Jul 23 14:33:27 2015 - [info] All SSH connection tests passed successfully.
4.4 开启MHA
验证复制环境
[root@mysql-mha03 ~]# masterha_check_repl --conf=/etc/MHA/MHAmanager.conf
Thu Jul 23 14:40:27 2015 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping.
Thu Jul 23 14:40:27 2015 - [info] Reading application default configuration from /etc/MHA/MHAmanager.conf..
Thu Jul 23 14:40:27 2015 - [info] Reading server configuration from /etc/MHA/MHAmanager.conf..
Thu Jul 23 14:40:27 2015 - [info] MHA::MasterMonitor version 0.56.
Thu Jul 23 14:40:28 2015 - [info] GTID failover mode = 0
Thu Jul 23 14:40:28 2015 - [info] Dead Servers:
Thu Jul 23 14:40:28 2015 - [info] Alive Servers:
Thu Jul 23 14:40:28 2015 - [info] mysql-mha01(192.168.8.6:3306)
Thu Jul 23 14:40:28 2015 - [info] mysql-mha02(192.168.8.7:3306)
Thu Jul 23 14:40:28 2015 - [info] mysql-mha03(192.168.8.8:3306)
Thu Jul 23 14:40:28 2015 - [info] Alive Slaves:
Thu Jul 23 14:40:28 2015 - [info] mysql-mha01(192.168.8.6:3306) Version=5.5.43-log (oldest major version between slaves) log-bin:enabled
Thu Jul 23 14:40:28 2015 - [info] Replicating from 192.168.8.7(192.168.8.7:3306)
Thu Jul 23 14:40:28 2015 - [info] mysql-mha03(192.168.8.8:3306) Version=5.5.43-log (oldest major version between slaves) log-bin:enabled
Thu Jul 23 14:40:28 2015 - [info] Replicating from 192.168.8.7(192.168.8.7:3306)
Thu Jul 23 14:40:28 2015 - [info] Current Alive Master: mysql-mha02(192.168.8.7:3306)
Thu Jul 23 14:40:28 2015 - [info] Checking slave configurations..
Thu Jul 23 14:40:28 2015 - [info] read_only=1 is not set on slave mysql-mha01(192.168.8.6:3306).
Thu Jul 23 14:40:28 2015 - [info] read_only=1 is not set on slave mysql-mha03(192.168.8.8:3306).
Thu Jul 23 14:40:28 2015 - [info] Checking replication filtering settings..
Thu Jul 23 14:40:28 2015 - [info] binlog_do_db= , binlog_ignore_db=
Thu Jul 23 14:40:28 2015 - [info] Replication filtering check ok.
Thu Jul 23 14:40:28 2015 - [info] GTID (with auto-pos) is not supported
Thu Jul 23 14:40:28 2015 - [info] Starting SSH connection tests..
Thu Jul 23 14:40:29 2015 - [info] All SSH connection tests passed successfully.
Thu Jul 23 14:40:29 2015 - [info] Checking MHA Node version..
Thu Jul 23 14:40:29 2015 - [info] Version check ok.
Thu Jul 23 14:40:29 2015 - [info] Checking SSH publickey authentication settings on the current master..
Thu Jul 23 14:40:30 2015 - [info] HealthCheck: SSH to mysql-mha02 is reachable.
Thu Jul 23 14:40:30 2015 - [info] Master MHA Node version is 0.56.
Thu Jul 23 14:40:30 2015 - [info] Checking recovery script configurations on mysql-mha02(192.168.8.7:3306)..
Thu Jul 23 14:40:30 2015 - [info] Executing command: save_binary_logs --command=test --start_pos=4 --binlog_dir=/var/lib/mysql/logs --output_file=/var/log/masterha/node/save_binary_logs_test --manager_version=0.56 --start_file=mysql-bin.000013
Thu Jul 23 14:40:30 2015 - [info] Connecting to root@192.168.8.7(mysql-mha02:22)..
Creating /var/log/masterha/node if not exists.. ok.
Checking output directory is accessible or not..
ok.
Binlog found at /var/lib/mysql/logs, up to mysql-bin.000013
Thu Jul 23 14:40:30 2015 - [info] Binlog setting check done.
Thu Jul 23 14:40:30 2015 - [info] Checking SSH publickey authentication and checking recovery script configurations on all alive slave servers..
Thu Jul 23 14:40:30 2015 - [info] Executing command : apply_diff_relay_logs --command=test --slave_user='root' --slave_host=mysql-mha01 --slave_ip=192.168.8.6 --slave_port=3306 --workdir=/var/log/masterha/node --target_version=5.5.43-log --manager_version=0.56 --relay_log_info=/var/lib/mysql/relay-log.info --relay_dir=/var/lib/mysql/ --slave_pass=xxx
Thu Jul 23 14:40:30 2015 - [info] Connecting to root@192.168.8.6(mysql-mha01:22)..
Checking slave recovery environment settings..
Opening /var/lib/mysql/relay-log.info ... ok.
Relay log found at /var/lib/mysql, up to mysql-mha01-relay-bin.000005
Temporary relay log file is /var/lib/mysql/mysql-mha01-relay-bin.000005
Testing mysql connection and privileges.. done.
Testing mysqlbinlog output.. done.
Cleaning up test file(s).. done.
Thu Jul 23 14:40:30 2015 - [info] Executing command : apply_diff_relay_logs --command=test --slave_user='root' --slave_host=mysql-mha03 --slave_ip=192.168.8.8 --slave_port=3306 --workdir=/var/log/masterha/node --target_version=5.5.43-log --manager_version=0.56 --relay_log_info=/var/lib/mysql/relay-log.info --relay_dir=/var/lib/mysql/ --slave_pass=xxx
Thu Jul 23 14:40:30 2015 - [info] Connecting to root@192.168.8.8(mysql-mha03:22)..
Checking slave recovery environment settings..
Opening /var/lib/mysql/relay-log.info ... ok.
Relay log found at /var/lib/mysql, up to mysql-mha03-relay-bin.000005
Temporary relay log file is /var/lib/mysql/mysql-mha03-relay-bin.000005
Testing mysql connection and privileges.. done.
Testing mysqlbinlog output.. done.
Cleaning up test file(s).. done.
Thu Jul 23 14:40:30 2015 - [info] Slaves settings check done.
Thu Jul 23 14:40:30 2015 - [info]
mysql-mha02(192.168.8.7:3306) (current master)
+--mysql-mha01(192.168.8.6:3306)
+--mysql-mha03(192.168.8.8:3306)
Thu Jul 23 14:40:30 2015 - [info] Checking replication health on mysql-mha01..
Thu Jul 23 14:40:30 2015 - [info] ok.
Thu Jul 23 14:40:30 2015 - [info] Checking replication health on mysql-mha03..
Thu Jul 23 14:40:30 2015 - [info] ok.
Thu Jul 23 14:40:30 2015 - [warning] master_ip_failover_script is not defined.
Thu Jul 23 14:40:30 2015 - [warning] shutdown_script is not defined.
Thu Jul 23 14:40:30 2015 - [info] Got exit code 0 (Not master dead).
MySQL Replication Health is OK.启动mha manager
[root@mysql-mha03 ~]# nohup masterha_manager --conf=/etc/MHA/MHAmanager.conf & [1] 5552
查看启动日志
Thu Jul 23 14:49:01 2015 - [info] MHA::MasterMonitor version 0.56.
Thu Jul 23 14:49:01 2015 - [info] GTID failover mode = 0
Thu Jul 23 14:49:01 2015 - [info] Dead Servers:
Thu Jul 23 14:49:01 2015 - [info] Alive Servers:
Thu Jul 23 14:49:01 2015 - [info] mysql-mha01(192.168.8.6:3306)
Thu Jul 23 14:49:01 2015 - [info] mysql-mha02(192.168.8.7:3306)
Thu Jul 23 14:49:01 2015 - [info] mysql-mha03(192.168.8.8:3306)
Thu Jul 23 14:49:01 2015 - [info] Alive Slaves:
Thu Jul 23 14:49:01 2015 - [info] mysql-mha01(192.168.8.6:3306) Version=5.5.43-log (oldest major version between slaves) log-bin:enabled
Thu Jul 23 14:49:01 2015 - [info] Replicating from 192.168.8.7(192.168.8.7:3306)
Thu Jul 23 14:49:01 2015 - [info] mysql-mha03(192.168.8.8:3306) Version=5.5.43-log (oldest major version between slaves) log-bin:enabled
Thu Jul 23 14:49:01 2015 - [info] Replicating from 192.168.8.7(192.168.8.7:3306)
Thu Jul 23 14:49:01 2015 - [info] Current Alive Master: mysql-mha02(192.168.8.7:3306)
Thu Jul 23 14:49:01 2015 - [info] Checking slave configurations..
Thu Jul 23 14:49:01 2015 - [info] read_only=1 is not set on slave mysql-mha01(192.168.8.6:3306).
Thu Jul 23 14:49:01 2015 - [info] read_only=1 is not set on slave mysql-mha03(192.168.8.8:3306).
Thu Jul 23 14:49:01 2015 - [info] Checking replication filtering settings..
Thu Jul 23 14:49:01 2015 - [info] binlog_do_db= , binlog_ignore_db=
Thu Jul 23 14:49:01 2015 - [info] Replication filtering check ok.
Thu Jul 23 14:49:01 2015 - [info] GTID (with auto-pos) is not supported
Thu Jul 23 14:49:01 2015 - [info] Starting SSH connection tests..
Thu Jul 23 14:49:02 2015 - [info] All SSH connection tests passed successfully.
Thu Jul 23 14:49:02 2015 - [info] Checking MHA Node version..
Thu Jul 23 14:49:03 2015 - [info] Version check ok.
Thu Jul 23 14:49:03 2015 - [info] Checking SSH publickey authentication settings on the current master..
Thu Jul 23 14:49:03 2015 - [info] HealthCheck: SSH to mysql-mha02 is reachable.
Thu Jul 23 14:49:03 2015 - [info] Master MHA Node version is 0.56.
Thu Jul 23 14:49:03 2015 - [info] Checking recovery script configurations on mysql-mha02(192.168.8.7:3306)..
Thu Jul 23 14:49:03 2015 - [info] Executing command: save_binary_logs --command=test --start_pos=4 --binlog_dir=/var/lib/mysql/logs --output_file=/var/log/masterha/node/save_binary_logs_test --manager_version=0.56 --start_file=mysql-bin.000013
Thu Jul 23 14:49:03 2015 - [info] Connecting to root@192.168.8.7(mysql-mha02:22)..
Creating /var/log/masterha/node if not exists.. ok.
Checking output directory is accessible or not..
ok.
Binlog found at /var/lib/mysql/logs, up to mysql-bin.000013
Thu Jul 23 14:49:03 2015 - [info] Binlog setting check done.
Thu Jul 23 14:49:03 2015 - [info] Checking SSH publickey authentication and checking recovery script configurations on all alive slave servers..
Thu Jul 23 14:49:03 2015 - [info] Executing command : apply_diff_relay_logs --command=test --slave_user='root' --slave_host=mysql-mha01 --slave_ip=192.168.8.6 --slave_port=3306 --workdir=/var/log/masterha/node --target_version=5.5.43-log --manager_version=0.56 --relay_log_info=/var/lib/mysql/relay-log.info --relay_dir=/var/lib/mysql/ --slave_pass=xxx
Thu Jul 23 14:49:03 2015 - [info] Connecting to root@192.168.8.6(mysql-mha01:22)..
Checking slave recovery environment settings..
Opening /var/lib/mysql/relay-log.info ... ok.
Relay log found at /var/lib/mysql, up to mysql-mha01-relay-bin.000005
Temporary relay log file is /var/lib/mysql/mysql-mha01-relay-bin.000005
Testing mysql connection and privileges.. done.
Testing mysqlbinlog output.. done.
Cleaning up test file(s).. done.
Thu Jul 23 14:49:03 2015 - [info] Executing command : apply_diff_relay_logs --command=test --slave_user='root' --slave_host=mysql-mha03 --slave_ip=192.168.8.8 --slave_port=3306 --workdir=/var/log/masterha/node --target_version=5.5.43-log --manager_version=0.56 --relay_log_info=/var/lib/mysql/relay-log.info --relay_dir=/var/lib/mysql/ --slave_pass=xxx
Thu Jul 23 14:49:03 2015 - [info] Connecting to root@192.168.8.8(mysql-mha03:22)..
Checking slave recovery environment settings..
Opening /var/lib/mysql/relay-log.info ... ok.
Relay log found at /var/lib/mysql, up to mysql-mha03-relay-bin.000005
Temporary relay log file is /var/lib/mysql/mysql-mha03-relay-bin.000005
Testing mysql connection and privileges.. done.
Testing mysqlbinlog output.. done.
Cleaning up test file(s).. done.
Thu Jul 23 14:49:04 2015 - [info] Slaves settings check done.
Thu Jul 23 14:49:04 2015 - [info]
mysql-mha02(192.168.8.7:3306) (current master)
+--mysql-mha01(192.168.8.6:3306)
+--mysql-mha03(192.168.8.8:3306)
Thu Jul 23 14:49:04 2015 - [warning] master_ip_failover_script is not defined.
Thu Jul 23 14:49:04 2015 - [warning] shutdown_script is not defined.
Thu Jul 23 14:49:04 2015 - [info] Set master ping interval 3 seconds.
Thu Jul 23 14:49:04 2015 - [info] Set secondary check script: masterha_secondary_check -s mysql-mha03 --user=root --master_host=mysql-mha02 --master_ip=172.16.21.13 --master_port=3306
Thu Jul 23 14:49:04 2015 - [info] Starting ping health check on mysql-mha02(192.168.8.7:3306)..
Thu Jul 23 14:49:04 2015 - [info] Ping(SELECT) succeeded, waiting until MySQL doesn't respond..5. 验证MHA
5.1 故障切换
我们将master节点关闭
[root@mysql-mha02 ~]# service mysql stop Shutting down MySQL...[ OK ]
查看manager的输出日志
Thu Jul 23 14:59:13 2015 - [warning] Got error on MySQL select ping: 2006 (MySQL server has gone away) Thu Jul 23 14:59:13 2015 - [info] Executing SSH check script: save_binary_logs --command=test --start_pos=4 --binlog_dir=/var/lib/mysql/logs --output_file=/var/log/masterha/node/save_binary_logs_test --manager_version=0.56 --binlog_prefix=mysql-bin Thu Jul 23 14:59:13 2015 - [info] Executing secondary network check script: masterha_secondary_check -s mysql-mha03 --user=root --master_host=mysql-mha02 --master_ip=172.16.21.13 --master_port=3306 --user=root --master_host=mysql-mha02 --master_ip=192.168.8.7 --master_port=3306 --master_user=root --master_password=123456 --ping_type=SELECT Thu Jul 23 14:59:14 2015 - [info] HealthCheck: SSH to mysql-mha02 is reachable. Monitoring server mysql-mha03 is reachable, Master is not reachable from mysql-mha03. OK. Thu Jul 23 14:59:14 2015 - [info] Master is not reachable from all other monitoring servers. Failover should start. Thu Jul 23 14:59:16 2015 - [warning] Got error on MySQL connect: 2013 (Lost connection to MySQL server at 'reading initial communication packet', system error: 111) Thu Jul 23 14:59:16 2015 - [warning] Connection failed 2 time(s).. Thu Jul 23 14:59:19 2015 - [warning] Got error on MySQL connect: 2013 (Lost connection to MySQL server at 'reading initial communication packet', system error: 111) Thu Jul 23 14:59:19 2015 - [warning] Connection failed 3 time(s).. Thu Jul 23 14:59:22 2015 - [warning] Got error on MySQL connect: 2013 (Lost connection to MySQL server at 'reading initial communication packet', system error: 111) Thu Jul 23 14:59:22 2015 - [warning] Connection failed 4 time(s).. Thu Jul 23 14:59:22 2015 - [warning] Master is not reachable from health checker! Thu Jul 23 14:59:22 2015 - [warning] Master mysql-mha02(192.168.8.7:3306) is not reachable! Thu Jul 23 14:59:22 2015 - [warning] SSH is reachable. Thu Jul 23 14:59:22 2015 - [info] Connecting to a master server failed. Reading configuration file /etc/masterha_default.cnf and /etc/MHA/MHAmanager.conf again, and trying to connect to all servers to check server status.. Thu Jul 23 14:59:22 2015 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping. Thu Jul 23 14:59:22 2015 - [info] Reading application default configuration from /etc/MHA/MHAmanager.conf.. Thu Jul 23 14:59:22 2015 - [info] Reading server configuration from /etc/MHA/MHAmanager.conf.. Thu Jul 23 14:59:22 2015 - [info] GTID failover mode = 0 Thu Jul 23 14:59:22 2015 - [info] Dead Servers: Thu Jul 23 14:59:22 2015 - [info] mysql-mha02(192.168.8.7:3306) Thu Jul 23 14:59:22 2015 - [info] Alive Servers: Thu Jul 23 14:59:22 2015 - [info] mysql-mha01(192.168.8.6:3306) Thu Jul 23 14:59:22 2015 - [info] mysql-mha03(192.168.8.8:3306) Thu Jul 23 14:59:22 2015 - [info] Alive Slaves: Thu Jul 23 14:59:22 2015 - [info] mysql-mha01(192.168.8.6:3306) Version=5.5.43-log (oldest major version between slaves) log-bin:enabled Thu Jul 23 14:59:22 2015 - [info] Replicating from 192.168.8.7(192.168.8.7:3306) Thu Jul 23 14:59:22 2015 - [info] mysql-mha03(192.168.8.8:3306) Version=5.5.43-log (oldest major version between slaves) log-bin:enabled Thu Jul 23 14:59:22 2015 - [info] Replicating from 192.168.8.7(192.168.8.7:3306) Thu Jul 23 14:59:22 2015 - [info] Checking slave configurations.. Thu Jul 23 14:59:22 2015 - [info] read_only=1 is not set on slave mysql-mha01(192.168.8.6:3306). Thu Jul 23 14:59:22 2015 - [info] read_only=1 is not set on slave mysql-mha03(192.168.8.8:3306). Thu Jul 23 14:59:22 2015 - [info] Checking replication filtering settings.. Thu Jul 23 14:59:22 2015 - [info] Replication filtering check ok. Thu Jul 23 14:59:22 2015 - [info] Master is down! Thu Jul 23 14:59:22 2015 - [info] Terminating monitoring script. Thu Jul 23 14:59:22 2015 - [info] Got exit code 20 (Master dead). Thu Jul 23 14:59:22 2015 - [info] MHA::MasterFailover version 0.56. Thu Jul 23 14:59:22 2015 - [info] Starting master failover. Thu Jul 23 14:59:22 2015 - [info] Thu Jul 23 14:59:22 2015 - [info] * Phase 1: Configuration Check Phase.. Thu Jul 23 14:59:22 2015 - [info] Thu Jul 23 14:59:23 2015 - [info] GTID failover mode = 0 Thu Jul 23 14:59:23 2015 - [info] Dead Servers: Thu Jul 23 14:59:23 2015 - [info] mysql-mha02(192.168.8.7:3306) Thu Jul 23 14:59:23 2015 - [info] Checking master reachability via MySQL(double check)... Thu Jul 23 14:59:23 2015 - [info] ok. Thu Jul 23 14:59:23 2015 - [info] Alive Servers: Thu Jul 23 14:59:23 2015 - [info] mysql-mha01(192.168.8.6:3306) Thu Jul 23 14:59:23 2015 - [info] mysql-mha03(192.168.8.8:3306) Thu Jul 23 14:59:23 2015 - [info] Alive Slaves: Thu Jul 23 14:59:23 2015 - [info] mysql-mha01(192.168.8.6:3306) Version=5.5.43-log (oldest major version between slaves) log-bin:enabled Thu Jul 23 14:59:23 2015 - [info] Replicating from 192.168.8.7(192.168.8.7:3306) Thu Jul 23 14:59:23 2015 - [info] mysql-mha03(192.168.8.8:3306) Version=5.5.43-log (oldest major version between slaves) log-bin:enabled Thu Jul 23 14:59:23 2015 - [info] Replicating from 192.168.8.7(192.168.8.7:3306) Thu Jul 23 14:59:23 2015 - [info] Starting Non-GTID based failover. Thu Jul 23 14:59:23 2015 - [info] Thu Jul 23 14:59:23 2015 - [info] ** Phase 1: Configuration Check Phase completed. Thu Jul 23 14:59:23 2015 - [info] Thu Jul 23 14:59:23 2015 - [info] * Phase 2: Dead Master Shutdown Phase.. Thu Jul 23 14:59:23 2015 - [info] Thu Jul 23 14:59:23 2015 - [info] Forcing shutdown so that applications never connect to the current master.. Thu Jul 23 14:59:23 2015 - [warning] master_ip_failover_script is not set. Skipping invalidating dead master IP address. Thu Jul 23 14:59:23 2015 - [warning] shutdown_script is not set. Skipping explicit shutting down of the dead master. Thu Jul 23 14:59:23 2015 - [info] * Phase 2: Dead Master Shutdown Phase completed. Thu Jul 23 14:59:23 2015 - [info] Thu Jul 23 14:59:23 2015 - [info] * Phase 3: Master Recovery Phase.. Thu Jul 23 14:59:23 2015 - [info] Thu Jul 23 14:59:23 2015 - [info] * Phase 3.1: Getting Latest Slaves Phase.. Thu Jul 23 14:59:23 2015 - [info] Thu Jul 23 14:59:23 2015 - [info] The latest binary log file/position on all slaves is mysql-bin.000014:107 Thu Jul 23 14:59:23 2015 - [info] Latest slaves (Slaves that received relay log files to the latest): Thu Jul 23 14:59:23 2015 - [info] mysql-mha01(192.168.8.6:3306) Version=5.5.43-log (oldest major version between slaves) log-bin:enabled Thu Jul 23 14:59:23 2015 - [info] Replicating from 192.168.8.7(192.168.8.7:3306) Thu Jul 23 14:59:23 2015 - [info] mysql-mha03(192.168.8.8:3306) Version=5.5.43-log (oldest major version between slaves) log-bin:enabled Thu Jul 23 14:59:23 2015 - [info] Replicating from 192.168.8.7(192.168.8.7:3306) Thu Jul 23 14:59:23 2015 - [info] The oldest binary log file/position on all slaves is mysql-bin.000014:107 Thu Jul 23 14:59:23 2015 - [info] Oldest slaves: Thu Jul 23 14:59:23 2015 - [info] mysql-mha01(192.168.8.6:3306) Version=5.5.43-log (oldest major version between slaves) log-bin:enabled Thu Jul 23 14:59:23 2015 - [info] Replicating from 192.168.8.7(192.168.8.7:3306) Thu Jul 23 14:59:23 2015 - [info] mysql-mha03(192.168.8.8:3306) Version=5.5.43-log (oldest major version between slaves) log-bin:enabled Thu Jul 23 14:59:23 2015 - [info] Replicating from 192.168.8.7(192.168.8.7:3306) Thu Jul 23 14:59:23 2015 - [info] Thu Jul 23 14:59:23 2015 - [info] * Phase 3.2: Saving Dead Master's Binlog Phase.. Thu Jul 23 14:59:23 2015 - [info] Thu Jul 23 14:59:23 2015 - [info] Fetching dead master's binary logs.. Thu Jul 23 14:59:23 2015 - [info] Executing command on the dead master mysql-mha02(192.168.8.7:3306): save_binary_logs --command=save --start_file=mysql-bin.000014 --start_pos=107 --binlog_dir=/var/lib/mysql/logs --output_file=/var/log/masterha/node/saved_master_binlog_from_mysql-mha02_3306_20150723145922.binlog --handle_raw_binlog=1 --disable_log_bin=0 --manager_version=0.56 Creating /var/log/masterha/node if not exists.. ok. Concat binary/relay logs from mysql-bin.000014 pos 107 to mysql-bin.000014 EOF into /var/log/masterha/node/saved_master_binlog_from_mysql-mha02_3306_20150723145922.binlog .. Dumping binlog format description event, from position 0 to 107.. ok. Dumping effective binlog data from /var/lib/mysql/logs/mysql-bin.000014 position 107 to tail(126).. ok. Concat succeeded. Thu Jul 23 14:59:23 2015 - [info] scp from root@192.168.8.7:/var/log/masterha/node/saved_master_binlog_from_mysql-mha02_3306_20150723145922.binlog to local:/var/log/masterha/manager/saved_master_binlog_from_mysql-mha02_3306_20150723145922.binlog succeeded. Thu Jul 23 14:59:23 2015 - [info] HealthCheck: SSH to mysql-mha01 is reachable. Thu Jul 23 14:59:24 2015 - [info] HealthCheck: SSH to mysql-mha03 is reachable. Thu Jul 23 14:59:24 2015 - [info] Thu Jul 23 14:59:24 2015 - [info] * Phase 3.3: Determining New Master Phase.. Thu Jul 23 14:59:24 2015 - [info] Thu Jul 23 14:59:24 2015 - [info] Finding the latest slave that has all relay logs for recovering other slaves.. Thu Jul 23 14:59:24 2015 - [info] All slaves received relay logs to the same position. No need to resync each other. Thu Jul 23 14:59:24 2015 - [info] Searching new master from slaves.. Thu Jul 23 14:59:24 2015 - [info] Candidate masters from the configuration file: Thu Jul 23 14:59:24 2015 - [info] Non-candidate masters: Thu Jul 23 14:59:24 2015 - [info] New master is mysql-mha01(192.168.8.6:3306) Thu Jul 23 14:59:24 2015 - [info] Starting master failover.. Thu Jul 23 14:59:24 2015 - [info] From: mysql-mha02(192.168.8.7:3306) (current master) +--mysql-mha01(192.168.8.6:3306) +--mysql-mha03(192.168.8.8:3306) To: mysql-mha01(192.168.8.6:3306) (new master) +--mysql-mha03(192.168.8.8:3306) Thu Jul 23 14:59:24 2015 - [info] Thu Jul 23 14:59:24 2015 - [info] * Phase 3.3: New Master Diff Log Generation Phase.. Thu Jul 23 14:59:24 2015 - [info] Thu Jul 23 14:59:24 2015 - [info] This server has all relay logs. No need to generate diff files from the latest slave. Thu Jul 23 14:59:24 2015 - [info] Sending binlog.. Thu Jul 23 14:59:24 2015 - [info] scp from local:/var/log/masterha/manager/saved_master_binlog_from_mysql-mha02_3306_20150723145922.binlog to root@mysql-mha01:/var/log/masterha/node/saved_master_binlog_from_mysql-mha02_3306_20150723145922.binlog succeeded. Thu Jul 23 14:59:24 2015 - [info] Thu Jul 23 14:59:24 2015 - [info] * Phase 3.4: Master Log Apply Phase.. Thu Jul 23 14:59:24 2015 - [info] Thu Jul 23 14:59:24 2015 - [info] *NOTICE: If any error happens from this phase, manual recovery is needed. Thu Jul 23 14:59:24 2015 - [info] Starting recovery on mysql-mha01(192.168.8.6:3306).. Thu Jul 23 14:59:24 2015 - [info] Generating diffs succeeded. Thu Jul 23 14:59:24 2015 - [info] Waiting until all relay logs are applied. Thu Jul 23 14:59:24 2015 - [info] done. Thu Jul 23 14:59:24 2015 - [info] Getting slave status.. Thu Jul 23 14:59:24 2015 - [info] This slave(mysql-mha01)'s Exec_Master_Log_Pos equals to Read_Master_Log_Pos(mysql-bin.000014:107). No need to recover from Exec_Master_Log_Pos. Thu Jul 23 14:59:24 2015 - [info] Connecting to the target slave host mysql-mha01, running recover script.. Thu Jul 23 14:59:24 2015 - [info] Executing command: apply_diff_relay_logs --command=apply --slave_user='root' --slave_host=mysql-mha01 --slave_ip=192.168.8.6 --slave_port=3306 --apply_files=/var/log/masterha/node/saved_master_binlog_from_mysql-mha02_3306_20150723145922.binlog --workdir=/var/log/masterha/node --target_version=5.5.43-log --timestamp=20150723145922 --handle_raw_binlog=1 --disable_log_bin=0 --manager_version=0.56 --slave_pass=xxx Thu Jul 23 14:59:24 2015 - [info] Applying differential binary/relay log files /var/log/masterha/node/saved_master_binlog_from_mysql-mha02_3306_20150723145922.binlog on mysql-mha01:3306. This may take long time... Applying log files succeeded. Thu Jul 23 14:59:24 2015 - [info] All relay logs were successfully applied. Thu Jul 23 14:59:24 2015 - [info] Getting new master's binlog name and position.. Thu Jul 23 14:59:24 2015 - [info] mysql-bin.000014:107 Thu Jul 23 14:59:24 2015 - [info] All other slaves should start replication from here. Statement should be: CHANGE MASTER TO MASTER_HOST='mysql-mha01 or 192.168.8.6', MASTER_PORT=3306, MASTER_LOG_FILE='mysql-bin.000014', MASTER_LOG_POS=107, MASTER_USER='repl', MASTER_PASSWORD='xxx'; Thu Jul 23 14:59:24 2015 - [warning] master_ip_failover_script is not set. Skipping taking over new master IP address. Thu Jul 23 14:59:24 2015 - [info] ** Finished master recovery successfully. Thu Jul 23 14:59:24 2015 - [info] * Phase 3: Master Recovery Phase completed. Thu Jul 23 14:59:24 2015 - [info] Thu Jul 23 14:59:24 2015 - [info] * Phase 4: Slaves Recovery Phase.. Thu Jul 23 14:59:24 2015 - [info] Thu Jul 23 14:59:24 2015 - [info] * Phase 4.1: Starting Parallel Slave Diff Log Generation Phase.. Thu Jul 23 14:59:24 2015 - [info] Thu Jul 23 14:59:24 2015 - [info] -- Slave diff file generation on host mysql-mha03(192.168.8.8:3306) started, pid: 6359. Check tmp log /var/log/masterha/manager/mysql-mha03_3306_20150723145922.log if it takes time.. Thu Jul 23 14:59:24 2015 - [info] Thu Jul 23 14:59:24 2015 - [info] Log messages from mysql-mha03 ... Thu Jul 23 14:59:24 2015 - [info] Thu Jul 23 14:59:24 2015 - [info] This server has all relay logs. No need to generate diff files from the latest slave. Thu Jul 23 14:59:24 2015 - [info] End of log messages from mysql-mha03. Thu Jul 23 14:59:24 2015 - [info] -- mysql-mha03(192.168.8.8:3306) has the latest relay log events. Thu Jul 23 14:59:24 2015 - [info] Generating relay diff files from the latest slave succeeded. Thu Jul 23 14:59:24 2015 - [info] Thu Jul 23 14:59:24 2015 - [info] * Phase 4.2: Starting Parallel Slave Log Apply Phase.. Thu Jul 23 14:59:24 2015 - [info] Thu Jul 23 14:59:24 2015 - [info] -- Slave recovery on host mysql-mha03(192.168.8.8:3306) started, pid: 6361. Check tmp log /var/log/masterha/manager/mysql-mha03_3306_20150723145922.log if it takes time.. Thu Jul 23 14:59:25 2015 - [info] Thu Jul 23 14:59:25 2015 - [info] Log messages from mysql-mha03 ... Thu Jul 23 14:59:25 2015 - [info] Thu Jul 23 14:59:24 2015 - [info] Sending binlog.. Thu Jul 23 14:59:24 2015 - [info] scp from local:/var/log/masterha/manager/saved_master_binlog_from_mysql-mha02_3306_20150723145922.binlog to root@mysql-mha03:/var/log/masterha/node/saved_master_binlog_from_mysql-mha02_3306_20150723145922.binlog succeeded. Thu Jul 23 14:59:24 2015 - [info] Starting recovery on mysql-mha03(192.168.8.8:3306).. Thu Jul 23 14:59:24 2015 - [info] Generating diffs succeeded. Thu Jul 23 14:59:24 2015 - [info] Waiting until all relay logs are applied. Thu Jul 23 14:59:24 2015 - [info] done. Thu Jul 23 14:59:24 2015 - [info] Getting slave status.. Thu Jul 23 14:59:24 2015 - [info] This slave(mysql-mha03)'s Exec_Master_Log_Pos equals to Read_Master_Log_Pos(mysql-bin.000014:107). No need to recover from Exec_Master_Log_Pos. Thu Jul 23 14:59:24 2015 - [info] Connecting to the target slave host mysql-mha03, running recover script.. Thu Jul 23 14:59:24 2015 - [info] Executing command: apply_diff_relay_logs --command=apply --slave_user='root' --slave_host=mysql-mha03 --slave_ip=192.168.8.8 --slave_port=3306 --apply_files=/var/log/masterha/node/saved_master_binlog_from_mysql-mha02_3306_20150723145922.binlog --workdir=/var/log/masterha/node --target_version=5.5.43-log --timestamp=20150723145922 --handle_raw_binlog=1 --disable_log_bin=0 --manager_version=0.56 --slave_pass=xxx Thu Jul 23 14:59:24 2015 - [info] Applying differential binary/relay log files /var/log/masterha/node/saved_master_binlog_from_mysql-mha02_3306_20150723145922.binlog on mysql-mha03:3306. This may take long time... Applying log files succeeded. Thu Jul 23 14:59:24 2015 - [info] All relay logs were successfully applied. Thu Jul 23 14:59:24 2015 - [info] Resetting slave mysql-mha03(192.168.8.8:3306) and starting replication from the new master mysql-mha01(192.168.8.6:3306).. Thu Jul 23 14:59:24 2015 - [info] Executed CHANGE MASTER. Thu Jul 23 14:59:25 2015 - [info] Slave started. Thu Jul 23 14:59:25 2015 - [info] End of log messages from mysql-mha03. Thu Jul 23 14:59:25 2015 - [info] -- Slave recovery on host mysql-mha03(192.168.8.8:3306) succeeded. Thu Jul 23 14:59:25 2015 - [info] All new slave servers recovered successfully. Thu Jul 23 14:59:25 2015 - [info] Thu Jul 23 14:59:25 2015 - [info] * Phase 5: New master cleanup phase.. Thu Jul 23 14:59:25 2015 - [info] Thu Jul 23 14:59:25 2015 - [info] Resetting slave info on the new master.. Thu Jul 23 14:59:25 2015 - [info] mysql-mha01: Resetting slave info succeeded. Thu Jul 23 14:59:25 2015 - [info] Master failover to mysql-mha01(192.168.8.6:3306) completed successfully. Thu Jul 23 14:59:25 2015 - [info] ----- Failover Report ----- MHAmanager: MySQL Master failover mysql-mha02(192.168.8.7:3306) to mysql-mha01(192.168.8.6:3306) succeeded Master mysql-mha02(192.168.8.7:3306) is down! Check MHA Manager logs at mysql-mha03:/var/log/masterha/manager.log for details. Started automated(non-interactive) failover. The latest slave mysql-mha01(192.168.8.6:3306) has all relay logs for recovery. Selected mysql-mha01(192.168.8.6:3306) as a new master. mysql-mha01(192.168.8.6:3306): OK: Applying all logs succeeded. mysql-mha03(192.168.8.8:3306): This host has the latest relay log events. Generating relay diff files from the latest slave succeeded. mysql-mha03(192.168.8.8:3306): OK: Applying all logs succeeded. Slave started, replicating from mysql-mha01(192.168.8.6:3306) mysql-mha01(192.168.8.6:3306): Resetting slave info succeeded. Master failover to mysql-mha01(192.168.8.6:3306) completed successfully.
发现MHA已经成功将主节点配置到mysql-mha01上。切换后manager节点自己主动关闭。
[root@mysql-mha03 ~]# ps -ef|grep -i master root 6414 3295 0 15:00 pts/1 00:00:00 grep -i master登录到mysql-mha03节点查看
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.8.6
Master_User: repl
Master_Port: 3306
Connect_Retry: 20
Master_Log_File: mysql-bin.000014
Read_Master_Log_Pos: 107
Relay_Log_File: mysql-mha03-relay-bin.000002
Relay_Log_Pos: 253
Relay_Master_Log_File: mysql-bin.000014
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 107
Relay_Log_Space: 415
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 1
1 row in set (0.00 sec)host已经改变成功。MHA配置成功。
5.2 主动切换
mha能够实现master的主动切换，能够让我们方便的维护集群环境。如我们能够将master切换到别的节点，维护原master节点。
须要将启动的manager节点关闭掉。否则会报错。
[root@mysql-mha03 ~]# masterha_stop --conf=/etc/MHA/MHAmanager.conf Stopped MHAmanager successfully. [1]+ Exit 1 nohup masterha_manager --conf=/etc/MHA/MHAmanager.conf
我们主动切换master节点。原master节点成为slave节点
[root@mysql-mha03 ~]# masterha_master_switch --master_state=alive --conf=/etc/MHA/MHAmanager.conf查看输出
Thu Jul 23 15:29:38 2015 - [info] MHA::MasterRotate version 0.56. Thu Jul 23 15:29:38 2015 - [info] Starting online master switch.. Thu Jul 23 15:29:38 2015 - [info] Thu Jul 23 15:29:38 2015 - [info] * Phase 1: Configuration Check Phase.. Thu Jul 23 15:29:38 2015 - [info] Thu Jul 23 15:29:38 2015 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping. Thu Jul 23 15:29:38 2015 - [info] Reading application default configuration from /etc/MHA/MHAmanager.conf.. Thu Jul 23 15:29:38 2015 - [info] Reading server configuration from /etc/MHA/MHAmanager.conf.. Thu Jul 23 15:29:39 2015 - [info] GTID failover mode = 0 Thu Jul 23 15:29:39 2015 - [info] Current Alive Master: mysql-mha01(192.168.8.6:3306) Thu Jul 23 15:29:39 2015 - [info] Alive Slaves: Thu Jul 23 15:29:39 2015 - [info] mysql-mha02(192.168.8.7:3306) Version=5.5.43-log (oldest major version between slaves) log-bin:enabled Thu Jul 23 15:29:39 2015 - [info] Replicating from 192.168.8.6(192.168.8.6:3306) Thu Jul 23 15:29:39 2015 - [info] mysql-mha03(192.168.8.8:3306) Version=5.5.43-log (oldest major version between slaves) log-bin:enabled Thu Jul 23 15:29:39 2015 - [info] Replicating from 192.168.8.6(192.168.8.6:3306) It is better to execute FLUSH NO_WRITE_TO_BINLOG TABLES on the master before switching. Is it ok to execute on mysql-mha01(192.168.8.6:3306)? (YES/no): yes Thu Jul 23 15:29:41 2015 - [info] Executing FLUSH NO_WRITE_TO_BINLOG TABLES. This may take long time.. Thu Jul 23 15:29:41 2015 - [info] ok. Thu Jul 23 15:29:41 2015 - [info] Checking MHA is not monitoring or doing failover.. Thu Jul 23 15:29:41 2015 - [info] Checking replication health on mysql-mha02.. Thu Jul 23 15:29:41 2015 - [info] ok. Thu Jul 23 15:29:41 2015 - [info] Checking replication health on mysql-mha03.. Thu Jul 23 15:29:41 2015 - [info] ok. Thu Jul 23 15:29:41 2015 - [info] Searching new master from slaves.. Thu Jul 23 15:29:41 2015 - [info] Candidate masters from the configuration file: Thu Jul 23 15:29:41 2015 - [info] Non-candidate masters: Thu Jul 23 15:29:41 2015 - [info] From: mysql-mha01(192.168.8.6:3306) (current master) +--mysql-mha02(192.168.8.7:3306) +--mysql-mha03(192.168.8.8:3306) To: mysql-mha02(192.168.8.7:3306) (new master) +--mysql-mha03(192.168.8.8:3306) Starting master switch from mysql-mha01(192.168.8.6:3306) to mysql-mha02(192.168.8.7:3306)? (yes/NO): yes Thu Jul 23 15:29:48 2015 - [info] Checking whether mysql-mha02(192.168.8.7:3306) is ok for the new master.. Thu Jul 23 15:29:48 2015 - [info] ok. Thu Jul 23 15:29:48 2015 - [info] ** Phase 1: Configuration Check Phase completed. Thu Jul 23 15:29:48 2015 - [info] Thu Jul 23 15:29:48 2015 - [info] * Phase 2: Rejecting updates Phase.. Thu Jul 23 15:29:48 2015 - [info] master_ip_online_change_script is not defined. If you do not disable writes on the current master manually, applications keep writing on the current master. Is it ok to proceed? (yes/NO): yes Thu Jul 23 15:29:59 2015 - [info] Locking all tables on the orig master to reject updates from everybody (including root): Thu Jul 23 15:29:59 2015 - [info] Executing FLUSH TABLES WITH READ LOCK.. Thu Jul 23 15:29:59 2015 - [info] ok. Thu Jul 23 15:29:59 2015 - [info] Orig master binlog:pos is mysql-bin.000014:107. Thu Jul 23 15:29:59 2015 - [info] Waiting to execute all relay logs on mysql-mha02(192.168.8.7:3306).. Thu Jul 23 15:29:59 2015 - [info] master_pos_wait(mysql-bin.000014:107) completed on mysql-mha02(192.168.8.7:3306). Executed 0 events. Thu Jul 23 15:29:59 2015 - [info] done. Thu Jul 23 15:29:59 2015 - [info] Getting new master's binlog name and position.. Thu Jul 23 15:29:59 2015 - [info] mysql-bin.000015:107 Thu Jul 23 15:29:59 2015 - [info] All other slaves should start replication from here. Statement should be: CHANGE MASTER TO MASTER_HOST='mysql-mha02 or 192.168.8.7', MASTER_PORT=3306, MASTER_LOG_FILE='mysql-bin.000015', MASTER_LOG_POS=107, MASTER_USER='repl', MASTER_PASSWORD='xxx'; Thu Jul 23 15:29:59 2015 - [info] Thu Jul 23 15:29:59 2015 - [info] * Switching slaves in parallel.. Thu Jul 23 15:29:59 2015 - [info] Thu Jul 23 15:29:59 2015 - [info] -- Slave switch on host mysql-mha03(192.168.8.8:3306) started, pid: 6819 Thu Jul 23 15:29:59 2015 - [info] Thu Jul 23 15:29:59 2015 - [info] Log messages from mysql-mha03 ... Thu Jul 23 15:29:59 2015 - [info] Thu Jul 23 15:29:59 2015 - [info] Waiting to execute all relay logs on mysql-mha03(192.168.8.8:3306).. Thu Jul 23 15:29:59 2015 - [info] master_pos_wait(mysql-bin.000014:107) completed on mysql-mha03(192.168.8.8:3306). Executed 0 events. Thu Jul 23 15:29:59 2015 - [info] done. Thu Jul 23 15:29:59 2015 - [info] Resetting slave mysql-mha03(192.168.8.8:3306) and starting replication from the new master mysql-mha02(192.168.8.7:3306).. Thu Jul 23 15:29:59 2015 - [info] Executed CHANGE MASTER. Thu Jul 23 15:29:59 2015 - [info] Slave started. Thu Jul 23 15:29:59 2015 - [info] End of log messages from mysql-mha03 ... Thu Jul 23 15:29:59 2015 - [info] Thu Jul 23 15:29:59 2015 - [info] -- Slave switch on host mysql-mha03(192.168.8.8:3306) succeeded. Thu Jul 23 15:29:59 2015 - [info] Unlocking all tables on the orig master: Thu Jul 23 15:29:59 2015 - [info] Executing UNLOCK TABLES.. Thu Jul 23 15:29:59 2015 - [info] ok. Thu Jul 23 15:29:59 2015 - [info] All new slave servers switched successfully. Thu Jul 23 15:29:59 2015 - [info] Thu Jul 23 15:29:59 2015 - [info] * Phase 5: New master cleanup phase.. Thu Jul 23 15:29:59 2015 - [info] Thu Jul 23 15:29:59 2015 - [info] mysql-mha02: Resetting slave info succeeded. Thu Jul 23 15:29:59 2015 - [info] Switching master to mysql-mha02(192.168.8.7:3306) completed successfully.查看mysql-mysql03节点。已经成功切换到mysql-mha02为master
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.8.7
Master_User: repl
Master_Port: 3306
Connect_Retry: 20
Master_Log_File: mysql-bin.000015
Read_Master_Log_Pos: 107
Relay_Log_File: mysql-mha03-relay-bin.000002
Relay_Log_Pos: 253
Relay_Master_Log_File: mysql-bin.000015
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
