DRBD+HEARTBEAT+MYSQL安装配置及测试 V 02

1、DRBD+HEARTBEAT+MYSQL 安装配置及测试 V 1.0测试环境：OS： CentOS 5.4 i386 （vmware 下运行）内核版本：2.6.18-164el5（uname -a查看现运行的内核版本）内核源码路径：/usr/src/kernels/2.6.18-164.el5-i686/Mysql 5134heartbeat-3.0.3-2.3drbd-825（现运行内核版本和系统原带内核路径必须一致）ServerOI : ethO 36 eth1 0ServerOI : eth0 37 eth1 1VIP :41SERVICESERVICEu:-t-4-卜4- iBUFFE

2、R CACHEBUFFERCACHEE-冷FILE SYSTEMFILE SYSTE MRAW DEVICETCR/IPSTRAW DEVICETTCR/IPE JSERVICESERVICEu:-t-4-卜4- iBUFFER CACHEBUFFERCACHEE-冷FILE SYSTEMFILE SYSTE MRAW DEVICETCR/IPSTRAW DEVICETTCR/IPE JE : -4DUSK 5-IiCHED j4*DISK DRIVERDISK SCHEDDISK DRIVERNIC DRIVERNIC DRIVERDISKDISKNICNIC一.下载源代码，推荐使用源代码。

3、因为使用yum安装时在安装kmod-drbd组件是会升级内核，这会导致无法加载drbd 模块到内核，（此问题我还没解决）Yum 安装命令 # yum install drbd kmod-drbd源码下载地址： HYPERLINK /drbd/ /drbd/wget HYPERLINK http:/oss.linbit.eom/drbd/8.2/drbd-8.2.5.tar.gz http:/oss.linbit.eom/drbd/8.2/drbd-8.2.5.tar.gztar xvf drbd-8.2.5.tar.gzcd drbd-8.2.5make KDIR=/usr/src/kerne

4、ls/2.6.18-164.el5-i686/make install KDIR=/usr/src/kernels/2.6.18-164.el5-i686/这样就算安装完毕了。检查一下需要有drbd、drbdadm、drbdmeta、drbdsetup这四个命令、以及启动脚本： /etc/init.d/drbd并保证drbd模块已经加载到内核中了#lsmod I grep drbd入drbd193796 3主配置文件在：/etc/drbd.conf将drbd服务加入到启动项中# chkconfig drbd on 二配置环境以上操作在server01和server02中进行，2个主机都预留一个

5、空白的分区，不需要创建任何文件系统。在 server。1中vim /etc/hosts:1localhost.localdomain localhostIocalhost6.1ocaldomain6 localhost63637server01server02并保证 vim /etc/sysconfig/network NETWORKING=yes NETW0RKING_IPV6=noHOSTNAME=server01在 server02 中vim /etc/hosts:1localhost.localdomain localhostlocalhost6.localdomain6 localh

6、ost636server0137server02并保证 vim /etc/sysconfig/network NETWORKING=yesNETWORKING_IPV6=noHOSTNAME=server02主配置文件内容：# vim /etc/drbd.conf#是否参加DRBD使用者统计默认是yesglobal usage-count yes;#设置主备节点同步时的网络速率最大值,单位是字节.common syncer rate 10M; # 一个DRBD设备(即:/dev/drbdX)，叫做一个资源.里面包含一个DRBD设备的主备 节点的#相关信息.resource r0 #使用协议C.

7、表示收到远程主机的写入确认后，则认为写入完成.protocol C;#startup wfc-timeout 0; degr-wfc-timeout 120; disk on-io-error detach; syncer rate 10M; net #设置主备机之间通信使用的信息算法.cram-hmac-alg shal; shared-secret FooFunFactory;#每个主机的说明以on开头,后面是主机名在后面的中为这个主机的配置.on server01# /dev/drbdl使用的磁盘分区是/dev/hdbldevice/dev/drbdl;disk/dev/sdc5;#设置

8、DRBD的监听端口，用于与另一台主机通信address 36:7898;#address 94:7898;#meta-disk /dev/xvdb50;meta-disk internal;#flexible-meta-disk internal;on server02 device/dev/drbd1;disk/dev/sdb5;address 37:7898;#address 95:7898;meta-disk internal;#meta-disk /dev/xvdb50;#flexible-meta-disk internal;准备启动之前，需要分别在2个主机上的空白分区上创建相应的元

