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

人都哪去了?  關(guān)注一下啊....

kns1024wh

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

從這個提示上分析應(yīng)該是網(wǎng)絡(luò)連接就不能訪問10.10.80.188這個地址
如能范圍而數(shù)據(jù)庫的密碼不匹配將是其他的提示信息
請檢查heartbeat的日志信息
以及查看主機的vip地址信息是否出現(xiàn)
同時要合適主機的iptables規(guī)則是否允許了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什么的都關(guān)了. ping vip沒有問題. 也可以看到.

將haresource 里的 mysqld 換成apache, 從客戶端訪問vip也是可以的.
為什么換成mysql, 死活訪問不了..

mysql 訪問不了的原因, 日志根本看不到啊, 百湖有什么高見?
訪問