mha 安装部署报错 failed: Attempt to reload DBD/mysql.pm aborted
[root@hz-op-mysql03.test /root]# masterha_check_repl --conf=/home/mha/conf/app1.conf
Tue Sep 29 14:16:25 2020 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping.
Tue Sep 29 14:16:25 2020 - [info] Reading application default configuration from /home/mha/conf/app1.conf..
Tue Sep 29 14:16:25 2020 - [info] Reading server configuration from /home/mha/conf/app1.conf..
Tue Sep 29 14:16:25 2020 - [info] MHA::MasterMonitor version 0.58.
Tue Sep 29 14:16:25 2020 - [error][/usr/share/perl5/vendor_perl/MHA/ServerManager.pm, ln301] install_driver(mysql) failed: Attempt to reload DBD/mysql.pm aborted.
Compilation failed in require at (eval 37) line 3.
at /usr/share/perl5/vendor_perl/MHA/DBHelper.pm line 208.
at /usr/share/perl5/vendor_perl/MHA/Server.pm line 166.
Tue Sep 29 14:16:25 2020 - [error][/usr/share/perl5/vendor_perl/MHA/ServerManager.pm, ln301] install_driver(mysql) failed: Attempt to reload DBD/mysql.pm aborted.
Compilation failed in require at (eval 37) line 3.
at /usr/share/perl5/vendor_perl/MHA/DBHelper.pm line 208.
at /usr/share/perl5/vendor_perl/MHA/Server.pm line 166.
Tue Sep 29 14:16:25 2020 - [error][/usr/share/perl5/vendor_perl/MHA/ServerManager.pm, ln301] install_driver(mysql) failed: Attempt to reload DBD/mysql.pm aborted.
Compilation failed in require at (eval 37) line 3.
at /usr/share/perl5/vendor_perl/MHA/DBHelper.pm line 208.
at /usr/share/perl5/vendor_perl/MHA/Server.pm line 166.
Tue Sep 29 14:16:26 2020 - [error][/usr/share/perl5/vendor_perl/MHA/ServerManager.pm, ln309] Got fatal error, stopping operations
Tue Sep 29 14:16:26 2020 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln427] Error happened on checking configurations. at /usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm line 329.
Tue Sep 29 14:16:26 2020 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln525] Error happened on monitoring servers.
Tue Sep 29 14:16:26 2020 - [info] Got exit code 1 (Not master dead).
MySQL Replication Health is NOT OK!
参考网上文档并没有解决问题，因为处理过程中报错
yum install -y cpan
cpan -D DBI
cpan DBD::mysql
cpan DBD::mysql
[root@hz-op-mysql03.test /root]# cpan DBD::mysql
Reading '/root/.cpan/Metadata'
Database was generated on Mon, 28 Sep 2020 02:17:03 GMT
Running install for module 'DBD::mysql'
Running make for D/DV/DVEEDEN/DBD-mysql-4.050.tar.gz
Checksum for /root/.cpan/sources/authors/id/D/DV/DVEEDEN/DBD-mysql-4.050.tar.gz ok
CPAN.pm: Building D/DV/DVEEDEN/DBD-mysql-4.050.tar.gz
Can't exec "mysql_config": No such file or directory at Makefile.PL line 89.
Cannot find the file 'mysql_config'! Your execution PATH doesn't seem
not contain the path to mysql_config. Resorting to guessed values!
PLEASE NOTE:
For 'make test' to run properly, you must ensure that the
database user 'root' can connect to your MySQL server
and has the proper privileges that these tests require such
as 'drop table', 'create table', 'drop procedure', 'create procedure'
as well as others.
mysql> grant all privileges on test.* to 'root'@'localhost' identified by 's3kr1t';
You can also optionally set the user to run 'make test' with:
perl Makefile.PL --testuser=username
Can't exec "mysql_config": No such file or directory at Makefile.PL line 603.
Can't find mysql_config. Use --mysql_config option to specify where mysql_config is located
Failed to determine directory of mysql.h. Use
perl Makefile.PL --cflags=-I<dir>
to set this directory. For details see DBD::mysql::INSTALL,
section "C Compiler flags" or type
perl Makefile.PL --help
Warning: No success on command[/usr/bin/perl Makefile.PL]
'YAML' not installed, will not store persistent state
DVEEDEN/DBD-mysql-4.050.tar.gz
/usr/bin/perl Makefile.PL -- NOT OK
Running make test
Make had some problems, won't test
Running make install
Make had some problems, won't install
解决这个问题 Can't exec "mysql_config": No such file or directory at Makefile.PL line 89. 库文件缺失
cp -r /root/5.7.30/include/* /usr/include/
cp -r /root/5.7.30/lib/* /usr/lib/