9、数据保存的数据块:常见之前现将两块空白分区彻底清除数据分别在两个主机上执行#dd if=/dev/zero of=/dev/sdbX bs=1M count=128否则下一步会出现Device size would be truncated, which would corrupt data and result inaccess beyond end of device errors.You need to eitheruse external meta data (recommended)shrink that filesystem firstzero out the device (de

10、stroy the filesystem)Operation refused.分别在serverOl和server02上面执行#drbdadm create-md r0确保成功后，接下来就可以启动drbd进程了 (在serverOl和server02同时启用): 在 server02 中rootserver01 # /etc/init.d/drbd startStarting DRBD resources: d(r0) s(r0) n(r0). rvmrOl/etc/i nit. d/drbci startEtarti门g DRBD r已ur匸已玉：日rO)门rO)rootserver01 #

11、 ps aux I grep drbdroot5777000.000 ?S11:120:00 drbd1_workerroot5780000.000 ?S11:120:00 drbd1_receiverroot5790000.000 ?S11:120:00 drbd1_asenderr ooti&se r/ErO2# ps auxgrmpdrbdrcicit44650. 00. 00Q 7510:45drbdl_workerrcicit44660. 00. 00Q 7310:45cir bdl_己亡己厲炉己rr oot52840. 00. 00Q 7S11:12cir bdl_asende r

12、rootserver01 # cat /proc/drbdversion: 8.2.5 (api:88/proto:86-88)GIT-hash: 9faf052fdae5ef0c61b4d03890e2d2eab550610c build by rootserver01, 2011-12-02 10:00:191: cs:Connected st:Secondary/Secondary ds:Inconsistent/UpToDate C r- ns:0 nr:0 dw:0 dr:0 al:0 bm:0 lo:0 pe:0 ua:0 ap:0resync: used:0/31 hits:0

13、misses:0 starving:0 dirty:0 changed:0 act_log: used:0/127 hits:0 misses:0 starving:0 dirty:0 changed:0在 server02 上rootserver02 /# /etc/init.d/drbd startStarting DRBD resources: d(r0) s(r0) n(r0). rvmr02 /# /etc/i nit. d/drbci startgta门g DRBD r已二口ur匚es :日rO)门rO) rootserver02 # ps aux |grep drbdroot44

14、650.00.000 ?S10:450:00 drbd1_workerroot4466000.000 ?S10:450:00 drbd1_receiverroot5284000.000 ?S11:120:00 drbd1_asenderr ootSse rgr 02# ps aux |grmpdrbdr oot44650.0 0. 0 0q 7510:45drbdl_workerr oot44660.0 0. 0 0Q 7510:45cir bdl_ rwyiJE rr oot52840.0 0. 0 0Q 7511:12cir bdl_asende rrootserver02 # cat /

15、proc/drbdversion: 8.2.5 (api:88/proto:86-88)GIT-hash: 9faf052fdae5ef0c61b4d03890e2d2eab550610c build by rootserver02, 2011-12-02 09:56:191: cs:Connected st:Primary/Secondary ds:UpToDate/Inconsistent C r- ns:0 nr:0 dw:0 dr:0 al:0 bm:0 lo:0 pe:0 ua:0 ap:0resync: used:0/31 hits:0 misses:0 starving:。dir

16、ty:0 changed:。 act_log: used:0/127 hits:0 misses:0 starving:0 dirty:0 changed:0三.启动server01为主节点#drbdadm primary db这一步可能会报错误如果保持执彳丁drbdsetup /dev/drbdl primary -A可以看到，第一次设置主节点时用drbdadm命令会失败，所以先用drbdsetup来做，以后 就可以用drbdadm 了成功后，就可以使用#cat /proc/drbd查看同步的进度了rootserver01 # cat /proc/drbdversion: 8.2.5 (ap

