MySQL负载均衡

实现MySQL负载均衡

环境说明

类型	IP地址
RS1	192.168.236.129
ld	192.168.236.131
RS2	192.168.236.131

实验步骤
//在RS1上安装MySQL，

//安装mariadb
[root@localhost ~]# yum -y install mariadb mariadb-common mariadb-devel mariadb-server
//启动  并设置开机自动启动
[root@RS1 ~]# systemctl enable --now mariadb
[root@RS1 ~]# systemctl  status mariadb

//在RS2上安装MySQL，然后创建数据库并授权

[root@RS2 ~]# yum -y install mariadb mariadb-common mariadb-devel mariadb-server
[root@RS2 ~]# systemctl enable --now mariadb

在dl安装mysql

[root@ld ~]# yum -y install mariadb mariadb-common mariadb-devel mariadb-server

在ld安装haproxy安装

//安装依赖包
[root@ld ~]# yum -y install make gcc pcre-devel bzip2-devel openssl-devel systemd-devel
//创建账户
[root@ld ~]# useradd -r -M -s /sbin/nologin haproxy
//解压
[root@ld ~]# tar xf haproxy-2.3.0.tar.gz 

[root@ld ~]# cd haproxy-2.3.0
[root@ld haproxy-2.3.0]# make clean //清除临时文件; 清理临时文件

//编译安装
[root@ld haproxy-2.3.0]# make -j $(grep 'processor' /proc/cpuinfo |wc -l)  \
TARGET=linux-glibc  \
USE_OPENSSL=1  \
USE_ZLIB=1  \
USE_PCRE=1  \
USE_SYSTEMD=1
[root@ld ~]# 
//安装
[root@ld haproxy-2.3.0]# make install PREFIX=/usr/local/haproxy
[root@ld haproxy-2.3.0]# cp haproxy /usr/sbin/

配置各个负载的内核参数

[root@ld haproxy-2.3.0]# echo 'net.ipv4.ip_nonlocal_bind = 1' >>  /etc/sysctl.conf
[root@ld haproxy-2.3.0]# echo 'net.ipv4.ip_forward = 1'