感谢分享，学习。
谢谢整理、谢谢分享。
老哥 666666
不错的了解
希望是好东西
好东西学习了
谢谢楼主
感谢分享
1.服务器配置
lvs-master192.168.47.5
lvs-slave 192.168.47.6
mysql1 192.168.47.131
mysql2 192.168.47.132
vip 192.168.47.130
2.初始化系统
2.1 操作系统 centos7
2.2 关闭selinux
sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config
setenforce 0
2.3 卸载防火墙firewalld
yum -y remove firewalld
2.4 安装基础工具包
yum install -y net-tools vim iptables-services
2.5 关闭防火墙
systemctl stop iptables
3.安装mariadb
yum install -y mariadb mariadb-server
mysql_secure_installation #初始化mariadb数据库
systemctl start mariadb #启动mariadb数据库
systemctl enable mariadb #开机启动mariadb数据库
4.配置两台数据库互为主从
4.1 mysql1下数据库配置
修改mysql配置文件/etc/my.conf,在mysqld下增加以下内容
server-id =131
log-bin = mysql-bin
auto-increment-offset = 1
auto-increment-increment = 2
log-slave-updates = true
systemctl restart mariadb#修改完配置文件后重启mariadb
mysql -uroot -p #登陆数据库
show master status;#查看binlog日志文件和pos点
**mysql-bin.000001 | 399**
grant replication slave on *.* to repl@'192.168.47.%' identified by 'repl'; #授权同步用户
CHANGE MASTER TO
MASTER_USER='repl',
MASTER_HOST='192.168.47.132',
MASTER_PASSWORD='repl',
MASTER_PORT=3306,
MASTER_LOG_FILE='mysql-bin.000001',
MASTER_LOG_POS=399; #设置主服务器为mysql2
start slave;#启动主从
show slave status\G
**Slave_IO_Running: Yes**
**Slave_SQL_Running: Yes**
4.2 mysql2下数据库配
修改mysql配置文件/etc/my.conf,在mysqld下增加以下内容
server-id =132
log-bin = mysql-bin
auto-increment-offset = 2
auto-increment-increment = 2
log-slave-updates = true
systemctl restart mariadb#修改完配置文件后重启mariadb
mysql -uroot -p #登陆数据库
show master status;#查看binlog日志文件和pos点
**mysql-bin.000001 | 399**
grant replication slave on *.* to repl@'192.168.47.%' identified by 'repl'; #授权同步用户
CHANGE MASTER TO
MASTER_USER='repl',
MASTER_HOST='192.168.47.131',
MASTER_PASSWORD='repl',
MASTER_PORT=3306,
MASTER_LOG_FILE='mysql-bin.000001',
MASTER_LOG_POS=399; #设置主服务器为mysql1
start slave;#启动主从
show slave status\G
**Slave_IO_Running: Yes**
**Slave_SQL_Running: Yes**
5.lvs上安装keepalived和ipvsadm
yum -y install keepalived ipvsadm
systemctl enable keepalived#开机启动keepalived
6.配置keepalive高可用
6.1 配置lvs-master为MASTER节点
vim /etc/keepalived/keepalived.conf
global_defs {
router_id LVS_DEVEL# 设置lvs的id，在一个网络内应该是唯一的
}
vrrp_instance VI_1 {
state MASTER #指定Keepalived的角色，MASTER为主，BACKUP为备
interface ens33
virtual_router_id 130#虚拟路由编号，主备要一致
priority 100#定义优先级，数字越大，优先级越高，主DR必须大于备用DR
advert_int 1#检查间隔，默认为1s
authentication {
auth_type PASS
auth_pass 1111
}
virtual_ipaddress {
192.168.47.130#定义虚拟IP(VIP)为192.168.47.130，可多设，每行一个
}
}
# 定义对外提供服务的LVS的VIP以及port
virtual_server 192.168.47.130 3306 {
delay_loop 6 # 设置健康检查时间，单位是秒
lb_algo wlc # 设置负载调度的算法为wlc 基于权重的调度算法
lb_kind DR # 设置LVS实现负载的机制，有NAT、TUN、DR三个模式
nat_mask 255.255.255.0
#persistence_timeout 0 会话保持时间
protocol TCP
real_server 192.168.47.131 3306 {# 指定real server1的IP地址
weight 3 # 配置节点权值，数字越大权重越高
TCP_CHECK {
connect_timeout 10
nb_get_retry 3
delay_before_retry 3
connect_port 3306
}
}
real_server 192.168.47.132 3306{# 指定real server2的IP地址
weight 3# 配置节点权值，数字越大权重越高
TCP_CHECK {
connect_timeout 10
nb_get_retry 3
delay_before_retry 3
connect_port 3306
}
}
}
6.2 配置mysql为BACKUP节点
vim /etc/keepalived/keepalived.conf
global_defs {
router_id LVS_DEVEL# 设置lvs的id，在一个网络内应该是唯一的
}
vrrp_instance VI_1 {
state BACKUP #指定Keepalived的角色，MASTER为主，BACKUP为备
interface ens33
virtual_router_id 130#虚拟路由编号，主备要一致
priority 90#定义优先级，数字越大，优先级越高，主DR必须大于备用DR
advert_int 1#检查间隔，默认为1s
authentication {
auth_type PASS
auth_pass 1111
}
virtual_ipaddress {
192.168.47.130#定义虚拟IP(VIP)为192.168.47.130，可多设，每行一个
}
}
# 定义对外提供服务的LVS的VIP以及port
virtual_server 192.168.47.130 3306 {
delay_loop 6 # 设置健康检查时间，单位是秒
lb_algo wlc # 设置负载调度的算法为wlc 基于权重的调度算法
lb_kind DR # 设置LVS实现负载的机制，有NAT、TUN、DR三个模式
nat_mask 255.255.255.0
#persistence_timeout 0 会话保持时间
protocol TCP
real_server 192.168.47.131 3306 {# 指定real server1的IP地址
weight 3 # 配置节点权值，数字越大权重越高
TCP_CHECK {
connect_timeout 10
nb_get_retry 3
delay_before_retry 3
connect_port 3306
}
}
real_server 192.168.47.132 3306{# 指定real server2的IP地址
weight 3# 配置节点权值，数字越大权重越高
TCP_CHECK {
connect_timeout 10
nb_get_retry 3
delay_before_retry 3
connect_port 3306
}
}
}
6.3 启动keepalived
systemctl start keepalived
7.修改防火墙配置文件
vim /etc/sysconfig/iptables
-A INPUT -p tcp -m state --state NEW -m tcp --dport 22 -j ACCEPT
-A INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT
-A INPUT -s 192.168.47.0/24 -p vrrp -j ACCEPT
systemctl restart iptables #重启防火墙
systemctl enable iptables #开机启动防火墙
8.查看vip是否生效
lvs-master：
ip addr
inet 192.168.47.5/24 brd 192.168.47.255 scope global ens33
valid_lft forever preferred_lft forever
inet 192.168.47.130/32 scope global ens33
valid_lft forever preferred_lft forever
lvs-slave：
ip addr
inet 192.168.47.6/24 brd 192.168.47.255 scope global ens33
valid_lft forever preferred_lft forever
9.mysql服务器上编写realserver脚本
vim /etc/init.d/realserver
#!/bin/bash
SNS_VIP=192.168.47.130
case "$1" in
start)
ifconfig lo:0 $SNS_VIP netmask 255.255.255.255 broadcast $SNS_VIP
/sbin/route add -host $SNS_VIP dev lo:0
echo "1" >/proc/sys/net/ipv4/conf/lo/arp_ignore
echo "2" >/proc/sys/net/ipv4/conf/lo/arp_announce
echo "1" >/proc/sys/net/ipv4/conf/all/arp_ignore
echo "2" >/proc/sys/net/ipv4/conf/all/arp_announce
sysctl -p >/dev/null 2>&1
echo "RealServer Start OK"
;;
stop)
ifconfig lo:0 down
route del $SNS_VIP >/dev/null 2>&1
echo "0" >/proc/sys/net/ipv4/conf/lo/arp_ignore
echo "0" >/proc/sys/net/ipv4/conf/lo/arp_announce
echo "0" >/proc/sys/net/ipv4/conf/all/arp_ignore
echo "0" >/proc/sys/net/ipv4/conf/all/arp_announce
echo "RealServer Stoped"
;;
*)
echo "Usage: $0 {start|stop}"
exit 1
esac
exit 0
chmod +x realserver#给脚本添加可执行权限
10.启动realserver
/etc/init.d/realserver start
mysql1:
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN qlen 1
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
inet 192.168.47.130/32 brd 192.168.47.130 scope global lo:0
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: ens33: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP qlen 1000
link/ether 00:0c:29:87:53:84 brd ff:ff:ff:ff:ff:ff
inet 192.168.47.131/24 brd 192.168.47.255 scope global ens33
valid_lft forever preferred_lft forever
inet6 fe80::20c:29ff:fe87:5384/64 scope link
valid_lft forever preferred_lft forever
mysql2:
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN qlen 1
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
inet 192.168.47.130/32 brd 192.168.47.130 scope global lo:0
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: ens33: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP qlen 1000
link/ether 00:0c:29:ae:04:ec brd ff:ff:ff:ff:ff:ff
inet 192.168.47.132/24 brd 192.168.47.255 scope global ens33
valid_lft forever preferred_lft forever
inet6 fe80::20c:29ff:feae:4ec/64 scope link
valid_lft forever preferred_lft forever
11.查看lvs状态
lvs-master：
ipvsadm
IP Virtual Server version 1.2.1 (size=4096)
Prot LocalAddress:Port Scheduler Flags
-> RemoteAddress:Port Forward Weight ActiveConn InActConn
TCPlvs-master:mysql wlc
-> 192.168.47.131:mysql Route 3 0 0
-> 192.168.47.132:mysql Route 3 0 0
lvs-slave：
ipvsadm
IP Virtual Server version 1.2.1 (size=4096)
Prot LocalAddress:Port Scheduler Flags
-> RemoteAddress:Port Forward Weight ActiveConn InActConn
TCP192.168.47.130:mysql wlc
-> 192.168.47.131:mysql Route 3 0 0
-> 192.168.47.132:mysql Route 3 0 0
3
点击按钮进行验证
找了好久 真是难得啊
xuexi
多谢楼主分享！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！
谢谢分享！
谢谢分享
辛苦了，非常感谢您做的工作。
bucuo................
感谢楼主辛苦copy和分享！
11111111
万分期待，好好好好！！！
很不错的额，谢谢