17、i:88/proto:86-88)GIT-hash: 9faf052fdae5ef0c61b4d03890e2d2eab550610c build by rootserver01, 2011-12-02 10:00:191: cs:SyncSource st:Primary/Secondary ds:UpToDate/Inconsistent C r- ns:1830912 nr:0 dw:0 dr:1830912 al:0 bm:111 lo:0 pe:0 ua:0 ap:0=synced: 35.1% (3326/5114)Mfinish: 0:04:43 speed: 11,940 (1

18、0,344) K/secresync: used:0/31 hits:114320 misses:112 starving:。dirty:0 changed:112act_log: used:0/127 hits:0 misses:0 starving:0 dirty:0 changed:0root5ecat /proc/drhciversion: 8.2.5 (api:88/proto:86-88)GlT-hash:afO52fdae5efQc61b4d03 890e2d2eab55Q61Qc bui 1 d by roott&serverOl, 2011-12-021: cs : sync

19、sou rue st: P rrmary ds : upToDat e/l neons i st ent c rns:2037760 nr:Q dw:0 dr:2037760 al:Q bm:124 1:Q pe:0 ua:0 ap:Q =synced: 39. 0% C3124/5114)Mfi ni sh: 0:04:26 speed: 11,940 (10? 340) K/sec r esync: used: Q/31 hits :12723 5 mi sses :12 5 st a rdng:Q 日 Tr ty: 0 changed :12 5 acr_log: used:0/127

20、hits :Q misses :Q starMng:。日rrty:0 changed:0同步完毕:roorerver 01# cat /proc/dr bdver si on : 8.2.5 (.dpi : 88/prutri: 36-88)GIT-hash : 9f df 0 5 2f d.elp 5 ef 0c61 b4 d03 890p2 d2 pab 5 5 0610c bui 1 d by rnnr&sprvprOl, 2011-12-02 10 : 00:19 1: cs : 5yn c 5 our ce st: P r i ma r y./s pc u nd -el r y d

21、s : u pT o D at p/i n c o nsl stent 匚 rns : 52 36736 nr : 0 dw: 0 dr : 5236736 dl : 0 bm : 31 y 1 u : 0 pp : 0 lj.el : 0 ap : 0 =s ync 1 pd : 100. 0% C0/5114 jP-l flni sh:0:Q0:00 spppd:10,S48(10,348j K/V臼二resync: used: 0/31 hits : 326976 nil sses : 320 stdrvi nq : 0 di rty: 0 ch-inged : 320lie eel:

22、0/12 7 h/ifO 亦注巳：0 1：3厂肿 门日补*iEmgEcl:匚厂此过程有点慢，(我测试的512M内存，intel E2220 vmware 7.14环境，5G的磁盘同步了 16 分钟)同步完毕之后，就可以对空白磁盘格式化了 (注意此操作只对primary节点格式化)rootserver01 # mkfs.ext3 /dev/drbd1mke2fs 1.39 (29-May-2006)Filesystem label=OS type: LinuxBlock size=4096 (log=2)Fragment size=4096 (log=2)655360 inodes, 13092

23、32 blocks65461 blocks (5.00%) reserved for the super userFirst data block=0Maximum filesystem blocks=134217728040 block groups32768 blocks per group, 32768 fragments per group16384 inodes per groupSuperblock backups stored on blocks:32768, 98304, 163840, 229376, 294912, 819200, 884736Writing inode t

24、ables: doneCreating journal (32768 blocks): doneWriting superblocks and filesystem accounting information: doneThis filesystem will be automatically checked every 35 mounts or 180 days, whichever comes first. Use tune2fs -c or -i to override.然后将格式化好的磁盘挂在到/drbd下测试：现在演示一下主节点挂掉，然后重新恢复连接的情况，通过以上的设置我们知道

25、server01 ( 36)为 primary 节点rootserver01 # ifdown eth0ErootOseruerBl cat /proc/drbduersion: 8.Z.5 (api：88/proto:86-88)GIT-hash: 9faf05ZfdaeSef0c61b4d03890eZdZeab550610c buiId by rootOseruerBl, Z011- 1Z-0Z 10:00:191: cs:StandAlone gt：Frimary/Unknown ds:UpToDate/DUnknown rns:5451816 nr:0 du：Z14888 dr:5Z

26、37117 a 1：73 bm:3Z0 lo:0 pe:0 ua:8 ap:0 resync: used:0/31 hits：326988 misses:3Z8 gtaruing:0 dirty:0 changed:3Z0 log： used:0/1Z7 hits：53649 misses:75 staruing:0 dirty:Z changed:73 roo亡rverBl 1#可以看到，在primary节点上找不到secondary节点了。再来看看secondary节点上的状态:ruorervpfu2 二# 匚Mt /proc/drbdver si un : ；3 2 5 (dpi : B

27、S/pruto : 86-88；)GlT-hash: 9fafO52fdae5ef0c61b4d03890e2d2eab550610c build by rootserver02, 2011-12-02 09:56:191: cs:WFconnect1 on st:secondary/unknown ds:upToDate/DUnknown c rns : 0 nr : 54 51816 dw: 54 51816 dr : 0 al : 0 brn : 3 2 0 1 o : 0 pp: 0 ua : 0 dp: 0 re sync : used : 0/31 hits : 326988 ni

