• linkedu视频
  • 平面设计
  • 电脑入门
  • 操作系统
  • 办公应用
  • 电脑硬件
  • 动画设计
  • 3D设计
  • 网页设计
  • CAD设计
  • 影音处理
  • 数据库
  • 程序设计
  • 认证考试
  • 信息管理
  • 信息安全
菜单
linkedu.com
  • 网页制作
  • 数据库
  • 程序设计
  • 操作系统
  • CMS教程
  • 游戏攻略
  • 脚本语言
  • 平面设计
  • 软件教程
  • 网络安全
  • 电脑知识
  • 服务器
  • 视频教程
  • MsSql
  • Mysql
  • oracle
  • MariaDB
  • DB2
  • SQLite
  • PostgreSQL
  • MongoDB
  • Redis
  • Access
  • 数据库其它
  • sybase
  • HBase
您的位置:首页 > 数据库 >Mysql > [error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln222] Failed to get master_ip_failover_script

[error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln222] Failed to get master_ip_failover_script

作者:EVISWANG的博客 字体:[增加 减小] 来源:互联网 时间:2017-08-25

EVISWANG的博客通过本文主要向大家介绍了[error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln222] Failed to get master_ip_failover_script等相关知识,希望本文的分享对您有所帮助

[root@mysqlcentos01 bin]# masterha_check_repl --conf=/data/mhamanager/3306/log/mha.cnf  
Fri Aug 25 16:37:25 2017 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping.
Fri Aug 25 16:37:25 2017 - [info] Reading application default configurations from /data/mhamanager/3306/log/mha.cnf..
Fri Aug 25 16:37:25 2017 - [info] Reading server configurations from /data/mhamanager/3306/log/mha.cnf..
Fri Aug 25 16:37:25 2017 - [info] MHA::MasterMonitor version 0.56.
Fri Aug 25 16:37:26 2017 - [info] Dead Servers:
Fri Aug 25 16:37:26 2017 - [info] Alive Servers:
Fri Aug 25 16:37:26 2017 - [info]   10.194.41.231(10.194.41.231:3306)
Fri Aug 25 16:37:26 2017 - [info]   10.194.41.228(10.194.41.228:3306)
Fri Aug 25 16:37:26 2017 - [info]   10.194.41.227(10.194.41.227:3306)
Fri Aug 25 16:37:26 2017 - [info] Alive Slaves:
Fri Aug 25 16:37:26 2017 - [info]   10.194.41.228(10.194.41.228:3306)  Version=5.7.18-log (oldest major version between slaves) log-bin:enabled
Fri Aug 25 16:37:26 2017 - [info]     GTID ON
Fri Aug 25 16:37:26 2017 - [info]     Replicating from 10.194.41.231(10.194.41.231:3306)
Fri Aug 25 16:37:26 2017 - [info]   10.194.41.227(10.194.41.227:3306)  Version=5.7.18-log (oldest major version between slaves) log-bin:enabled
Fri Aug 25 16:37:26 2017 - [info]     GTID ON
Fri Aug 25 16:37:26 2017 - [info]     Replicating from 10.194.41.231(10.194.41.231:3306)
Fri Aug 25 16:37:26 2017 - [info]     Primary candidate for the new Master (candidate_master is set)
Fri Aug 25 16:37:26 2017 - [info] Current Alive Master: 10.194.41.231(10.194.41.231:3306)
Fri Aug 25 16:37:26 2017 - [info] Checking slave configurations..
Fri Aug 25 16:37:26 2017 - [warning]  relay_log_purge=0 is not set on slave 10.194.41.228(10.194.41.228:3306).
Fri Aug 25 16:37:26 2017 - [warning]  relay_log_purge=0 is not set on slave 10.194.41.227(10.194.41.227:3306).
Fri Aug 25 16:37:26 2017 - [info] Checking replication filtering settings..
Fri Aug 25 16:37:26 2017 - [info]  binlog_do_db= , binlog_ignore_db= 
Fri Aug 25 16:37:26 2017 - [info]  Replication filtering check ok.
Fri Aug 25 16:37:26 2017 - [info] GTID is supported. Skipping all SSH and Node package checking.
Fri Aug 25 16:37:26 2017 - [info] Checking SSH publickey authentication settings on the current master..
Fri Aug 25 16:37:31 2017 - [warning] HealthCheck: Got timeout on checking SSH connection to 10.194.41.231! at /usr/local/share/perl5/MHA/HealthCheck.pm line 298.
Fri Aug 25 16:37:31 2017 - [info] 
10.194.41.231 (current master)
 +--10.194.41.228
 +--10.194.41.227

