MySQL集群——Keepalived实现双机热备

上一章

 

上一章 已经说明 如何安装Haproxy

首先运行 Haproxy

docker run -it -d -p 4001:8888 -p 4002:3306 -v /home/soft/haproxy:/usr/local/etc/haproxy --name h1 --privileged --net=net1 --ip 172.18.0.7 haproxy

docker exec -it h1 bash #进入容器

haproxy -f /usr/local/etc/haproxy/haproxy.cfg  #加载配置

docker run -it -d -p 4003:8888 -p 4004:3306 -v /home/soft/haproxy:/usr/local/etc/haproxy --name h2 --privileged --net=net1 --ip 172.18.0.8 haproxy


docker exec -it h1 bash #进入容器


haproxy -f /usr/local/etc/haproxy/haproxy.cfg

 

然后进入容器

Haproxy容器内安装Keepalived，设置虚拟IP

#进入h1容器
docker exec -it h1 bash
#更新软件包
apt-get update
#安装VIM
apt-get install vim
#安装Keepalived
apt-get install keepalived
#编辑Keepalived配置文件（参考下方配置文件）
vim /etc/keepalived/keepalived.conf
#启动Keepalived
service keepalived start
#宿主机执行ping命令
ping 172.18.0.201

然后进入 容器h2 一样的操作

 

配置文件

vrrp_instance  VI_1 {
        state  MASTER
        interface  eth0
        virtual_router_id  51
        priority  100
        advert_int  1
        authentication {
            auth_type  PASS
            auth_pass  123456
        }
        virtual_ipaddress {
            172.18.0.201
        }
    }

宿主机执行安装Keepalived 

yum -y install keepalived

#修改Keepalived配置文件
vi /etc/keepalived/keepalived.conf

启动Keepalived
service keepalived start

配置文件

vrrp_instance VI_1 {
    state MASTER
    interface ens33
    virtual_router_id 51
    priority 100
    advert_int 1
    authentication {
        auth_type PASS
        auth_pass 1111
    }
    virtual_ipaddress {
       	192.168.2.200 #这里的ip 是对应自己的服务器ip 字段 我的是192.168.2.111 所有都需要在192.168.2中
    }
}


virtual_server 192.168.2.200 8888 {
    delay_loop 3
    lb_algo rr 
    lb_kind NAT
    persistence_timeout 50
    protocol TCP

    real_server 172.18.0.201 8888 {
        weight 1
    }
}


virtual_server 192.168.2.200 3306 {
    delay_loop 3
    lb_algo rr 
    lb_kind NAT
    persistence_timeout 50
    protocol TCP

    real_server 172.18.0.201 3306 {
        weight 1
    }
}

 

访问http://192.168.2.200:8888/dbs

如果访问不了 因为他是vrr协议 关闭防火墙

systemctl stop firewalld.service