mm的monitor不能启动
来源:5-13 MMM架构实例演示(下)

慕仙1587843
2020-05-10
输入命令后显示如下:
[root@nini3 Desktop]# mmm_control show
ERROR: Can’t connect to monitor daemon!
debug日志输出如下:
2020/05/10 22:29:24 DEBUG Trying initial check ‘rep_backlog’ on host 'db2’
2020/05/10 22:29:24 DEBUG Core: reaped child 3132
2020/05/10 22:29:26 DEBUG rep_backlog(db2) = 'UNKNOWN: Connect error (host = 192.168.3.31:3306, user = monitor)! Can’t connect to MySQL server on ‘192.168.3.31’ (4)'
2020/05/10 22:29:26 DEBUG Trying initial check ‘rep_backlog’ on host 'db3’
2020/05/10 22:29:28 DEBUG rep_backlog(db3) = 'UNKNOWN: Connect error (host = 192.168.3.32:3306, user = monitor)! Can’t connect to MySQL server on ‘192.168.3.32’ (4)'
2020/05/10 22:29:28 DEBUG Trying initial check ‘rep_backlog’ on host 'db1’
2020/05/10 22:29:30 DEBUG rep_backlog(db1) = 'UNKNOWN: Connect error (host = 192.168.3.30:3306, user = monitor)! Can’t connect to MySQL server on ‘192.168.3.30’ (4)'
2020/05/10 22:29:30 INFO Shutting down checker ‘rep_backlog’…
2020/05/10 22:29:30 DEBUG Core: reaped child 3133
2020/05/10 22:29:30 INFO Spawning checker ‘rep_threads’…
2020/05/10 22:29:30 DEBUG Trying initial check ‘rep_threads’ on host 'db2’
2020/05/10 22:29:32 DEBUG rep_threads(db2) = 'UNKNOWN: Connect error (host = 192.168.3.31:3306, user = monitor)! Can’t connect to MySQL server on ‘192.168.3.31’ (4)'
2020/05/10 22:29:32 DEBUG Trying initial check ‘rep_threads’ on host 'db3’
2020/05/10 22:29:34 DEBUG rep_threads(db3) = 'UNKNOWN: Connect error (host = 192.168.3.32:3306, user = monitor)! Can’t connect to MySQL server on ‘192.168.3.32’ (4)'
2020/05/10 22:29:34 DEBUG Trying initial check ‘rep_threads’ on host 'db1’
2020/05/10 22:29:36 DEBUG rep_threads(db1) = 'UNKNOWN: Connect error (host = 192.168.3.30:3306, user = monitor)! Can’t connect to MySQL server on ‘192.168.3.30’ (4)'
2020/05/10 22:29:36 INFO Shutting down checker ‘rep_threads’…
2020/05/10 22:29:36 DEBUG Core: reaped child 3135
2020/05/10 22:29:36 WARN No binary found for killing hosts (/usr/libexec/mysql-mmm/monitor/kill_host).
2020/05/10 22:29:36 WARN Check ‘mysql’ is in state ‘failed’ on host ‘db1’. Skipping check of master-master configuration.
2020/05/10 22:29:36 FATAL Couldn’t open status file ‘/var/lib/mysql-mmm/mmm_mond.status’: Starting up without status information.
2020/05/10 22:29:36 DEBUG Sending command ‘GET_AGENT_STATUS()’ to db2 (192.168.3.31:9989)
2020/05/10 22:29:36 DEBUG Received Answer: OK: Returning status!|UNKNOWN|||UP:267.86
2020/05/10 22:29:36 DEBUG Sending command ‘GET_SYSTEM_STATUS()’ to db2 (192.168.3.31:9989)
2020/05/10 22:31:15 DEBUG Received Answer: OK: Returning status!|1||192.168.3.30|UP:367.13
2020/05/10 22:31:15 DEBUG Sending command ‘GET_AGENT_STATUS()’ to db3 (192.168.3.32:9989)
2020/05/10 22:31:15 DEBUG Received Answer: OK: Returning status!|UNKNOWN|||UP:219.14
2020/05/10 22:31:15 DEBUG Sending command ‘GET_SYSTEM_STATUS()’ to db3 (192.168.3.32:9989)
mond日志显示如下
[root@nini3 Desktop]# cat /var/log/mysql-mmm/mmm_mond.log
9:36 FATAL Couldn’t open status file ‘/var/lib/mysql-mmm/mmm_mond.status’: Starting up without status information.
防火墙和selinux已经关闭,3台agent都已经启动而且正常运行,在监控上使用mysql -u -p -h 均能连接到3台数据库上面.
请问是什么情况呢??
1回答
-
sqlercn
2020-05-11
看错误是monitor这个用户无法在mmm Server端访问到后端各个节点的数据库。把你的配置文件提供一下吧。
00
相似问题