=1,等待几秒钟以便sql thread能够切换到新的relay log,最后执行set global log_purge=0.
具体参数如下:
--user mysql 用户名
--password mysql 密码
--port 端口号
--host 默认为127.0.0.1,不能为其他ip地址
--workdir 指定创建relay log的硬链接的位置,默认是/var/tmp,由于系统不同分区创建硬链接文件会失败,故需要执行硬链接具体位置,成功执行脚本后,硬链接的中继日志文件被删除
--disable_relay_log_purge 默认情况下,如果relay_log_purge=1,脚本会什么都不清理,自动退出,通过设定这个参数,当relay_log_purge=1的情况下会将relay_log_purge设置为0。清理relay log之后,最后将参数设置为OFF。
purge_relay_logs清除relay log不会阻塞sql thread,我们需要在所有的slave上定期执行此命令,如:
?
?
[root@rd-mysql-test2 scripts]# cat /etc/rc.local
#在此我们使用root
* 5 * * * /usr/local/bin/purge_relay_logs --user=root --disbale_relay_log_purge >> /var/log/masterha/purge_relay_log.log 2>&1
[root@rd-mysql-test3 scripts]# cat /etc/rc.local
#在此我们使用root
* 5 * * * /usr/local/bin/purge_relay_logs --user=root --disbale_relay_log_purge >> /var/log/masterha/purge_relay_log.log 2>&1
注意:确定使用的用户是否能够登录mysql
我们手动执行以下:
[root@rd-mysql-test2 ~]# purge_relay_logs --user=root --host=127.0.0.1 --port=3306 --disable_relay_log_purge
2015-08-07 15:11:38: purge_relay_logs script started.
Found relay_log.info: /data/mysql/relay-log.info
Removing hard linked relay log files net-app1b-relay-bin* under /var/tmp.. done.
Current relay log file: /data/mysql/net-app1b-relay-bin.000013
Archiving unused relay log files (up to /data/mysql/net-app1b-relay-bin.000012) ...
Creating hard link for /data/mysql/net-app1b-relay-bin.000012 under /var/tmp/net-app1b-relay-bin.000012 .. ok.
Creating hard links for unused relay log files completed.
Executing SET GLOBAL relay_log_purge=1; FLUSH LOGS; sleeping a few seconds so that SQL thread can delete older relay log files (if it keeps up); SET GLOBAL relay_log_purge=0; .. ok.
Removing hard linked relay log files net-app1b-relay-bin* under /var/tmp.. done.
2015-08-07 15:11:41: All relay log purging operations succeeded.
6. 检查ssh配置是否正确
检查所有的节点ssh是否能够互通
[root@rd-mysql-test4 scripts]# masterha_check_ssh --conf=/etc/mha/app1.cnf
Fri Aug 7 15:20:11 2015 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping.
Fri Aug 7 15:20:11 2015 - [info] Reading application default configurations from /etc/mha/app1.cnf..
Fri Aug 7 15:20:11 2015 - [info] Reading server configurations from /etc/mha/app1.cnf..
Fri Aug 7 15:20:11 2015 - [info] Starting SSH connection tests..
Fri Aug 7 15:20:11 2015 - [debug]
Fri Aug 7 15:20:11 2015 - [debug] Connecting via SSH from root@10.10.10.56(10.10.10.56:1022) to root@10.10.10.57(10.10.10.57:1022)..
Fri Aug 7 15:20:11 2015 - [debug] ok.
Fri Aug 7 15:20:11 2015 - [debug] Connecting via SSH from root@10.10.10.56(10.10.10.56:1022) to root@10.10.10.58(10.10.10.58:1022)..
Fri Aug 7 15:20:11 2015 - [debug] ok.
Fri Aug 7 15:20:12 2015 - [debug]
Fri Aug 7 15:20:11 2015 - [debug] Connecting via SSH from root@10.10.10.57(10.10.10.57:1022) to root@10.10.10.56(10.10.10.56:1022)..
Fri Aug 7 15:20:11 2015 - [debug] ok.
Fri Aug 7 15:20:11 2015 - [debug] Connecting via SSH from root@10.10.10.57(10.10.10.57:1022) to root@10.10.10.58(10.10.10.58:1022)..
Fri Aug 7 15:20:11 2015 - [debug] ok.
Fri Aug 7 15:20:12 2015 - [debug]
Fri Aug 7 15:20:12 2015 - [debug] Connecting via SSH from root@10.10.10.58(10.10.10.58:1022) to root@10.10.10.56(10.10.10.56:1022)..
Fri Aug 7 15:20:12 2015 - [debug] ok.
Fri Aug 7 15:20:12 2015