|
t=3306 --new_master_host=vdbsrv2 --new_master_ip=192.168.1.7 --new_master_port=3306 --new_master_user='mha'
--new_master_password='xxx'
Unknown option: new_master_user
Unknown option: new_master_password
IN SCRIPT TEST====/sbin/ifconfig eth0:0 down==/sbin/ifconfig eth0:0 192.168.1.13/24===
Enabling the VIP - 192.168.1.13/24 on the new master - vdbsrv2
Mon Apr 20 14:30:36 2015 - [info] OK.
Mon Apr 20 14:30:36 2015 - [info] ** Finished master recovery successfully.
Mon Apr 20 14:30:36 2015 - [info] * Phase 3: Master Recovery Phase completed.
Mon Apr 20 14:30:36 2015 - [info]
Mon Apr 20 14:30:36 2015 - [info] * Phase 4: Slaves Recovery Phase..
Mon Apr 20 14:30:36 2015 - [info]
Mon Apr 20 14:30:36 2015 - [info] * Phase 4.1: Starting Parallel Slave Diff Log Generation Phase..
Mon Apr 20 14:30:36 2015 - [info]
Mon Apr 20 14:30:36 2015 - [info] -- Slave diff file generation on host vdbsrv3(192.168.1.8:3306) started, pid: 7726.
Check tmp log /var/log/masterha/app1/vdbsrv3_3306_20150420143022.log if it takes time..
Mon Apr 20 14:30:37 2015 - [info]
Mon Apr 20 14:30:37 2015 - [info] Log messages from vdbsrv3 ...
Mon Apr 20 14:30:37 2015 - [info]
Mon Apr 20 14:30:36 2015 - [info] Server vdbsrv3 received relay logs up to: mysql-bin.000020:313962621
Mon Apr 20 14:30:36 2015 - [info] Need to get diffs from the latest slave(vdbsrv2) up to: mysql-bin.000020:315514388
(using the latest slave's relay logs) ###此时vdbsrv3需要从vdbsrv2获取差量日志
Mon Apr 20 14:30:36 2015 - [info] Connecting to the latest slave host vdbsrv2, generating diff relay log files..
Mon Apr 20 14:30:36 2015 - [info] Executing command: apply_diff_relay_logs --command=generate_and_send --scp_user=root --scp_host=192.168.1.8
--latest_mlf=mysql-bin.000020 --latest_rmlp=315514388 --target_mlf=mysql-bin.000020 --target_rmlp=313962621 --server_id=1001
--diff_file_readtolatest=/var/tmp/relay_from_read_to_latest_vdbsrv3_3306_20150420143022.binlog --workdir=/var/tmp --timestamp=20150420143022
--handle_raw_binlog=1 --disable_log_bin=0 --manager_version=0.56 --relay_log_info=/data/mysqldata/relay-log.info --relay_dir=/data/mysqldata/
Mon Apr 20 14:30:37 2015 - [info]
Opening /data/mysqldata/relay-log.info ... ok.
Relay log found at /data/mysqldata, up to vdbsrv2-relay-bin.000003
Fast relay log position search succeeded.
Target relay log file/position found. start_file:vdbsrv2-relay-bin.000003, start_pos:6265486.
Concat binary/relay logs from vdbsrv2-relay-bin.000003 pos 6265486 to vdbsrv2-relay-bin.000003 EOF into
/var/tmp/relay_from_read_to_latest_vdbsrv3_3306_20150420143022.binlog .. ###注，此时是从vdbsrv2中继日志获取
Binlog Checksum enabled
Binlog Checksum enabled
Dumping binlog format description event, from position 0 to 283.. ok.
Dumping effective binlog data from /data/mysqldata/vdbsrv2-relay-bin.000003 position 6265486 to tail(7817253).. ok.
Binlog Checksum enabled
Binlog Checksum enabled
Concat succeeded.
Generating diff relay log succeeded. Saved at /var/tmp/relay_from_read_to_latest_vdbsrv3_3306_20150420143022.binlog .
scp vdbsrv2:/var/tmp/relay_from_read_to_latest_vdbsrv3_3306_20150420143022.binlog to root@192.168.1.8(22) succeeded.
Mon Apr 20 14:30:37 2015 - [info] Generating diff files succeeded.
Mon Apr 20 14:30:37 2015 - [info] End of log messages from vdbsrv3.
Mon Apr 20 14:30:37 2015 |