MYSQL读写分离集群搭建（六）

MYSQL读写分离集群搭建（六）
一、下载并安装keepalived
源码安装，下载安装包并解压
#cd
#wget http://www.keepalived.org/software/keepalived-2.2.1.tar.gz
#tar -zxvf keepalived-2.2.1.tar.gz

安装编译依赖包,不安装依赖包编译不成功
#yum -y install curl gcc openssl-devel libnl3-devel net-snmp-devel libnfnetlink-devel

编译安装成功后,就会自动生成启停服务
#mv keepalived-2.2.1 /opt/
#cd /opt/keepalived-2.2.1
#./configure
#make && make install

二、 创建并编辑配置文件
源码安装默认配置文件路径为: /etc/keepalived/keepalived.conf ,不创建这个文件,不能成功启动
#mkdir -p /etc/keepalived
#vi /etc/keepalived/keepalived.conf
主服务器myha01配置如下
! Configuration File for keepalived
global_defs {
router_id 10
}

vrrp_instance VI_1 {
state MASTER
interface ens33
virtual_router_id 60
priority 100
advert_int 1
nopreempt
authentication {
auth_type PASS
auth_pass p123456
}
virtual_ipaddress {
8.1.3.180
}
}
从服务器myha02配置如下
! Configuration File for keepalived
global_defs {
router_id 20
}

vrrp_instance VI_1 {
state BACKUP
interface ens33
virtual_router_id 60
priority 200
advert_int 1
nopreempt
authentication {
auth_type PASS
auth_pass p123456
}
virtual_ipaddress {
8.1.3.180
}
}

然后配置自启动
#systemctl enable keepalived
#systemctl start keepalived
#systemctl status keepalived
三、 测试keepalived
当前直接访问HAproxy地址的访问信息如下：

在8.1.3.155上的pid是14383
在8.1.3.156上的pid是14452
当keepalived运行时，8.1.3.180地址在myha01上生成
此时访问HAproxy信息如下：

可见访问的是8.1.3.155上面的HAproxy
如果8.1.3.155宕机，或者keepalived服务异常或关闭，则在8.1.3.156上面的keepalived将接管8.1.3.180这个服务IP，此时访问HAproxy信息如下：

访问的就是8.1.3.156上面的HAproxy
四、进行MySQL测试
使用MySQL客户端通过keepalived->HAProxy->Mycat访问数据库
#mysql -umycatroot -pmycatJiapm605A1 -h8.1.3.180 -P3307
mysql> show databases;
mysql> use TESTDB;
mysql> select * from t1;
访问正常