MySQL社区

 找回密码
 注册

QQ登录

只需一步,快速开始

扫一扫,访问微社区

搜索
查看: 1878|回复: 1
打印 上一主题 下一主题

[集群] MHA检查MySQL 主从同步报错

[复制链接]
跳转到指定楼层
1#
发表于 2017-6-23 17:22:28 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
本帖最后由 小小蚯蚓 于 2017-6-23 17:25 编辑

我搭建mha,验证mysql主从是否同步,抛出了错误,我的系统的Centos7, mha的版本是:0.52
报错信息如下:
[root@localhost soft]#
[root@localhost soft]# masterha_manager --conf=/etc/mha/mha.conf
Sat Jun 24 01:13:13 2017 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping.
Sat Jun 24 01:13:13 2017 - [info] Reading application default configurations from /etc/mha/mha.conf..
Sat Jun 24 01:13:13 2017 - [info] Reading server configurations from /etc/mha/mha.conf..
Sat Jun 24 01:13:13 2017 - [info] MHA::MasterMonitor version 0.52.
Sat Jun 24 01:13:14 2017 - [info] Dead Servers:
Sat Jun 24 01:13:14 2017 - [info] Alive Servers:
Sat Jun 24 01:13:14 2017 - [info]   192.168.68.15(192.168.68.15:3306)
Sat Jun 24 01:13:14 2017 - [info]   192.168.68.16(192.168.68.16:3306)
Sat Jun 24 01:13:14 2017 - [info]   192.168.68.17(192.168.68.17:3306)
Sat Jun 24 01:13:14 2017 - [info] Alive Slaves:
Sat Jun 24 01:13:14 2017 - [info]   192.168.68.16(192.168.68.16:3306)  Version=5.7.12-log (oldest major version between slaves) log-bin:enabled
Sat Jun 24 01:13:14 2017 - [info]     Replicating from 192.168.68.15(192.168.68.15:3306)
Sat Jun 24 01:13:14 2017 - [info]     Primary candidate for the new Master (candidate_master is set)
Sat Jun 24 01:13:14 2017 - [info]   192.168.68.17(192.168.68.17:3306)  Version=5.7.12-log (oldest major version between slaves) log-bin:enabled
Sat Jun 24 01:13:14 2017 - [info]     Replicating from 192.168.68.15(192.168.68.15:3306)
Sat Jun 24 01:13:14 2017 - [info]     Not candidate for the new Master (no_master is set)
Sat Jun 24 01:13:14 2017 - [info] Current Alive Master: 192.168.68.15(192.168.68.15:3306)
Sat Jun 24 01:13:14 2017 - [info] Checking slave configurations..
Sat Jun 24 01:13:14 2017 - [info] Checking replication filtering settings..
Sat Jun 24 01:13:14 2017 - [info]  binlog_do_db= , binlog_ignore_db=
Sat Jun 24 01:13:14 2017 - [info]  Replication filtering check ok.
Sat Jun 24 01:13:14 2017 - [error][/usr/lib/perl5/vendor_perl//MHA/MasterMonitor.pm, ln315] Error happend on checking configurations. Argument "1 # M-hM-/M-% MySQL M-fM-0M-8M-hM-?M-^\M-dM-8M-\rM-eM-^A..." isn't numeric in numeric ge (>=) at /usr/lib/perl5/vendor_perl//MHA/ServerManager.pm line 1083.
Sat Jun 24 01:13:14 2017 - [error][/usr/lib/perl5/vendor_perl//MHA/MasterMonitor.pm, ln396] Error happened on monitoring servers.
Sat Jun 24 01:13:14 2017 - [info] Got exit code 1 (Not master dead).




如果有知道问题的哥哥姐姐们,希望帮帮我,小女子感激不尽:P:P


分享到:  QQ好友和群QQ好友和群 QQ空间QQ空间 腾讯微博腾讯微博 腾讯朋友腾讯朋友 微信微信
收藏收藏 分享淘帖 顶 踩
2#
发表于 2017-9-9 11:28:00 | 只看该作者
首先我有一点不明白。检查mha的主从是否同步是用masterha_manager命令的嘛~
至于MHA的排错,建议先检查一下ssh环境和repl环境是否配置成功,配置文件是否正确
我也是初来乍到,拙建~
您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|申请友链|小黑屋|Archiver|手机版|MySQL社区 ( 京ICP备07012489号   
联系人:周生; 联系电话:13911732319

GMT+8, 2024-5-3 09:04 , Processed in 0.088673 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表