免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 1813 | 回复: 6
打印 上一主题 下一主题

请教MySQL双机HA时不能mountNFS服务器上的数据库的问题 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2006-10-24 11:38 |只看该作者 |倒序浏览
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]

论坛徽章:
0
2 [报告]
发表于 2006-10-24 13:18 |只看该作者
用mount 172.25.16.88:/data /var/lib/mysql却可以mount上,那位大虾知道原因,在线急等!

论坛徽章:
0
3 [报告]
发表于 2006-10-25 00:55 |只看该作者
MySQL的HA集群可以这样做么?

论坛徽章:
1
数据库技术版块每日发帖之星
日期:2016-03-12 06:20:00
4 [报告]
发表于 2006-10-25 15:26 |只看该作者
mysql 用nfs好吗?

论坛徽章:
0
5 [报告]
发表于 2006-10-25 16:22 |只看该作者
原帖由 qlks 于 2006-10-25 15:26 发表
mysql 用nfs好吗?


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

论坛徽章:
0
6 [报告]
发表于 2006-10-25 17:35 |只看该作者
出错原因可能和/etc/init.d/mysqld有关,我是用yum安装的mysql,用其他的没有出错

论坛徽章:
1
数据库技术版块每日发帖之星
日期:2016-03-12 06:20:00
7 [报告]
发表于 2006-10-30 15:38 |只看该作者
原帖由 leaper 于 2006-10-25 16:22 发表


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


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

不过你的NTP服务器是什么意思?就是时间同步而已,并没有在文件系统这里有所改进
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP