zabbix mysql集群_zabbix高可用搭建--数据库集群（2）

virtual_server 192.168.1.157 3306 {

delay_loop 6

lb_algo wrr

lb_kind DR

nat_mask 255.255.255.0

persistence_timeout 50

protocol TCP

real_server 192.168.1.154 3306 {

weight 1

TCP_CHECK {

connect_port 3306

connect_timeout 3

nb_get_retry 3

delay_before_retry 3

}

}

real_server 192.168.1.155 3306 {

weight 1

TCP_CHECK {

connect_port 3306

connect_timeout 3

nb_get_retry 3

delay_before_retry 3

}

}

real_server 192.168.1 3306 {

weight 1

TCP_CHECK {

connect_port 3306

connect_timeout 3

nb_get_retry 3

delay_before_retry 3

}

}

}

2.3.开启keepalive、ipvsam服务

systemctl start keepalived

systemctl start ipvsam

2.4、验证

ipvsam 查看负载情况

三、mariadb 集群

3.1 数据库安装

分别在三台主机安装mariadb的数据，本次安装10.3.14版本的数据，较为稳定的版本

vi /etc/yum.repos.d/MariaDB.repo

[mariadb]

name = MariaDB-10.3.14

baseurl=http://yum.mariadb.org/10.3.14/centos7-amd64

[[email protected] /]# yum install mariadb-server -y

Loaded plugins: langpacks, product-id, subscription-manager

Complete!

[[email protected] /]# rpm -qa | grep mariadb

mariadb-server-5.5.50-1.el7_2.x86_64

mariadb-libs-5.5.50-1.el7_2.x86_64

mariadb-5.5.50-1.el7_2.x86_64

mariadb-devel-5.5.50-1.el7_2.x86_64

启动mariadb服务程序并添加到开机启动项中：

[[email protected] /]# systemctl start mariadb

[[email