LVS-DR模式负载均衡MYSQL

最新推荐文章于 2025-03-26 18:39:04 发布

愿而自知

最新推荐文章于 2025-03-26 18:39:04 发布

阅读量215

点赞数

文章标签：负载均衡运维

本文链接：https://blog.youkuaiyun.com/weixin_47746630/article/details/109910472

版权

本文详细介绍了如何使用LVS-DR模式进行MySQL的负载均衡配置，包括在DR和各个冗余服务器（RS1, RS2）上的操作步骤，以及RS上安装MySQL数据库、创建数据库和权限分配，最后通过客户端进行连接验证。" 121237887,11613455,SpringMVC查询列表返回null问题及解决,"['java', '后端', 'springmvc', 'MyBatis']

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

主机类型	IP	需要安装包
客户端 client	192.168.152.133	MySQL
调度器 DR	192.168.152.132	ipvsadm
服务器 RS1	192.168.152.134	MySQL
服务器 RS2	192.168.152.135	MySQL

DR上操作

//配置DIP和VIP
[root@DR ~]# vim /etc/sysconfig/network-scripts/ifcfg-ens160 

TYPE=Ethernet
BOOTPROTO=static
NAME=ens160
DEVICE=ens160
ONBOOT=yes
IPADDR0=192.168.152.132          //DIP
PREFIX0=24
IPADDR1=192.168.152.111          //VIP
PREFIX1=24
GATEWAY0=192.168.152.2
DNS1=114.114.114.114

//重启网卡
[root@DR ~]# ifdown ens160;ifup ens160

//配置路由信息
[root@DR ~]# route add -host 192.168.152.111 dev lo

RS1上操作

//修改内核参数
[root@RS1 ~]# vim /etc/sysctl.conf
net.ipv4.conf.all.arp_ignore = 1
net.ipv4.conf.all.arp_announce = 2
[root@RS1 ~]# sysctl -p
net.ipv4.conf.all.arp_ignore = 1
net.ipv4.conf.all.arp_announce = 2

//配置RS1上的RIP和VIP
[root@RS1 ~]# vim /etc/sysconfig/network-scripts/ifcfg-ens160 

TYPE=Ethernet
BOOTPROTO=static
NAME=ens160
DEVICE=ens160
ONBOOT=yes
IPADDR0=192.168.152.134        //RIP
PREFIX0=24
IPADDR1=192.168.152.111        //VIP
PREFIX1=24
GATEWAY0=192.168.152.2
DNS1=114.114.114.114

//重启网卡
[root@RS1 ~]# ifdown ens160;ifup ens160

//配置路由信息
[root@RS1 ~]# route add -host 192.168.152.111 dev lo

RS2上操作

//修改内核参数
[root@RS2 ~]# vim /etc/sysctl.conf 
net.ipv4.conf.all.arp_ignore = 1
net.ipv4.conf.all.arp_announce = 2

[root@RS2 ~]# sysctl -p
net.ipv4.conf.all.arp_ignore = 1
net.ipv4.conf.all.arp_announce = 2

//配置RS2上的RIP和VIP
[root@RS2 ~]# vim /etc/sysconfig/network-scripts/ifcfg-ens160 

TYPE=Ethernet
BOOTPROTO=static
NAME=ens160
DEVICE=ens160
ONBOOT=yes
IPADDR0=192.168.152.135        //RIP
PREFIX0=24
IPADDR1=192.168.152.111        //VIP
PREFIX1=24
GATEWAY0=192.168.152.2
DNS1=114.114.114.114

//重启网卡
[root@RS2 ~]# ifdown ens160;ifup ens160

//配置路由信息
[root@RS2 ~]# route add -host 192.168.152.111 dev lo

DR上操作

//在DR上添加并保存规则
[root@DR ~]# ipvsadm -A -t 192.168.152.111:3306 -s rr
[root@DR ~]# ipvsadm -a -t 192.168.152.111:3306 -r 192.168.152.134:3306
[root@DR ~]# ipvsadm -a -t 192.168.152.111:3306 -r 192.168.152.135:3306
[root@DR ~]# ipvsadm -Sn > /etc/sysconfig/ipvsadm
[root@DR ~]# ipvsadm -ln
IP Virtual Server version 1.2.1 (size=4096)
Prot LocalAddress:Port Scheduler Flags
  -> RemoteAddress:Port           Forward Weight ActiveConn InActConn
TCP  192.168.152.111:3306 rr
  -> 192.168.152.134:3306         Route   1      0          0         
  -> 192.168.152.135:3306         Route   1      0          0

RS上安装MySQL，创建数据库并授权

//下载MySQL,启动服务
[root@RS1 ~]# yum -y install mariadb mariadb-common mariadb-devel mariadb-server
[root@RS1 ~]# systemctl start mariadb

//创建数据库并授权
[root@RS1 ~]# mysql
MariaDB [(none)]> create database RS1;
Query OK, 1 row affected (0.001 sec)

MariaDB [(none)]> grant all on *.* to 'root'@'192.168.152.%' identified by '123456';
Query OK, 0 rows affected (0.001 sec)

MariaDB [(none)]> flush privileges;
Query OK, 0 rows affected (0.001 sec)

MariaDB [(none)]> 

//下载MySQL,启动服务
[root@RS2 ~]# yum -y install mariadb mariadb-common mariadb-devel mariadb-server
[root@RS2 ~]# systemctl start mariadb

//创建数据库并授权
[root@RS2 ~]# mysql
MariaDB [(none)]> create database RS2;
Query OK, 1 row affected (0.001 sec)

MariaDB [(none)]> grant all on *.* to 'root'@'192.168.152.%' identified by '123456';
Query OK, 0 rows affected (0.001 sec)

MariaDB [(none)]> flush privileges;
Query OK, 0 rows affected (0.001 sec)

MariaDB [(none)]>

客户端验证

[root@client ~]# ping 192.168.152.132
PING 192.168.152.132 (192.168.152.132) 56(84) bytes of data.
64 bytes from 192.168.152.132: icmp_seq=1 ttl=64 time=1.79 ms

[root@client ~]# ping 192.168.152.111
PING 192.168.152.222 (192.168.152.111) 56(84) bytes of data.
64 bytes from 192.168.152.222: icmp_seq=1 ttl=64 time=2.21 ms

[root@client ~]# arp -a
? (192.168.152.222) at 00:0c:29:99:ef:dd [ether] on ens33
? (192.168.152.1) at 00:50:56:c0:00:08 [ether] on ens33
_gateway (192.168.152.2) at 00:50:56:e5:7c:35 [ether] on ens33
? (192.168.152.132) at 00:0c:29:99:ef:dd [ether] on ens33

[root@client ~]# mysql -uroot -p123456 -h192.168.152.111 -e 'show databases;'
+--------------------+
| Database           |
+--------------------+
| RS2                |
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
[root@client ~]# mysql -uroot -p123456 -h192.168.152.111 -e 'show databases;'
+--------------------+
| Database           |
+--------------------+
| RS1                |
| information_schema |
| mysql              |
| performance_schema |
+--------------------+