28、l sses : 320 st-irvi nq : 0 di rty: 0 changed: 320 dCT-l og : used : 0/12 7 hits : 0 nil ssps: 0 srarvi ng: 0 di rry:0 crianged : 0 匚|匚|谄曰飞佗0厂#-在secondary节点上也找不到primary 了 现在，让prmary节点的网卡启动ErootOseruerBl 1# ifup eth0roo1# cat zproc/drbduersion: 8.2.5 (ap i：88/proto:86-88)GIT-hash: 9faf05Zfdae5ef0c61b

29、4d03890eZdZeab550610c build by rooZ011- 1Z-0Z 10:00:191: cs : Standalone st：Pr imary/Unknown ds:UpToDate/DUnknown rns:5451816 nr:0 du：214888 dr:5Z37117 a 1：73 bm:320 lo:0 pe:0 ua:0 ap:0 resync: used:0/31 hits：3Z6988 misses:3Z0 staruing:0 dirty:0 changed:3Z0 act_log: used:0/1Z7 hits：53649 misses:75 s

30、taruing:0 dirty:Z changed:73 ErootSseruerBl 1#还是未连接状态。在刚才关闭网卡的primary节点上执行如下命令:routprver01 -J#Last 1ogi n: Sdt Dec 3 16:20:2b 2011 fr om 34root s e r v er 01 - # dr b d a dm c o n n ect rOrootserver01 -# cat /proc/drbdver si on: 8 2 5 (dpi:88/pruTo:86-88jGIT-hash: 9fafO52fdaeSef0c61b4d03890e2d2eab55

31、0610c build by rootserver01, 2011-12-02 10:00:191: cs :匚匚Innected 1: cs :匚匚Innected sr:primary/5econdary ri5：0 nr：U dw: 214888 dr : 5237117 d I : resyn匚：used:0/31 hits:326988 且匚t-log: used:0/127 hits:53649 routerver01#as : IJpTODdt p/UpTODdt73 brn: 3 2 0 1 o : 0 pe : 0 nil sses : 320 starvi ngnil ss

32、es : 75 stdrvi nq.elu o or:0 .ip: 0di rty： 0di rty ： 2changed:3 2 0chanqed:73可以看到主节点已经连接到了 secondary节点同样去secondary节点server02上使用cat命令查看一下连接情况 _i - - - - - - -Iroot5Prver02 # cat /pruc/drbdversion : 8 2 5 Cpi : 88/prorri: 86-88；GlT-hash: 9fafO52fdaeSef0c61b4d03890e2d2eab5 50610c bul 1 d by rootserver0

33、2, 2011-12-02 09:56:19o o m -p./-_d r- - r r o ._1 o1: cs :Connected st: 5e匸厂i日且ry/Primary ds : UpToD.ite/UpToDate C ns : 0 nr : 54 51816 dw: 54 51816 dr : 0 dl : 0 brn : 3 2 0 1 u : 0 pe : 0 ua rpsync: used:0/31 hits:326988 mi sses:320 starvi ng:0 且匚t-l og : used o o m -p./-_d r- - r r o ._1 o查看连接情

