亚洲av成人无遮挡网站在线观看,少妇性bbb搡bbb爽爽爽,亚洲av日韩精品久久久久久,兔费看少妇性l交大片免费,无码少妇一区二区三区

Chinaunix

標(biāo)題: Heartbeat配置MySQL集群, 客戶端無(wú)法訪問 [打印本頁(yè)]

作者: leetaedong 時(shí)間: 2009-03-13 17:08
標(biāo)題: Heartbeat配置MySQL集群, 客戶端無(wú)法訪問
用虛擬出來的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)
報(bào)這個(gè)錯(cuò)...

用真實(shí)ip 是可以訪問的, 為什么?
haresource 文件如下:
vip1.example.com 10.10.80.188/24 mysqld

作者: leetaedong 時(shí)間: 2009-03-13 18:48
人都哪去了? 關(guān)注一下啊....

作者: kns1024wh 時(shí)間: 2009-03-13 21:25

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

從這個(gè)提示上分析應(yīng)該是網(wǎng)絡(luò)連接就不能訪問10.10.80.188這個(gè)地址
如能范圍而數(shù)據(jù)庫(kù)的密碼不匹配將是其他的提示信息
請(qǐng)檢查heartbeat的日志信息
以及查看主機(jī)的vip地址信息是否出現(xiàn)
同時(shí)要合適主機(jī)的iptables規(guī)則是否允許了3306端口的訪問

作者: leetaedong 時(shí)間: 2009-03-13 21:50
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 訪問不了的原因, 日志根本看不到啊, 百湖有什么高見?
訪問

歡迎光臨 Chinaunix (http://72891.cn/)