请教MySQL双机HA时不能mountNFS服务器上的数据库的问题

Question

heartbeat[1795]: 2006/10/24_10:59:42 info: Configuration validated. Starting hea
rtbeat 2.0.7
heartbeat[1796]: 2006/10/24_10:59:42 info: heartbeat: version 2.0.7
heartbeat[1796]: 2006/10/24_10:59:43 info: Heartbeat generation: 19
heartbeat[1796]: 2006/10/24_10:59:43 info: G_main_add_TriggerHandler: Added sign
al manual handler
heartbeat[1796]: 2006/10/24_10:59:43 info: G_main_add_TriggerHandler: Added sign
al manual handler
heartbeat[1796]: 2006/10/24_10:59:43 info: Removing /var/run/heartbeat/rsctmp fa
iled, recreating.
heartbeat[1796]: 2006/10/24_10:59:43 info: glib: ucast: write socket priority se
t to IPTOS_LOWDELAY on eth0
heartbeat[1796]: 2006/10/24_10:59:43 info: glib: ucast: bound send socket to dev
ice: eth0
heartbeat[1796]: 2006/10/24_10:59:43 info: glib: ucast: bound receive socket to
device: eth0
heartbeat[1796]: 2006/10/24_10:59:43 info: glib: ucast: started on port 694 inte
rface eth0 to 172.25.16.95
heartbeat[1796]: 2006/10/24_10:59:43 info: glib: ucast: write socket priority se
t to IPTOS_LOWDELAY on eth0
heartbeat[1796]: 2006/10/24_10:59:43 info: glib: ucast: bound send socket to dev
ice: eth0
heartbeat[1796]: 2006/10/24_10:59:43 info: glib: ucast: bound receive socket to
device: eth0
heartbeat[1796]: 2006/10/24_10:59:43 info: glib: ucast: started on port 694 inte
rface eth0 to 172.25.16.96
heartbeat[1796]: 2006/10/24_10:59:43 info: glib: ping heartbeat started.
heartbeat[1796]: 2006/10/24_10:59:43 notice: Using watchdog device: /dev/watchdo
g
heartbeat[1796]: 2006/10/24_10:59:43 info: G_main_add_SignalHandler: Added signa
l handler for signal 17
heartbeat[1796]: 2006/10/24_10:59:43 info: Local status now set to: 'up'
heartbeat[1796]: 2006/10/24_10:59:44 info: Link 172.25.16.1:172.25.16.1 up.
heartbeat[1796]: 2006/10/24_10:59:44 info: Status update for node 172.25.16.1: s
tatus ping
heartbeat[1796]: 2006/10/24_11:00:13 WARN: node mysql2: is dead
heartbeat[1796]: 2006/10/24_11:00:13 info: Comm_now_up(): updating status to act
ive
heartbeat[1796]: 2006/10/24_11:00:13 info: Local status now set to: 'active'
heartbeat[1796]: 2006/10/24_11:00:13 info: Starting child client "/usr/lib/heart
beat/ipfail" (100,101)
heartbeat[1796]: 2006/10/24_11:00:14 WARN: No STONITH device configured.
heartbeat[1796]: 2006/10/24_11:00:14 WARN: Shared disks are not protected.
heartbeat[1796]: 2006/10/24_11:00:14 info: Resources being acquired from mysql2.
heartbeat[1820]: 2006/10/24_11:00:14 info: Starting "/usr/lib/heartbeat/ipfail"
as uid 100  gid 101 (pid 1820)
harc[1821]:     2006/10/24_11:00:14 info: Running /etc/ha.d/rc.d/status status
mach_down[1841]:        2006/10/24_11:00:14 info: /usr/lib/heartbeat/mach_down:
nice_failback: foreign resources acquired
mach_down[1841]:        2006/10/24_11:00:14 info: mach_down takeover complete fo
r node mysql2.
heartbeat[1796]: 2006/10/24_11:00:14 info: mach_down takeover complete.
heartbeat[1796]: 2006/10/24_11:00:14 info: Initial resource acquisition complete
(mach_down)
IPaddr[1885]:   2006/10/24_11:00:15 INFO: IPaddr Resource is stopped
heartbeat[1822]: 2006/10/24_11:00:15 info: Local Resource acquisition completed.
harc[1984]:     2006/10/24_11:00:15 info: Running /etc/ha.d/rc.d/ip-request-resp
ip-request-resp
ip-request-resp[1984]:  2006/10/24_11:00:15 received ip-request-resp IPaddr::172
.25.16.188/24/eth0 OK yes
ResourceManager[1999]:  2006/10/24_11:00:15 info: Acquiring resource group: mysq
l1 IPaddr::172.25.16.188/24/eth0 Filesystem::172.25.16.88:/data::/var/lib/mysql:
:nfs mysqld
IPaddr[2023]:   2006/10/24_11:00:16 INFO: IPaddr Resource is stopped
ResourceManager[1999]:  2006/10/24_11:00:16 info: Running /etc/ha.d/resource.d/I
Paddr 172.25.16.188/24/eth0 start
IPaddr[2221]:   2006/10/24_11:00:17 INFO: eval /sbin/ifconfig eth0:0 172.25.16.1
88 netmask 255.255.255.0 broadcast 172.25.16.255
IPaddr[2221]:   2006/10/24_11:00:17 INFO: Sending Gratuitous Arp for 172.25.16.1
88 on eth0:0 [eth0]
IPaddr[2221]:   2006/10/24_11:00:17 INFO: /usr/lib/heartbeat/send_arp -i 500 -r
10 -p /var/run/heartbeat/rsctmp/send_arp/send_arp-172.25.16.188 eth0 172.25.16.1
88 auto 172.25.16.188 ffffffffffff
IPaddr[2139]:   2006/10/24_11:00:17 INFO: IPaddr Success
Filesystem[2375]:       2006/10/24_11:00:18 INFO: Running status for 172.25.16.8
8:/data on /var/lib/mysql
Filesystem[2375]:       2006/10/24_11:00:18 INFO: /var/lib/mysql is unmounted (s
topped)
Filesystem[2311]:       2006/10/24_11:00:18 INFO: Filesystem Resource is stopped
ResourceManager[1999]:  2006/10/24_11:00:18 info: Running /etc/ha.d/resource.d/F
ilesystem 172.25.16.88:/data /var/lib/mysql nfs start
Filesystem[2484]:       2006/10/24_11:00:18 INFO: Running start for 172.25.16.88
:/data on /var/lib/mysql
Filesystem[2484]:       2006/10/24_11:00:19 ERROR: Couldn't mount filesystem 172
.25.16.88:/data on /var/lib/mysql
Filesystem[2420]:       2006/10/24_11:00:19 ERROR: Filesystem Generic error
ResourceManager[1999]:  2006/10/24_11:00:20 ERROR: Return code 1 from /etc/ha.d/
resource.d/Filesystem
ResourceManager[1999]:  2006/10/24_11:00:20 CRIT: Giving up resources due to fai
lure of Filesystem::172.25.16.88:/data::/var/lib/mysql::nfs
ResourceManager[1999]:  2006/10/24_11:00:20 info: Releasing resource group: mysq
l1 IPaddr::172.25.16.188/24/eth0 Filesystem::172.25.16.88:/data::/var/lib/mysql:
:nfs mysqld
ResourceManager[1999]:  2006/10/24_11:00:20 info: Running /etc/init.d/mysqld  st
op
ResourceManager[1999]:  2006/10/24_11:00:20 ERROR: Return code 1 from /etc/init.
d/mysqld
ResourceManager[1999]:  2006/10/24_11:00:21 info: Retrying failed stop operation
[mysqld]
ResourceManager[1999]:  2006/10/24_11:00:21 info: Running /etc/init.d/mysqld  st
op
ResourceManager[1999]:  2006/10/24_11:00:22 ERROR: Return code 1 from /etc/init.
d/mysqld
ResourceManager[1999]:  2006/10/24_11:00:23 info: Retrying failed stop operation
[mysqld]

Answer 1

原帖由 leaper 于 2006-10-25 16:22 发表

可以的，不过你要作好时间同步工作，建个NTP服务器

我的印象当中，mysql不推荐使用nfs,具体原因我不明白

不过你的NTP服务器是什么意思？就是时间同步而已，并没有在文件系统这里有所改进

Answer 2

出错原因可能和/etc/init.d/mysqld有关，我是用yum安装的mysql，用其他的没有出错

Answer 3

原帖由 qlks 于 2006-10-25 15:26 发表
mysql 用nfs好吗？

可以的，不过你要作好时间同步工作，建个NTP服务器

Answer 4

mysql 用nfs好吗？

Answer 5

MySQL的HA集群可以这样做么？

Answer 6

用mount 172.25.16.88:/data /var/lib/mysql却可以mount上，那位大虾知道原因，在线急等！