大牛帮我看看mmm部署不成功

flyszh

按照步骤一步步安装，最后
# mmm_control show
  db1-master(192.168.1.111) master/HARD_OFFLINE. Roles:
  db2-master(192.168.1.112) master/HARD_OFFLINE. Roles:
  db3-slave(192.168.1.201) slave/HARD_OFFLINE. Roles:
  db4-slave(192.168.1.202) slave/HARD_OFFLINE. Roles:

怎么没有一台机器是AWAITING_RECOVERY，各位大牛帮看看打神马原因啊，实在没辙了


每台mysql都启动agent
/etc/init.d/mysql-mmm-agent status
Daemon bin: '/usr/sbin/mmm_agentd'
Daemon pid: '/var/run/mmm_agentd.pid'
Checking MMM Agent process: running.


mmm_mond.log如下：

2012/09/26 19:31:59  INFO STARTING...
2012/09/26 19:31:59  INFO Waiting for network connection...
2012/09/26 19:31:59  INFO Spawning checker 'ping_ip'...
2012/09/26 19:31:59  INFO Shutting down checker 'ping_ip'...
2012/09/26 19:31:59  INFO Network connection is available.
2012/09/26 19:32:00  INFO Performing initial checks...
2012/09/26 19:32:00  INFO Spawning checker 'mysql'...
2012/09/26 19:32:00  INFO Shutting down checker 'mysql'...
2012/09/26 19:32:00  INFO Spawning checker 'ping'...
2012/09/26 19:32:00  INFO Shutting down checker 'ping'...
2012/09/26 19:32:00  INFO Spawning checker 'rep_backlog'...
2012/09/26 19:32:00  INFO Shutting down checker 'rep_backlog'...
2012/09/26 19:32:00  INFO Spawning checker 'rep_threads'...
2012/09/26 19:32:01  INFO Shutting down checker 'rep_threads'...
2012/09/26 19:32:01  WARN No binary found for killing hosts (/usr/lib/mysql-mmm//monitor/kill_host).
2012/09/26 19:32:01  WARN Check 'mysql' is in state 'failed' on host 'db1-master'. Skipping check of master-master configuration.
2012/09/26 19:32:01  WARN Received undefined answer from host db3-slave. $!:
2012/09/26 19:32:01 ERROR The status of the system 'db3-slave' could not be determined (answer was: 0).
2012/09/26 19:32:01  WARN Received undefined answer from host db4-slave. $!:
2012/09/26 19:32:01 ERROR The status of the system 'db4-slave' could not be determined (answer was: 0).
2012/09/26 19:32:01  WARN Received undefined answer from host db1-master. $!:
2012/09/26 19:32:01 ERROR The status of the system 'db1-master' could not be determined (answer was: 0).
2012/09/26 19:32:01  WARN Received undefined answer from host db2-master. $!:
2012/09/26 19:32:01 ERROR The status of the system 'db2-master' could not be determined (answer was: 0).
2012/09/26 19:32:01  INFO Startup status:

Roles:
    Role                     Host        Stored  System  Agent

Hosts:
    Host        Master      Writable  Stored state      Agent state     
    db3-slave   ?           ?         HARD_OFFLINE      HARD_OFFLINE   
    db4-slave   ?           ?         HARD_OFFLINE      HARD_OFFLINE   
    db1-master  -           ?         HARD_OFFLINE      HARD_OFFLINE   
    db2-master  -           ?         HARD_OFFLINE      HARD_OFFLINE   
2012/09/26 19:32:01 FATAL Can't reach agent on host 'db3-slave'
2012/09/26 19:32:01 FATAL Can't reach agent on host 'db4-slave'
2012/09/26 19:32:01  INFO Monitor started in active mode.
2012/09/26 19:32:04  INFO Spawning checker 'ping_ip'...
2012/09/26 19:32:04 FATAL Listener: Can't create socket!
2012/09/26 19:32:04  INFO Spawning checker 'mysql'...
2012/09/26 19:32:04  INFO Spawning checker 'ping'...
2012/09/26 19:32:05  INFO Spawning checker 'rep_backlog'...
2012/09/26 19:32:05  WARN Check 'mysql' on 'db3-slave' is in unknown state! Message: UNKNOWN: Error occurred: install_driver(mysql) failed: Can
't locate DBD/mysql.pm in @INC (@INC contains: /usr/local/lib/perl5 /usr/local/share/perl5 /usr/lib/perl5/vendor_perl /usr/share/perl5/vendor_p
erl /usr/lib/perl5 /usr/share/perl5 .) at (eval 17) line 3, <STDIN> line 2.
2012/09/26 19:32:05  WARN Checker 'mysql' is dead!
2012/09/26 19:32:05  INFO Spawning checker 'mysql'...
2012/09/26 19:32:05  INFO Spawning checker 'rep_threads'...
2012/09/26 19:32:05 FATAL Can't reach agent on host 'db1-master'
2012/09/26 19:32:05  INFO Check 'ping' on 'db3-slave' is ok!
2012/09/26 19:32:05  INFO Check 'ping' on 'db4-slave' is ok!
2012/09/26 19:32:05 FATAL Can't reach agent on host 'db2-master'
2012/09/26 19:32:05  INFO Check 'ping' on 'db1-master' is ok!
2012/09/26 19:32:05  INFO Check 'ping' on 'db2-master' is ok!
2012/09/26 19:32:05  WARN Check 'rep_backlog' on 'db3-slave' is in unknown state! Message: UNKNOWN: Error occurred: install_driver(mysql) faile
d: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/local/lib/perl5 /usr/local/share/perl5 /usr/lib/perl5/vendor_perl /usr/share/perl5/ve
ndor_perl /usr/lib/perl5 /usr/share/perl5 .) at (eval 17) line 3, <STDIN> line 2.
2012/09/26 19:32:05  WARN Checker 'rep_backlog' is dead!
2012/09/26 19:32:05  INFO Spawning checker 'rep_backlog'...
2012/09/26 19:32:05  WARN Check 'rep_threads' on 'db3-slave' is in unknown state! Message: UNKNOWN: Error occurred: install_driver(mysql) faile
d: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/local/lib/perl5 /usr/local/share/perl5 /usr/lib/perl5/vendor_perl /usr/share/perl5/ve
ndor_perl /usr/lib/perl5 /usr/share/perl5 .) at (eval 17) line 3, <STDIN> line 2.
2012/09/26 19:32:05  WARN Checker 'rep_threads' is dead!
2012/09/26 19:32:05  INFO Spawning checker 'rep_threads'...
2012/09/26 19:32:05  WARN Check 'mysql' on 'db4-slave' is in unknown state! Message: UNKNOWN: Error occurred: install_driver(mysql) failed: Can
't locate DBD/mysql.pm in @INC (@INC contains: /usr/local/lib/perl5 /usr/local/share/perl5 /usr/lib/perl5/vendor_perl /usr/share/perl5/vendor_p
erl /usr/lib/perl5 /usr/share/perl5 .) at (eval 17) line 3, <STDIN> line 1.
2012/09/26 19:32:05  WARN Checker 'mysql' is dead!
2012/09/26 19:32:05  INFO Spawning checker 'mysql'...
2012/09/26 19:32:06  WARN Check 'rep_backlog' on 'db4-slave' is in unknown state! Message: UNKNOWN: Error occurred: install_driver(mysql) faile
d: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/local/lib/perl5 /usr/local/share/perl5 /usr/lib/perl5/vendor_perl /usr/share/perl5/ve
ndor_perl /usr/lib/perl5 /usr/share/perl5 .) at (eval 17) line 3, <STDIN> line 1.
2012/09/26 19:32:06  WARN Checker 'rep_backlog' is dead!
2012/09/26 19:32:06  INFO Spawning checker 'rep_backlog'...
2012/09/26 19:32:06  WARN Check 'rep_threads' on 'db4-slave' is in unknown state! Message: UNKNOWN: Error occurred: install_driver(mysql) faile
d: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/local/lib/perl5 /usr/local/share/perl5 /usr/lib/perl5/vendor_perl /usr/share/perl5/ve
ndor_perl /usr/lib/perl5 /usr/share/perl5 .) at (eval 17) line 3, <STDIN> line 1.
2012/09/26 19:32:06  WARN Checker 'rep_threads' is dead!
2012/09/26 19:32:06  INFO Spawning checker 'rep_threads'...
2012/09/26 19:32:06  WARN Check 'mysql' on 'db1-master' is in unknown state! Message: UNKNOWN: Error occurred: install_driver(mysql) failed: Ca
n't locate DBD/mysql.pm in @INC (@INC contains: /usr/local/lib/perl5 /usr/local/share/perl5 /usr/lib/perl5/vendor_perl /usr/share/perl5/vendor_
perl /usr/lib/perl5 /usr/share/perl5 .) at (eval 17) line 3, <STDIN> line 1.
2012/09/26 19:32:06  WARN Checker 'mysql' is dead!
2012/09/26 19:32:06  INFO Spawning checker 'mysql'...
2012/09/26 19:32:06  WARN Check 'rep_backlog' on 'db1-master' is in unknown state! Message: UNKNOWN: Error occurred: install_driver(mysql) fail
ed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/local/lib/perl5 /usr/local/share/perl5 /usr/lib/perl5/vendor_perl /usr/share/perl5/v
endor_perl /usr/lib/perl5 /usr/share/perl5 .) at (eval 17) line 3, <STDIN> line 1.
2012/09/26 19:32:06  WARN Checker 'rep_backlog' is dead!
2012/09/26 19:32:06  INFO Spawning checker 'rep_backlog'...
2012/09/26 19:32:06  WARN Check 'rep_backlog' on 'db2-master' is in unknown state! Message: UNKNOWN: Error occurred: install_driver(mysql) fail
ed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/local/lib/perl5 /usr/local/share/perl5 /usr/lib/perl5/vendor_perl /usr/share/perl5/v
endor_perl /usr/lib/perl5 /usr/share/perl5 .) at (eval 17) line 3, <STDIN> line 1.
2012/09/26 19:32:06  WARN Check 'rep_threads' on 'db1-master' is in unknown state! Message: UNKNOWN: Error occurred: install_driver(mysql) fail
ed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/local/lib/perl5 /usr/local/share/perl5 /usr/lib/perl5/vendor_perl /usr/share/perl5/v
endor_perl /usr/lib/perl5 /usr/share/perl5 .) at (eval 17) line 3, <STDIN> line 1.
2012/09/26 19:32:06  WARN Checker 'rep_threads' is dead!
2012/09/26 19:32:06  INFO Spawning checker 'rep_threads'...
2012/09/26 19:32:06  WARN Check 'mysql' on 'db2-master' is in unknown state! Message: UNKNOWN: Error occurred: install_driver(mysql) failed: Ca
n't locate DBD/mysql.pm in @INC (@INC contains: /usr/local/lib/perl5 /usr/local/share/perl5 /usr/lib/perl5/vendor_perl /usr/share/perl5/vendor_
perl /usr/lib/perl5 /usr/share/perl5 .) at (eval 17) line 3, <STDIN> line 1.
2012/09/26 19:32:07  WARN Check 'rep_threads' on 'db2-master' is in unknown state! Message: UNKNOWN: Error occurred: install_driver(mysql) fail
ed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/local/lib/perl5 /usr/local/share/perl5 /usr/lib/perl5/vendor_perl /usr/share/perl5/v
endor_perl /usr/lib/perl5 /usr/share/perl5 .) at (eval 17) line 3, <STDIN> line 1.
2012/09/26 19:32:11  WARN Checker 'rep_backlog' is dead!
2012/09/26 19:32:11  INFO Spawning checker 'rep_backlog'...
2012/09/26 19:32:11  WARN Checker 'mysql' is dead!
2012/09/26 19:32:11  INFO Spawning checker 'mysql'...
2012/09/26 19:32:11  WARN Checker 'rep_backlog' is dead!
2012/09/26 19:32:11  INFO Spawning checker 'rep_backlog'...
2012/09/26 19:32:11  WARN Checker 'mysql' is dead!
2012/09/26 19:32:11  INFO Spawning checker 'mysql'...
2012/09/26 19:32:12  WARN Checker 'rep_threads' is dead!
2012/09/26 19:32:12  INFO Spawning checker 'rep_threads'...
2012/09/26 19:32:12  WARN Checker 'rep_backlog' is dead!
2012/09/26 19:32:12  INFO Spawning checker 'rep_backlog'...

flyszh

补充：每台mysql均正常，replication也都正常，数据没有丢失，navica连接正常，mmm用户权限应该也没有错误。

每台mysql防火墙开启3306和9989端口，monitor上防火墙开启9988端口

flyszh

自己搞定了

caesarok

楼主不厚道，解决过程也不分享一下。

nntp

你还是换MHA或者PRM吧。