MySQL5.6 部署MHA
# masterha_check_repl --conf=/usr/local/mha/mha.cnfWed Sep 16 00:53:59 2015 - Global configuration file /etc/masterha_default.cnf not found. Skipping.
Wed Sep 16 00:53:59 2015 - Reading application default configurations from /usr/local/mha/mha.cnf..
Wed Sep 16 00:53:59 2015 - Reading server configurations from /usr/local/mha/mha.cnf..
Wed Sep 16 00:53:59 2015 - MHA::MasterMonitor version 0.55.
Wed Sep 16 00:53:59 2015 - Dead Servers:
Wed Sep 16 00:53:59 2015 - Alive Servers:
Wed Sep 16 00:53:59 2015 - master(192.168.1.116:3306)
Wed Sep 16 00:53:59 2015 - slave01(192.168.1.118:3306)
Wed Sep 16 00:53:59 2015 - slave02(192.168.1.119:3306)
Wed Sep 16 00:53:59 2015 - Alive Slaves:
Wed Sep 16 00:53:59 2015 - slave01(192.168.1.118:3306)Version=5.6.26-log (oldest major version between slaves) log-bin:enabled
Wed Sep 16 00:53:59 2015 - Replicating from 192.168.1.116(192.168.1.116:3306)
Wed Sep 16 00:53:59 2015 - Primary candidate for the new Master (candidate_master is set)
Wed Sep 16 00:53:59 2015 - slave02(192.168.1.119:3306)Version=5.6.26-log (oldest major version between slaves) log-bin:enabled
Wed Sep 16 00:53:59 2015 - Replicating from 192.168.1.116(192.168.1.116:3306)
Wed Sep 16 00:53:59 2015 - Not candidate for the new Master (no_master is set)
Wed Sep 16 00:53:59 2015 - Current Alive Master: master(192.168.1.116:3306)
Wed Sep 16 00:53:59 2015 - Checking slave configurations..
Wed Sep 16 00:53:59 2015 - read_only=1 is not set on slave slave01(192.168.1.118:3306).
Wed Sep 16 00:53:59 2015 - relay_log_purge=0 is not set on slave slave01(192.168.1.118:3306).
Wed Sep 16 00:53:59 2015 - read_only=1 is not set on slave slave02(192.168.1.119:3306).
Wed Sep 16 00:53:59 2015 - relay_log_purge=0 is not set on slave slave02(192.168.1.119:3306).
Wed Sep 16 00:53:59 2015 - Checking replication filtering settings..
Wed Sep 16 00:53:59 2015 - binlog_do_db= , binlog_ignore_db=
Wed Sep 16 00:53:59 2015 - Replication filtering check ok.
Wed Sep 16 00:53:59 2015 - Starting SSH connection tests..
Wed Sep 16 00:54:00 2015 - All SSH connection tests passed successfully.
Wed Sep 16 00:54:00 2015 - Checking MHA Node version..
Wed Sep 16 00:54:01 2015 - Version check ok.
Wed Sep 16 00:54:01 2015 - Checking SSH publickey authentication settings on the current master..
Wed Sep 16 00:54:01 2015 - HealthCheck: SSH to master is reachable.
Wed Sep 16 00:54:01 2015 - Master MHA Node version is 0.54.
Wed Sep 16 00:54:01 2015 - Checking recovery script configurations on the current master..
Wed Sep 16 00:54:01 2015 - Executing command: save_binary_logs --command=test --start_pos=4 --binlog_dir=/mydata/data --output_file=/var/tmp/save_binary_logs_test --manager_version=0.55 --start_file=master-bin.000006
Wed Sep 16 00:54:01 2015 - Connecting to root@master(master)..
Creating /var/tmp if not exists.. ok.
Checking output directory is accessible or not..
ok.
Binlog found at /mydata/data, up to master-bin.000006
Wed Sep 16 00:54:01 2015 - Master setting check done.
Wed Sep 16 00:54:01 2015 - Checking SSH publickey authentication and checking recovery script configurations on all alive slave servers..
Wed Sep 16 00:54:01 2015 - Executing command : apply_diff_relay_logs --command=test --slave_user='mha_rep' --slave_host=slave01 --slave_ip=192.168.1.118 --slave_port=3306 --workdir=/var/tmp --target_version=5.6.26-log --manager_version=0.55 --relay_log_info=/mydata/data/relay-log.info--relay_dir=/mydata/data/--slave_pass=xxx
Wed Sep 16 00:54:01 2015 - Connecting to root@192.168.1.118(slave01:22)..
Checking slave recovery environment settings..
Opening /mydata/data/relay-log.info ... ok.
Relay log found at /mydata/data, up to mysql-relay-bin.000002
Temporary relay log file is /mydata/data/mysql-relay-bin.000002
Testing mysql connection and privileges..Warning: Using a password on the command line interface can be insecure.
done.
Testing mysqlbinlog output.. done.
Cleaning up test file(s).. done.
Wed Sep 16 00:54:01 2015 - Executing command : apply_diff_relay_logs --command=test --slave_user='mha_rep' --slave_host=slave02 --slave_ip=192.168.1.119 --slave_port=3306 --workdir=/var/tmp --target_version=5.6.26-log --manager_version=0.55 --relay_log_info=/mydata/data/relay-log.info--relay_dir=/mydata/data/--slave_pass=xxx
Wed Sep 16 00:54:01 2015 - Connecting to root@192.168.1.119(slave02:22)..
Checking slave recovery environment settings..
Opening /mydata/data/relay-log.info ... ok.
Relay log found at /mydata/data, up to mysql-relay-bin.000002
Temporary relay log file is /mydata/data/mysql-relay-bin.000002
Testing mysql connection and privileges..Warning: Using a password on the command line interface can be insecure.
done.
Testing mysqlbinlog output.. done.
Cleaning up test file(s).. done.
Wed Sep 16 00:54:02 2015 - Slaves settings check done.
Wed Sep 16 00:54:02 2015 -
master (current master)
+--slave01
+--slave02
Wed Sep 16 00:54:02 2015 - Checking replication health on slave01..
Wed Sep 16 00:54:02 2015 - ok.
Wed Sep 16 00:54:02 2015 - Checking replication health on slave02..
Wed Sep 16 00:54:02 2015 - ok.
Wed Sep 16 00:54:02 2015 - Checking master_ip_failover_script status:
Wed Sep 16 00:54:02 2015 - /usr/local/mha/scripts/master_ip_failover --command=status --ssh_user=root --orig_master_host=master --orig_master_ip=192.168.1.116 --orig_master_port=3306
IN SCRIPT TEST====/sbin/ifconfig eth0:1 down==/sbin/ifconfig eth0:1 192.168.1.99;/sbin/arping -I eth0 -c 3 -s 192.168.1.99 192.168.1.1 >/dev/null 2>&1===
Checking the Status of the script.. OK
Wed Sep 16 00:54:05 2015 - OK.
Wed Sep 16 00:54:05 2015 - shutdown_script is not defined.
Wed Sep 16 00:54:05 2015 - Got exit code 0 (Not master dead).
MySQL Replication Health is OK.
页:
[1]