34、况可以直接使用rootserver01 # drbdadm state r0Primary/Secondaryrootserver01 # drbdadm cstate r0Connectedrootserver01 # drbdadm dstate r0UpToDate/UpToDate同样可以使用常用命令rootserver01 # service drbd statusdrbd driver loaded OK; device status:version: 8.2.5 (api:88/proto:86-88)GIT-hash: 9faf052fdae5ef0c61b4d03890e2d

35、2eab550610c build by rootserver01, 2011-12-0210:00:19m:res csstdsp mounted fstype1:r0 Connected Primary/Secondary UpToDate/UpToDate C /drbdext3如果是secondary节点挂掉了，它恢复正常后，想要再次连接primary节点的话，考虑到可 能会有数据丢失，可以采用以下方式来连接：rootserver02 # drbdadmin - -discard-my-data connect A r0它告诉drbd，secondary节点上的数据可能是不正确的，要以

36、primary节点上的为准。这个命 令只能在secondary节点上使用，毕竟数据是以primary节点为准的，而非secondry节点。不过，如果是primary节点挂掉了，这个时候就应该把原来的secondary节点提升为primary 的角色，等原来的primary恢复之后，只能先降级成为secondary节点了，否则是无法再次 正确连接另一个节点的。同步结果测试在serverOl上做如下操作；rootserver01 home# cp mysql-5.1.60.tar.gz /drbd/rootserver01 home# ls /drbd/lost+found mysql-5.1.6

37、0.tar.gz 然后，我们把 primary 降级成 secondary， 把 secondary 提升成 primary 注意：把primary降级前，一定要先umount设备才行。rmrumrOl home# umount /cirbd/rm at 駅 m rumrOl home# cir bdadm seconda ry rOr ootf&se然后提升secondary：r ootf&secJrbdadm primary rO mount /dev/drbcJlIs /drbd/cJrbdadm icJrbdadm primary rO mount /dev/drbcJlIs /drb

38、d/r ootf&se r/ErO2 r ootf&se r/ErO2 r ootf&se r/ErO2mysql-5.1.60.tar.gzrootserver02 # I可以看在server01上写入的文件mysql-5.1.60.tar.gz已经同步到server02上。 测试成功！切换回到之前的server01为primary server02为secondary操作为： 首先在server02上ruuTi&servpr02 -# umriunt /drbd/匸ii:駆朮h匚怡帥 三曰二匚i门匚曲y0接着在server01上rci ot(&5e rvmrOl rci ot(&5e rv

39、mrOlmount /dev/drbdl /drbd/ Is /drbd/.qzrciotservErOl home# cJrbdadm secondary rO 丁口ot(&5ervmrOl home# cJrbdadm primary rO -rci ot(&5e rvmrOl rci ot(&5e rvmrOlmount /dev/drbdl /drbd/ Is /drbd/.qzhome# home# mysql-5.1.60.tar-一|*需要注意的是切换回来后检查一下drbd的状态:ruorptver01 hump# /ptc/I nit.d/drbd sr atusdrbd dr

40、iver 1oaded OK； device status:ver si rm: 8.2.5 (api:S8/proto:86-S8)GlT-hash: 9fafO52fdaeSefOc61b4d03890e2d2eab550610c bu11d by rootserver01, 2011-12-02 10:00:19 rn: rescsstdspriiuuntedf stype1:r0connpctedPr1 mary/spcunddryupT uD atp/upT o Dater/drbdpxt3匚i t 已已01 h 口已#rootserver01 home# ps aux | grep

41、 drbdroot99403.00. 00Q 7515:372:32drbdl_workerroot1164 50. 90. 00Q 7516:210:22jcir bdl_ rmyivE rroot1164 60. 00. 00Q 7516:210:01grbdl_asenderroot128650. 00.14160664 pts/IR.+17:000:00grmp 日rtd匚比匪 Eu 已01 h Ml E #四.Dual-primary mode (双主模式)(测试中)多主模式To enable dual-primary mode, set the allow-two-primarie

42、s option to yes in the net section of your resource configuration: resource net allow-two-primaries yes;.secondary五处理DRBD脑裂的办法首先对secondary节点操作，确保其为secondary节点#drbdadm secondary r0#drbdadm discard-my-data connect r0#drbdadm connect r0六整合 heartbeat+rdbd+mysql1安装 heartbeat：主节点server01rootserver01 # vim

