Heartbeat+drbd+mysql的高可用部署

浏览数：31 / 时间：2015年06月12日

Heartbeat+drbd+mysql的高可用
1.规划
   VIP:192.168.1.30
   myhost1:
       内网IP:192.168.1.11
       heartbeat心跳IP:192.168.74.11
       drbd传输IP:192.168.223.11
   myhost2:
       内网IP:192.168.1.12
       heartbeat心跳IP:192.168.74.12
       drbd传输IP:192.168.223.12
2.安装heartbeat
   yum install heartbeat -y

   如果rpm包安装需要安装如下包:
   libnet-1.1.6-7.el5.x86_64.rpm
   libtool-ltdl
   openhpi-libs
   heartbeat-stonith
   heartbeat-pils
3.在/etc/ha.d目录下的配置文件:
   cp /usr/share/doc/heartbeat-2.1.4/ha.cf ./
   cp /usr/share/doc/heartbeat-2.1.4/authkeys ./
   cp /usr/share/doc/heartbeat-2.1.4/haresources ./
   chmod 600 /etc/ha.d/authkeys
   配置ha.cf
   debugfile /var/log/ha-debug
   logfile /var/log/ha-log
   logfacility local0
   keepalive 2
   deadtime 30
   warntime 10
   initdead 120
   udpport 694
   ucast eth2 192.168.74.12
   auto_failback on
   node myhost1
   node myhost2
   crm no
   authkey
       auth 1
       1 sha1 63d40e84c4748d6a7b8ec3581a374a3c
   haresource
       myhost1 IPaddr::192.168.1.30/24/eth0 drbddisk::mdata Filesystem::/dev/drbd0::/dbdata::ext3 rsdata
       #每段的具体执行命令说明:
       #/etc/ha.d/resource.d/IPaddr 192.168.1.30/24/eth0 stop/start
       #/etc/ha.d/resource.d/drbddisk mdata stop/start
       #/etc/ha.d/resource.d/Filesystem /dev/drbd0 /dbdata ext3 stop/start
       #/etc/init.d/rsdata stop/start
4.禁用开机自启动:
   chkconfig heartbeat off

5.安装drbd(redhat 5.8环境)
   wget wget http://oss.linbit.com/drbd/8.4/drbd-8.4.6.tar.gz
   tar -zxvf drbd-8.4.6.tar.gz
   cd drbd-8.4.6
   make
   make install

   wget http://oss.linbit.com/drbd/drbd-utils-8.9.2.tar.gz
   tar -zxvf drbd-utils-8.9.2
   cd drbd-utils-8.9.2
   ./configure --prefix=/usr/local/drbd-utils-8.9.2 --sysconfdir=/etc --with-xen
   make && make install

   如果是centos 6版本的系统,可以执行如下命令:
   yum install drbd83 kmod-drbd83 -y
6.格式化分区:
   mkfs.ext3 /dev/sdb1
   tune2fs -c -1 /dev/sdb1
   meta分区不能格式化,生产环境中一般分配1G-2G空间;

7.配置drbd
   modprobe drbd
   lsmod |grep drbd
   mknod /dev/drbd0 b 147 0
   #配置开机加载:
   echo "modprobe drbd >/dev/null 2>&1" >>/etc/sysconfig/modules/drbd.modules
   chmod 755 /etc/sysconfig/modules/drbd.modules
   mkdir -p /usr/local/drbd-utils-8.9.2/var/run/drbd

   #调整配置文件
   [root@myhost1 ~]# cat /etc/drbd.conf
   global {
       # minor-count 64;
       # dialog-refresh 5; # 5 seconds
       # disable-ip-verification;
       usage-count no;
   }

   common {
   protocol C;

   disk {
       on-io-error   detach;
       no-disk-flushes;
       no-md-flushes;
   }

   net {
       sndbuf-size 512k;
       # timeout       60;    # 6 seconds (unit = 0.1 seconds)
       # connect-int   10;    # 10 seconds (unit = 1 second)
       # ping-int      10;    # 10 seconds (unit = 1 second)
       # ping-timeout   5;    # 500 ms (unit = 0.1 seconds)
       max-buffers     8000;
       unplug-watermark   1024;
       max-epoch-size 8000;
       # ko-count 4;
       # allow-two-primaries;
       cram-hmac-alg "sha1";
       shared-secret "hdhwXes23sYEhart8t";
       after-sb-0pri disconnect;
       after-sb-1pri disconnect;
       after-sb-2pri disconnect;
       rr-conflict disconnect;
       # data-integrity-alg "md5";
       # no-tcp-cork;
   }

   syncer {
       rate 630M;
       al-extents 517;
   }
   }


   resource mdata {
   on myhost1 {
       device    /dev/drbd0;
       disk      /dev/sdb1;
       address   192.168.223.11:7788;
       meta-disk /dev/sdb2 [0];
   }
   on myhost2 {
       device     /dev/drbd0;
       disk       /dev/sdb1;
       address    192.168.223.12:7788;
       meta-disk /dev/sdb2 [0];
   }
   }
   #两个节点同时执行
   drbdadm create-md mdata
   #两个节点执行
   drbdadm up all
   #仅主节点执行
   drbdadm -- --overwrite-data-of-peer primary mdata

   #仅主节点执行
   drbdadm primary all
   ps aux|grep drbd
   mount /dev/drbd0 /dbdata
   cat /proc/drbd
8.heartbeat启动顺序:
   1.启动VIP
   /etc/ha.d/resource.d/IPaddr 192.168.1.30/24/eth0 start
   2.配置drbd资源
   /etc/ha.d/resource.d/drbddisk mdata start
   3.挂载drbd分区
   /etc/ha.d/resource/drbddisk /dev/drbd0 /dbdata ext3 start
   4.启动mysql:
   /etc/ha.d/resource/rsdata start
   5.查看drbd的信息:
   cat /proc/drbd
   6.验证是否正常的检查点:
       VIP,角色,分区挂载
9.主备切换
   /usr/lib64/heartbeat/hb_standby
   /usr/lib64/heartbeat/hb_takeover