CentOS6_Mysql_HA搭建(corosync+pacemaker)概要1.docxVIP

CentOS6.5 Mysql HA安装手册环境规划系统：CentOS 6.5 64bit两台主机名称及Ip:host1(51)host2(52)对外IP（心跳IP）50网关：子网掩码：预定Mysql数据存放位置：/var/lib/mysql_drbd安装步骤安装2台主机，操作系统为CentOS6.5 64bit确认两台主机网卡名一致，如eth0;存放Mysql数据的空间先预留，不进行划分。为了之后的配置文件统一，所以将两台主机的LVM群组改名为一样，并且留下1G为分空间作为Mysql数据空间。（这个空间也可以留在sda上，不过个人认为LVM对扇区的调整较方便。）关闭服务关闭iptables及NetworkManager服务【两台主机】service iptables stop【两台主机】chkconfigiptables off【两台主机】service NetworkManager stop【两台主机】chkconfigNetworkManager off关闭selinux【两台主机】vi /etc/selinux/config将SELUNUX=ENFORCING改为SELINUX=disabled保存退出。修改hosts文件【两台主机】vi /etc/hosts添加如下内容：51 host1 host1.localdomain52 host2 host2.localdomain安装drbd套件安装drbd【两台主机】cd /tmp【两台主机】wget/el6.5-x86_64/atrpms/stable/atrpms-repo-6-7.el6.x86_64.rpm【两台主机】rpm -Uvhatrpms-repo*rpm【两台主机】yum install drbd创建drbd扇区【两台主机】lvcreate -l 100%free -n /dev/vg_host/lv_drbd执行成功后，显示结果：Logical volume lv_drbd created重启主机，使扇区生效。查看扇区命令：lvscan配置drbd现在host1上编写drbd配置文件【host1】mv /etc/drbd.conf /etc/drbd.conf.bak ##将drbd.conf进行备份【host1】cp /etc/drbd.d/global_common.conf /etc/drbd.conf【host1】vi /etc/drbd.conf ##编辑drbd配置文件修改drbd.conf成以下内容：global {usage-count yes; # minor-count dialog-refresh disable-ip-verification}common { protocol C;handlers { # These are EXAMPLE handlers only. # They may have severe implications,# like hard resetting the node under certain circumstances. # Be careful when chosing your poison.pri-on-incon-degr/usr/lib/drbd/notify-pri-on-incon-degr.sh; /usr/lib/drbd/notify-emergency-reboot.sh; echo b /proc/sysrq-trigger ; reboot -f;pri-lost-after-sb /usr/lib/drbd/notify-pri-lost-after-sb.sh; /usr/lib/drbd/notify-emergency-reboot.sh; echo b /proc/sysrq-trigger ; reboot -f;local-io-error /usr/lib/drbd/notify-io-error.sh; /usr/lib/drbd/notify-emergency-shutdown.sh; echo o /proc/sysrq-trigger ; halt -f;fence-peer /usr/lib/drbd/crm-fence-peer.sh; # split-brain /usr/lib/drbd/notify-split-brain.sh root; # out-of-sync /usr/lib/drbd/notify-out-of-sync.sh root; # bef