Heartbeat配置MySQL集群, 客户端无法访问

leetaedong

用虚拟出来的ip 访问:
[root@localhost ~]# mysql -h10.10.80.188 -uroot -proot
ERROR 2003 (HY000): Can't connect to MySQL server on '10.10.80.188' (111)
报这个错...

用真实ip 是可以访问的, 为什么?  
haresource 文件如下:
vip1.example.com 10.10.80.188/24  mysqld

leetaedong

人都哪去了?  关注一下啊....

kns1024wh

ERROR 2003 (HY000): Can't connect to MySQL server on '10.10.80.188' (111)

从这个提示上分析应该是网络连接就不能访问10.10.80.188这个地址
如能范围而数据库的密码不匹配将是其他的提示信息
请检查heartbeat的日志信息
以及查看主机的vip地址信息是否出现
同时要合适主机的iptables规则是否允许了3306端口的访问

leetaedong

log:
heartbeat[25254]: 2009/03/13_21:35:04 WARN: No STONITH device configured.
heartbeat[25254]: 2009/03/13_21:35:04 WARN: Shared disks are not protected.
heartbeat[25254]: 2009/03/13_21:35:04 info: Resources being acquired from vip2.example.com.
harc[25264]:    2009/03/13_21:35:05 info: Running /etc/ha.d/rc.d/status status
mach_down[25299]:       2009/03/13_21:35:05 info: /usr/share/heartbeat/mach_down: nice_failback: foreign resources acquired
mach_down[25299]:       2009/03/13_21:35:05 info: mach_down takeover complete for node vip2.example.com.
heartbeat[25254]: 2009/03/13_21:35:05 info: mach_down takeover complete.
heartbeat[25254]: 2009/03/13_21:35:05 info: Initial resource acquisition complete (mach_down)
IPaddr[25337]:  2009/03/13_21:35:05 INFO:  Resource is stopped
heartbeat[25265]: 2009/03/13_21:35:05 info: Local Resource acquisition completed.
harc[25389]:    2009/03/13_21:35:06 info: Running /etc/ha.d/rc.d/ip-request-resp ip-request-resp
ip-request-resp[25389]: 2009/03/13_21:35:06 received ip-request-resp 10.10.80.188 OK yes
ResourceManager[25410]: 2009/03/13_21:35:06 info: Acquiring resource group: vip1.example.com 10.10.80.188 mysqld
IPaddr[25437]:  2009/03/13_21:35:06 INFO:  Resource is stopped
ResourceManager[25410]: 2009/03/13_21:35:06 info: Running /etc/ha.d/resource.d/IPaddr 10.10.80.188 start
IPaddr[25510]:  2009/03/13_21:35:07 INFO: Using calculated nic for 10.10.80.188: eth0
IPaddr[25510]:  2009/03/13_21:35:07 INFO: Using calculated netmask for 10.10.80.188: 255.255.255.0
IPaddr[25510]:  2009/03/13_21:35:07 INFO: eval ifconfig eth0:0 10.10.80.188 netmask 255.255.255.0 broadcast 10.10.80.255
IPaddr[25493]:  2009/03/13_21:35:07 INFO:  Success
ResourceManager[25410]: 2009/03/13_21:35:07 info: Running /etc/init.d/mysqld  start
heartbeat[25254]: 2009/03/13_21:35:16 info: Local Resource acquisition completed. (none)
heartbeat[25254]: 2009/03/13_21:35:16 info: local resource transition completed.


上面的是日志, 至于iptables, selinux什么的都关了. ping vip没有问题. 也可以看到.

将haresource 里的 mysqld 换成apache, 从客户端访问vip也是可以的.
为什么换成mysql, 死活访问不了..

mysql 访问不了的原因, 日志根本看不到啊, 百湖有什么高见?
访问