mysql 高可用架构 mha 之四 Error happened on checking configurations

最新推荐文章于 2024-09-12 16:16:56 发布

数据库人生

最新推荐文章于 2024-09-12 16:16:56 发布

阅读量4.5k

点赞数 6

CC 4.0 BY-SA版权

分类专栏： # mysql ha mha 文章标签： mha

本文链接：https://blog.youkuaiyun.com/ctypyb2002/article/details/88344274

mysql ha mha 专栏收录该内容

8 篇文章

订阅专栏

本文详细记录了在Ubuntu16.04环境下，使用MHA0.58进行MySQL5.7.25复制健康检查时遇到的错误，并提供了具体的解决方案，涉及Perl脚本的修改。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

os: ubuntu 16.04
db: mysql 5.7.25
mha: 0.58

使用 masterha_check_repl 时一直报错
Fri Mar 8 11:31:30 2019 - [error][/usr/share/perl5/MHA/MasterMonitor.pm, ln427] Error happened on checking configurations. Redundant argument in sprintf at /usr/share/perl5/MHA/NodeUtil.pm line 201.
Fri Mar 8 11:31:30 2019 - [error][/usr/share/perl5/MHA/MasterMonitor.pm, ln525] Error happened on monitoring servers.

# masterha_check_repl --conf=/etc/masterha/app1/app1.cnf
Fri Mar  8 11:31:29 2019 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping.
Fri Mar  8 11:31:29 2019 - [info] Reading application default configuration from /etc/masterha/app1/app1.cnf..
Fri Mar  8 11:31:29 2019 - [info] Reading server configuration from /etc/masterha/app1/app1.cnf..
Fri Mar  8 11:31:29 2019 - [info] MHA::MasterMonitor version 0.58.
Fri Mar  8 11:31:30 2019 - [error][/usr/share/perl5/MHA/MasterMonitor.pm, ln427] Error happened on checking configurations. Redundant argument in sprintf at /usr/share/perl5/MHA/NodeUtil.pm line 201.
Fri Mar  8 11:31:30 2019 - [error][/usr/share/perl5/MHA/MasterMonitor.pm, ln525] Error happened on monitoring servers.
Fri Mar  8 11:31:30 2019 - [info] Got exit code 1 (Not master dead).

MySQL Replication Health is NOT OK!

需要对 /usr/share/perl5/MHA/NodeUtil.pm 修改

# vi /usr/share/perl5/MHA/NodeUtil.pm

sub parse_mysql_major_version($) {
  my $str = shift;
  my $result = sprintf( '%03d%03d', $str =~ m/(\d+)/g );
  return $result;
}

修改为

# vi /usr/share/perl5/MHA/NodeUtil.pm

sub parse_mysql_major_version($) {
  my $str = shift;
  $str =~ /(\d+)\.(\d+)/;
  my $strmajor = "$1.$2";
  my $result = sprintf( '%03d%03d', $strmajor =~ m/(\d+)/g );
  return $result;
}