mysql高可用MHA部署全过程
# masterha_check_repl --conf=/etc/mha/conf/app1.cnfSat Nov4 00:57:03 2017 - Global configuration file /etc/masterha_default.cnf not found. Skipping.
Sat Nov4 00:57:03 2017 - Reading application default configurations from /etc/mha/conf/app1.cnf..
Sat Nov4 00:57:03 2017 - Reading server configurations from /etc/mha/conf/app1.cnf..
Sat Nov4 00:57:03 2017 - MHA::MasterMonitor version 0.55.
Sat Nov4 00:57:03 2017 - Dead Servers:
Sat Nov4 00:57:03 2017 - Alive Servers:
Sat Nov4 00:57:03 2017 - mysql_master(192.168.2.74:55555)
Sat Nov4 00:57:03 2017 - mysql_slave1(192.168.2.75:55555)
Sat Nov4 00:57:03 2017 - mysql_slave2(192.168.2.76:55555)
Sat Nov4 00:57:03 2017 - Alive Slaves:
Sat Nov4 00:57:03 2017 - mysql_slave1(192.168.2.75:55555)Version=5.5.57-log (oldest major version between slaves) log-bin:enabled
Sat Nov4 00:57:03 2017 - Replicating from 192.168.2.74(192.168.2.74:55555)
Sat Nov4 00:57:03 2017 - Primary candidate for the new Master (candidate_master is set)
Sat Nov4 00:57:03 2017 - mysql_slave2(192.168.2.76:55555)Version=5.5.57-log (oldest major version between slaves) log-bin:enabled
Sat Nov4 00:57:03 2017 - Replicating from 192.168.2.74(192.168.2.74:55555)
Sat Nov4 00:57:03 2017 - Primary candidate for the new Master (candidate_master is set)
Sat Nov4 00:57:03 2017 - Current Alive Master: mysql_master(192.168.2.74:55555)
Sat Nov4 00:57:03 2017 - Checking slave configurations..
Sat Nov4 00:57:03 2017 - read_only=1 is not set on slave mysql_slave1(192.168.2.75:55555).
Sat Nov4 00:57:03 2017 - read_only=1 is not set on slave mysql_slave2(192.168.2.76:55555).
Sat Nov4 00:57:03 2017 - Checking replication filtering settings..
Sat Nov4 00:57:03 2017 - binlog_do_db= , binlog_ignore_db=
Sat Nov4 00:57:03 2017 - Replication filtering check ok.
Sat Nov4 00:57:03 2017 - Starting SSH connection tests..
Sat Nov4 00:57:04 2017 - All SSH connection tests passed successfully.
Sat Nov4 00:57:04 2017 - Checking MHA Node version..
Sat Nov4 00:57:05 2017 - Version check ok.
Sat Nov4 00:57:05 2017 - Checking SSH publickey authentication settings on the current master..
Sat Nov4 00:57:05 2017 - HealthCheck: SSH to mysql_master is reachable.
Sat Nov4 00:57:05 2017 - Master MHA Node version is 0.54.
Sat Nov4 00:57:05 2017 - Checking recovery script configurations on the current master..
Sat Nov4 00:57:05 2017 - 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 Nov4 00:57:05 2017 - 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 Nov4 00:57:05 2017 - Master setting check done.
Sat Nov4 00:57:05 2017 - Checking SSH publickey authentication and checking recovery script configurations on all alive slave servers..
Sat Nov4 00:57:05 2017 - 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 Nov4 00:57:05 2017 - 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 Nov4 00:57:05 2017 - 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 Nov4 00:57:05 2017 - 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 Nov4 00:57:05 2017 - Slaves settings check done.
Sat Nov4 00:57:05 2017 -
mysql_master (current master)
+--mysql_slave1
+--mysql_slave2
Sat Nov4 00:57:05 2017 - Checking replication health on mysql_slave1..
Sat Nov4 00:57:05 2017 - ok.
Sat Nov4 00:57:05 2017 - Checking replication health on mysql_slave2..
Sat Nov4 00:57:05 2017 - ok.
Sat Nov4 00:57:05 2017 - master_ip_failover_script is not defined.
Sat Nov4 00:57:05 2017 - shutdown_script is not defined.
Sat Nov4 00:57:05 2017 - Got exit code 0 (Not master dead).
MySQL Replication Health is OK.
#
页:
[1]