Fri Aug 25 16:37:31 2017 - [info] Checking replication health on 10.194.41.228..
Fri Aug 25 16:37:31 2017 - [info]  ok.
Fri Aug 25 16:37:31 2017 - [info] Checking replication health on 10.194.41.227..
Fri Aug 25 16:37:31 2017 - [info]  ok.
Fri Aug 25 16:37:31 2017 - [info] Checking master_ip_failover_script status:
Fri Aug 25 16:37:31 2017 - [info]   /usr/local/bin/master_ip_failover --command=status --ssh_user=root --orig_master_host=10.194.41.231 --orig_master_ip=10.194.41.231 --orig_master_port=3306 
Bareword "FIXME_xxx" not allowed while "strict subs" in use at /usr/local/bin/master_ip_failover line 100.
Execution of /usr/local/bin/master_ip_failover aborted due to compilation errors.
Fri Aug 25 16:37:31 2017 - [error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln222]  Failed to get master_ip_failover_script status with return code 255:0.
Fri Aug 25 16:37:31 2017 - [error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln401] Error happend on checking configurations.  at /usr/local/bin/masterha_check_repl line 48.
Fri Aug 25 16:37:31 2017 - [error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln500] Error happened on monitoring servers.
Fri Aug 25 16:37:31 2017 - [info] Got exit code 1 (Not master dead).


MySQL Replication Health is NOT OK!

[root@mysqlcentos01 bin]# 

http://blog.csdn.net/kokuma/article/details/72900645

分享到:QQ空间新浪微博腾讯微博微信百度贴吧QQ好友复制网址打印

您可能想查找下面的文章:

  • [error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln222] Failed to get master_ip_failover_script

相关文章

  • 2017-05-11MySQL数据库的23个注意事项
  • 2017-05-11mysql too many open connections问题解决方法
  • 2018-12-05SQL 中sp_executesql存储过程的使用帮助
  • 2018-12-05mysql表的基础操作汇总(三)_MySQL
  • 2018-12-05sqlserver 日志恢复方法(搞定drop和truncate)
  • 2017-05-11Mysql如何避免全表扫描的方法
  • 2018-12-05oracle sequence语句重置方介绍
  • 2018-12-05sql查询语句优化
  • 2018-12-05通过创建SQLServer 2005到 Oracle10g 的链接服务器实现异构数据
  • 2017-05-11MYSQL 关于两个经纬度之间的距离由近及远排序

文章分类

  • MsSql
  • Mysql
  • oracle
  • MariaDB
  • DB2
  • SQLite
  • PostgreSQL
  • MongoDB
  • Redis
  • Access
  • 数据库其它
  • sybase
  • HBase

最近更新的内容

    • sql添加数据后返回受影响行数据
    • 利用MySQL命令行导出与导入数据库的方法
    • Sql Server 2005中查询用分隔符分割的内容中是否包含其中一个内
    • 详细介绍mysql 协议的服务端握手包及对其解析
    • 浅析一个MYSQL语法(在查询中使用count)的兼容性问题
    • 关于MySQL5.7.19安装目录下如何创建my.ini文件的示例详解
    • MySQL5.7.18下载和安装过程图文详解
    • MySQL中日期比较时遇到的编码问题解决办法
    • 返回SQL执行时间的存储过程
    • 快速增加MYSQL数据库连接数负载能力的方法分享

关于我们 - 联系我们 - 免责声明 - 网站地图

©2020-2025 All Rights Reserved. linkedu.com 版权所有