安装MHA中清理Relay log报错

最新推荐文章于 2025-01-07 09:32:24 发布

转载最新推荐文章于 2025-01-07 09:32:24 发布 · 83 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://yq.aliyun.com/articles/482886

文章标签：

#数据库 #运维

本文介绍在MHA环境中清理Relaylog时遇到的错误及其解决方法。主要问题是由于perl模块DBD::mysql未正确安装导致的。通过使用yum安装perl-DBD-MySQL包成功解决了该问题。

安装MHA中清理Relay log报错

[root@MHA3 ~]# /usr/bin/purge_relay_logs --user=root --password=123456 -disable_relay_log_purge --port=3306 --workdir=/opt/mysql/data/
2014-08-27 09:19:30: purge_relay_logs script started.
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8 .) at (eval 6) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, Proxy, Sponge.
at /usr/bin/purge_relay_logs line 162

解决以上错误 yum -y install perl-DBD-MySQL ncftp 就能解决

本文转自 jxzhfei 51CTO博客，原文链接:http://blog.51cto.com/jxzhfei/1545487