[root@ ~]# mmm_control set_online db2
ERROR: Can't reach agent daemon on 'db2'! Can't switch its state!
[root@ ~]#
检查如下:
[root@ ~]# mmm_control checks all
db2 ping [last change: 2015/04/21 09:42:33] OK
db2 mysql [last change: 2015/04/21 09:44:41] OK
db2 rep_threads [last change: 2015/04/21 09:42:33] OK
db2 rep_backlog [last change: 2015/04/21 09:42:33] OK: Backlog is null
db3 ping [last change: 2015/04/21 09:42:33] OK
db3 mysql [last change: 2015/04/21 09:42:33] OK
db3 rep_threads [last change: 2015/04/21 09:42:33] OK
db3 rep_backlog [last change: 2015/04/21 09:42:33] OK: Backlog is null
db1 ping [last change: 2015/04/21 09:42:33] OK
db1 mysql [last change: 2015/04/21 09:42:33] OK
db1 rep_threads [last change: 2015/04/21 09:42:33] OK
db1 rep_backlog [last change: 2015/04/21 09:42:33] OK: Backlog is null[root@ ~]#
[root@ ~]# mmm_control show
# Warning: agent on host db2 is not reachable
db1(192.168.52.129) master/ONLINE. Roles: reader(192.168.52.231), writer(192.168.52.120)
db2(192.168.52.130) master/AWAITING_RECOVERY. Roles:
db3(192.168.52.131) slave/ONLINE. Roles: reader(192.168.52.229), reader(192.168.52.230)[root@ ~]#
ERROR: Can't reach agent daemon on 'db2'! Can't switch its state!
[root@ ~]#
检查如下:
[root@ ~]# mmm_control checks all
db2 ping [last change: 2015/04/21 09:42:33] OK
db2 mysql [last change: 2015/04/21 09:44:41] OK
db2 rep_threads [last change: 2015/04/21 09:42:33] OK
db2 rep_backlog [last change: 2015/04/21 09:42:33] OK: Backlog is null
db3 ping [last change: 2015/04/21 09:42:33] OK
db3 mysql [last change: 2015/04/21 09:42:33] OK
db3 rep_threads [last change: 2015/04/21 09:42:33] OK
db3 rep_backlog [last change: 2015/04/21 09:42:33] OK: Backlog is null
db1 ping [last change: 2015/04/21 09:42:33] OK
db1 mysql [last change: 2015/04/21 09:42:33] OK
db1 rep_threads [last change: 2015/04/21 09:42:33] OK
db1 rep_backlog [last change: 2015/04/21 09:42:33] OK: Backlog is null[root@ ~]#
[root@ ~]# mmm_control show
# Warning: agent on host db2 is not reachable
db1(192.168.52.129) master/ONLINE. Roles: reader(192.168.52.231), writer(192.168.52.120)
db2(192.168.52.130) master/AWAITING_RECOVERY. Roles:
db3(192.168.52.131) slave/ONLINE. Roles: reader(192.168.52.229), reader(192.168.52.230)[root@ ~]#
解决方案 »
- 请教 MySql 乱码问题!!
- MYSQL-Front不能导入SQL文件,每次导入到438这个地方就停了.
- 问个数据表联合查询优化的问题
- SQL查询问题
- mysql中一个查询语句的问题
- 有没有基于mysql的数据仓库?
- my.ini setup中那六个选项mysqld-shareware,mysqld.exe,mysqld-max.exe mysqld-opt.exe......有什么区别?应该用哪一个?
- 请教 一个表里有3个不同的用户id 如何通过联用户表的方式 取出这三个用户名呢
- 求扫盲,mysql执行计划应该如何理解
- 请问我怎么学mysql和jsp的配合呀?难吗?那里有教程?
- 谁看过mysql 源码?
- mysql 删除海量数据
[root@data02 ~]# tail -f /var/log/mysql-mmm/mmm_agentd.log
2015/04/21 09:46:09 FATAL Listener: Can't create socket!
2015/04/21 09:46:09 FATAL Child exited with exitcode 99, restarting after 10 second sleep
2015/04/21 09:46:19 FATAL Listener: Can't create socket!
2015/04/21 09:46:19 FATAL Child exited with exitcode 99, restarting after 10 second sleep
2015/04/21 09:46:29 FATAL Listener: Can't create socket!
2015/04/21 09:46:29 FATAL Child exited with exitcode 99, restarting after 10 second sleep
2015/04/21 09:46:39 FATAL Listener: Can't create socket!
2015/04/21 09:46:39 FATAL Child exited with exitcode 99, restarting after 10 second sleep
2015/04/21 09:46:49 FATAL Listener: Can't create socket!
可以参考下面文章
http://www.baidu.com/link?url=OUTF5sYu9mok10HexFTiFc8YkU50EoE3myFXKF85uqZho9b67KsE-fzRtULSZpIV93VRAwnpziUyG0TxeFCkopllGl-zo7_uyTFz4_amepC&wd=&eqid=a48f68ca000ad5a500000004567c9649