43、 /etc/hostslocalhost.localdomain localhost:1localhost6.localdomain6 localhost6360137server01 HA01HA01HA02server02从节点server02rootserver02 # vim /etc/hostslocalhost.localdomain localhost:1localhost6.localdomain6 localhost6370136server02 HA02HA01HA02server01使用yum安装Heartbeat（主从都需安装）yum install libnet -y

44、yum install heartbeat-devel -yyum install heartbeat-ldirectord -yyum install heartbeat -y cp /usr/share/doc/heartbeat-2.1.4/ha.cf /etc/ha.d/cp /usr/share/doc/heartbeat-2.1.4/authkeys /etc/ha.d/cp /usr/share/doc/heartbeat-2.1.4/haresources /etc/ha.d/配置心跳的加密方式:authkeys （主从相同）vi /etc/ha.d/authkeysauth

45、11 shal dhTVvXdPKlajFFwsdxkvmtiP95mjvRCw #1 shal sha1_any_password#2 crc#3 md5 md5_any_password #authkeys文件用于设定Heartbeat的认证方式，共有3种可用的认证方式，即crc、md5和 sha1。#3种认证方式的安全性依次提高，但是占用的系统资源也依次增加。如果Heartbeat集群运 行在安全的网络上，#可以使用crc方式；如果HA每个节点的硬件配置很高，建议使用sha1，这种认证方式安 全级别最咼；#如果是处于网络安全和系统资源之间，可以使用md5认证方式。#需要说明的一点是：无论

46、auth后面指定的是什么数字，在下一行必须作为关键字再次出 现，#例如指定了auth 6，下面一定要有一行6认证类型配置心跳的监控（主从相同）vi /etc/ha.d/haresourcesserver01 IPaddr:41/24/eth0 drbddisk:rO Filesystem:/dev/drbd1:/drbd:ext3 mysqld配置心跳的配置文件：ha.cf （主从相同）logfile /var/log/ha-log.log#logfacility localO keepalive 2warntime 20deadtime 30initdead 240#heartbeat的日志

47、文件#设置heartbeat的日志，这里采用系统日志#每两次检测之间的时间间隔#连续多久联系不上后开始报警提示#连续多久联系不上后认为对方挂掉了#给系统重启预留的忽略时间，就是系统重启后多久进行检测心跳udpport 694 auto_failback on#使用udp端口 694进行心跳监测#是否恢复到它的primary节点#ubast eth1ucast eth1 1#采用eth1的udp广播来发送心跳信息node server01node server02ping #通过ping网关检测心跳是否正常hopfudge 1 udpport 694 auto_failback on#使用udp

48、端口 694进行心跳监测#是否恢复到它的primary节点#crm respawn#compression bz2#compression_threshold 20#traditional_compression on#respawn hacluster /usr/lib/heartbeat/dopd#apiauth dopd gid=haclient uid=hacluster#respawn root /usr/lib/heartbeat/mgmtd -v#apiauth mgmtd uid=root注意：主节点为 ucast eth1 1 从节点为 ucast eth1 1开机自启动ch

49、kconfig -levels 345 heartbeat on2安装mysql 5134wget ftp:/software:xiazai1239/mysql/mysql-5.1.43.tar.gz tar zxvf mysql-5.1.43.tar.gzcd mysql-5.1.43#cp BUILD/compile-pentium-icc ./compile#sh BUILD/autorun.sh#sh BUILD/compile-pentium64-max./configure -prefix=/usr/local/mysql -localstatedir=/home/mysql -w

50、ith-comment=Source -with-server-suffix=-Community-Server -with-mysqld-user=mysql -without-debug -with-big-tables -with-charset=utf8 -with-extra-charsets=all -with-pthread -enable-static -enable-thread-safe-client -with-client-ldflags=-all-static -with-mysqld-ldflags=-all-static -enable-assembler mak

