mycat高可用，keepalived+haproxy

高可用mycat结构拓扑图

 

 

主机配置

角色	IP地址
Proxy Master	192.168.137.54
Proxy Backup	192.168.137.53
Mycat Server 1	192.168.137.52
Mycat Server 2	192.168.137.51

 

 

第一部分 mycat主机监听mycat是否存活

1.       为mycat server 1 和mycat server 2 安装xinetd服务

yum  –y  install  xinetd

2.       编辑检测mycat的脚本

/usr/local/bin/mycat_status

脚本内容

 

3.       在/etc/services中添加mycat_status服务

#echo  “mycat_status        48700/tcp         #mycat_status”  >>  /etc/services

#service  xinetd  restart

 

4.       验证mycat_status服务是否启动成功

 

 

第二部分 为Proxy Master和Proxy Backup安装keepalived

1.         安装openssl

yum  -y  install  openssl , opensll-devel

 

2.         安装keepalived

           i.              解压“keepalived-1.2.13.tar.gz”

#tar  zxvf  keepalived-1.2.13.tar.gz

 

         ii.              编译安装keepalived

#cd  keepalived-1.2.13

#./configure --prefix=/usr/local/keepalived

#make  &&  make install

 

        iii.              设置开机自启和初始化

#cp /usr/local/keepalived/sbin/keepalived  /usr/sbin/

#cp /usr/local/keepalived/etc/sysconfig/keepalived  /etc/sysconfig/

#cp /usr/local/keepalived/etc/rc.d/init.d/keepalived  /etc/init.d/

#mkdir  /etc/keepalived

#cd  /etc/keepalived/

#cp  /usr/local/keepalived/etc/keepalived/keepalived.conf  /etc/keepalived

#mkdir  -p  /usr/local/keepalived/var/log

#mkdir  /etc/keepalived/scripts

 

3.         keepalived配置

新建 /etc/keepalived/keepalived.conf 配置文件

文件内容：

Mater（192.168.137.54）

 

 

Backup（192.168.137.53）

 

 

4.         check_haproxy.sh

脚本含义：如果没有haproxy进程存在，就启动haproxy，停止keepalived

 

5.         haproxy_master.sh

 

 

6.         haproxy_backup.sh

 

 

7.         haproxy_fault.sh

 

 

8.         haproxy_stop.sh

 

 

9.         启动keepalived服务

# service keepalived start

 

10.     验证VIP

 

 

第三部分 为Proxy Master和Proxy Backup安装haproxy

1.       新增haproxy用户

# useradd haproxy

 

2.       安装haproxy

           i.              解压haproxy-1.4.25.tar.gz

# tar  zxvf  haproxy-1.4.25.tar.gz

 

         ii.              编译安装

# tar zxvf haproxy-1.4.25.tar.gz

# cd haproxy-1.4.25

# make TARGET=linux26 PREFIX=/usr/local/haproxy ARCH=x86_64

# make install PREFIX=/usr/local/haproxy

        iii.              更改用户组

#chown  -R  haproxy  /usr/local/haproxy

 

3.       新建配置文件haproxy.cfg

/usr/local/haproxy/harpxy.cfg

 

 

 

4.       配置haproxy日志

           i.              安装syslog模块

#yum  –y  install  rsyslog

         ii.              新建haproxy.conf配置文件

#touch /etc/rsyslog.d/haproxy.conf

文件内容：

$ModLoad imudp

$UDPServerRun 514

local0.*  /var/log/haproxy.log

        iii.              编辑/etc/rsyslog.conf

在#### RULES ####上面一行的地方加入以下内容：

# Include all config files in /etc/rsyslog.d/

$IncludeConfig /etc/rsyslog.d/*.conf

#### RULES ####

如果yum安装rsyslog，这应该已经存在了

        iv.              在/var/log/boot.log文件末尾加上下面内容

# Save boot messages also to boot.log

local7.*                         /var/log/boot.log

local0.*                         /var/log/haproxy.log

         v.              保存，重启rsyslog

#service  rsyslog  restart

5.       启动haproxy

#/usr/local/haproxy/sbin/haproxy -f /usr/local/haproxy/haproxy.cfg

日志/var/log/haproxy.log

Master(192.168.137.54)

 

Backup(192.168.137.53)

 

 

集群集群至此搭建完成。

 后面需要进行测试………………