[mysql@node3 ~]$ masterha_check_repl --conf=/etc/mha/app1.cnf Tue Jul 7 22:43:26 2020 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping. Tue Jul 7 22:43:26 2020 - [info] Reading application default configuration from /etc/mha/app1.cnf.. Tue Jul 7 22:43:26 2020 - [info] Reading server configuration from /etc/mha/app1.cnf.. Tue Jul 7 22:43:26 2020 - [info] MHA::MasterMonitor version 0.58. Tue Jul 7 22:43:26 2020 - [error][/usr/share/perl5/vendor_perl/MHA/Server.pm, ln180] Got MySQL error when connecting 192.168.12.131(192.168.12.131:3306) :1045:Access denied for user ‘mha‘@‘192.168.12.130‘ (using password: YES), but this is not a MySQL crash. Check MySQL server settings. Tue Jul 7 22:43:26 2020 - [error][/usr/share/perl5/vendor_perl/MHA/ServerManager.pm, ln301] at /usr/share/perl5/vendor_perl/MHA/ServerManager.pm line 297. Tue Jul 7 22:43:26 2020 - [error][/usr/share/perl5/vendor_perl/MHA/Server.pm, ln180] Got MySQL error when connecting 192.168.12.130(192.168.12.130:3306) :1045:Access denied for user ‘mha‘@‘192.168.12.130‘ (using password: YES), but this is not a MySQL crash. Check MySQL server settings. Tue Jul 7 22:43:26 2020 - [error][/usr/share/perl5/vendor_perl/MHA/ServerManager.pm, ln301] at /usr/share/perl5/vendor_perl/MHA/ServerManager.pm line 297. Tue Jul 7 22:43:26 2020 - [error][/usr/share/perl5/vendor_perl/MHA/Server.pm, ln180] Got MySQL error when connecting 192.168.12.132(192.168.12.132:3306) :1045:Access denied for user ‘mha‘@‘192.168.12.130‘ (using password: YES), but this is not a MySQL crash. Check MySQL server settings. Tue Jul 7 22:43:26 2020 - [error][/usr/share/perl5/vendor_perl/MHA/ServerManager.pm, ln301] at /usr/share/perl5/vendor_perl/MHA/ServerManager.pm line 297. Tue Jul 7 22:43:27 2020 - [error][/usr/share/perl5/vendor_perl/MHA/ServerManager.pm, ln309] Got fatal error, stopping operations Tue Jul 7 22:43:27 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 Jul 7 22:43:27 2020 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln525] Error happened on monitoring servers. Tue Jul 7 22:43:27 2020 - [info] Got exit code 1 (Not master dead).
原因:MHA配置文件监控用户mha的密码错误。
[mysql@node3 ~]$ cat /etc/mha/app1.cnf [server default] manager_log=/var/log/mha/app1/manager manager_workdir=/var/log/mha/app1 master_binlog_dir=/mysql/binlog user=mha password=mysql ping_interval=2 repl_password=mysql repl_user=repl ssh_user=mysql [server1] hostname=192.168.12.131 port=3306 [server2] hostname=192.168.12.132 port=3306 [server3] hostname=192.168.12.130 port=3306