51、e&make installgroupadd mysqluseradd -g mysql -s /sbin/nologin mysqlchown -R root /usr/local/mysqlchgrp -R mysql /usr/local/mysql./scripts/mysql_install_db -user=mysql -datadir=/home/mysql chgrp -R mysql /usr/local/mysqlchown -R mysql /home/mysqlchgrp -R mysql /home/mysql/ wget ftp:/software:xiazail2

52、39/mysql/my.txtcp /root/my.txt /drbd/mysql/mycnf#为了保证IP漂移后，接管mysql服务的在线服务ln -s /drbd/mysql/f /etc/mycnf#器可以作为mysql主从模式为从机提供服务,#misqi的配置文件必须唯一cp /usr/local/mysql/share/mysql/mysql.server /etc/rc.d/init.d/mysqldchmod +x /etc/rc.d/init.d/mysqldservice mysqld startln -s /usr/local/mysql/bin/mysql /usr/b

53、in/mysqlmysqlmysqlshow engines;mysqlupdate mysql.user set password=password(123456) where user=root; mysql flush privileges;mysql q停掉mysql服务cp -pr /home/mysql/ /drbd/更改mysqlserver的数据库文件所在的目录为/drbd/mysql 在/etc/f 增加 datadir =/drbd/mysql# vim /etc/fclient port socket=3306client port socket=3306=/tmp/my

54、sql.sock=3306=/drbd/mysql=/tmp/mysql.sock# The MySQL server mysqld port =3306=/drbd/mysql=/tmp/mysql.sock=max_connections=10000=max_connect_errors=99999=max_connections=10000=max_connect_errors=99999long_query_time=llog_slow_queries=/var/tmp/mysql_slow.logmysqldumpquickmax_allowed_packet = 16Mmysqln

55、o-auto-rehashisamchkkey_buffer = 8Msort_buffer_size = 8Mmyisamchkkey_buffer = 8M对于主节点可将mysql加入开机启动中，从节点不可加入开机启动七.测试 heartbeat+drbd+mysql在server01査看一下服务器状态rootserver01 # ifconfigeth0 Link encap:Ethernet HWaddr 00:0C:29:FF:51:07inet addr:36 Bcast:55 Mask: inet6 addr: fe80:20c:29ff:feff:5107/64 Scope:L

56、inkUP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:825280 errors:15789 dropped:。overruns:。frame:。TX packets:850237 errors:。dropped:。overruns:。carrier:。 collisions:。txqueuelen:1。RX bytes:270828284 (258.2 MiB) TX bytes:155779682 (148.5 MiB) Interrupt:193 Base address:0 x2024eth0:0 Link enc

57、ap:Ethernet HWaddr 00:0C:29:FF:51:07inet addr:1921680141 Bcast:55 Mask: UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 Interrupt:193 Base address:0 x2024eth1 Link encap:Ethernet HWaddr 00:0C:29:FF:51:11inet addr:。 Bcast:55 Mask:inet6 addr: fe80:20c:29ff:feff:5111/64 Scope:LinkUP BROADCAST RUNNING

58、MULTICAST MTU:1500 Metric:1RX packets:6176 errors:0 dropped:0 overruns:0 frame:0TX packets:6410 errors:0 dropped:0 overruns:0 carrier:0 collisions:。txqueuelen:1。RX bytes:1461161 (1.3 MiB) TX bytes:1514970 (1.4 MiB)Interrupt:193 Base address:0 x20a4loLink encap:Local Loopbackinet addr: Mask:inet6 add

59、r: :1/128 Scope:HostUP LOOPBACK RUNNING MTU:16436 Metric:1RX packets:23485 errors:0 dropped:。overruns:。frame:。TX packets:23485 errors:0 dropped:0 overruns:0 carrier:0 collisions:。txqueuelen:。RX bytes:6286591 (5.9 MiB) TX bytes:6286591 (5.9 MiB)rootserver01 # /etc/init.d/heartbeat statusheartbeat OK

60、pid 31582 et al is running on server01 server01.rootserver01 # /etc/init.d/drbd statusdrbd driver loaded OK; device status:version: 8.2.5 (api:88/proto:86-88)GIT-hash: 9faf052fdae5ef0c61b4d03890e2d2eab550610c build by rootserver01, 2011-12-0210:00:19m:res csstdsp mounted fstype1:r0 Connected Primary