mysql mmm telnet write的vip 不通过 什么原因啊 急！

zhangyulei0312

[root@localhost etc]# mmm_control show
MySQL Multi-Master Replication Manager
Version: 1.2.6
Config file: mmm_mon.conf
Daemon is running!
===============================
Cluster failover method: AUTO
===============================
Servers status:
  db1(192.168.232.129): master/ONLINE. Roles: reader(192.168.232.102, writer(192.168.232.103
  db2(192.168.232.130): master/ONLINE. Roles: reader(192.168.232.101
[root@localhost etc]# telnet 192.168.232.103 3306
Trying 192.168.232.103...
telnet: connect to address 192.168.232.103: No route to host
telnet: Unable to connect to remote host: No route to host

192.168.232.101，192.168.232.102 2个read的vip 均通过
文档上说 此时应该可以telnet 所有 vip

zhangyulei0312

此时 192.168.232.101，192.168.232.102 2个read的vip 可以ping通
write 192.168.232.103 这个ip 不能ping通

天下第一菜

我也遇到同样问题。。。。读的vip ping通，写的ping不通，哪个大师给点拨下

horizonhyg

配置有不对的地方吧，配置文件很多，都要看好才行

guliny

不幸,我也碰到了同样的问题,大家解决了吗?

guliny

问题解决了!
通过分析MMM原理,写VIP应该在MASTER1服务器上启动,分析AGENT的LOG日志:
[root@node1 mysql-mmm]# tail -f mmm_agentd.log


2011/10/17 00:05:20  INFO We have some new roles added or old rules deleted!
2011/10/17 00:05:20  INFO Added:   reader(192.168.10.41), writer(192.168.10.43)
2011/10/17 00:05:21 FATAL Couldn't sync with master: ERROR: Can't connect to MySQL (host = 192.168.10.45:3306, user = mmm_agent)! Access denied for user 'mmm_agent'@'node1' (using password: YES)

MMM程序确实是MASTER1上启动write VIP(192.168.10.43)!但失败了!此用户mmm_agent无法登录;
发现此用户在本地无法登录,但其它主机能够正常登录,怪事!

检查用户的登录权限,存在一些主机为空的用户:

mysql> select host,user,password from mysql.user;               
+---------------+-------------+-------------------------------------------+
| host          | user        | password                                  |
+---------------+-------------+-------------------------------------------+
| localhost     | root        | *4A82FDF1D80BA7470BA2E17FEEFD5A53D5D3B762 |
| node1         | root        |                                           |
| 127.0.0.1     | root        |                                           |
| ::1           | root        |                                           |
| node1         |             |                                           |
| 192.168.10.46 | rep1        | 5d2e19393cc5ef67                          |
| 192.168.10.49 | proxy1      | 5d2e19393cc5ef67                          |
| 192.168.10.45 | rep2        | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 |
| 192.168.10.%  | mmm_monitor | *C1F414D9BAF378B656A849B31F9F8AF3125F558B |
| 192.168.10.%  | mmm_agent   | *9404D503D0FAE1825CFEF873D0E7A38A26BBAB0F |
| 192.168.10.%  | replication | *1A629BF5797BF6AE523D06B26B94561098D18F4C |

登录删除这些用户,就重启mysql,
重启MMM_AGENT,


2011/10/17 00:45:53  INFO We have some new roles added or old rules deleted!
2011/10/17 00:45:53  INFO Added:   reader(192.168.10.41), writer(192.168.10.43)

启动不再报错了!

2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast qlen 1000
    link/ether 00:0c:29:8f:02:51 brd ff:ff:ff:ff:ff:ff
    inet 192.168.10.45/24 brd 192.168.10.255 scope global eth0
    inet 192.168.10.41/32 scope global eth0
    inet 192.168.10.43/32 scope global eth0

写VIP:192.168.10.43/在MASTER1上生成!