本帖最后由 alenas 于 2018-5-2 17:23 编辑
1.服务器配置
lvs-master 192.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下增加以下内容
[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下增加以下内容
[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 配置lvs-slave为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
TCP lvs-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
TCP 192.168.47.130:mysql wlc
-> 192.168.47.131:mysql Route 3 0 0
-> 192.168.47.132:mysql Route 3 0 0
运维网声明
1、欢迎大家加入本站运维交流群:群②:261659950 群⑤:202807635 群⑦870801961 群⑧679858003
2、本站所有主题由该帖子作者发表,该帖子作者与运维网 享有帖子相关版权
3、所有作品的著作权均归原作者享有,请您和我们一样尊重他人的著作权等合法权益。如果您对作品感到满意,请购买正版
4、禁止制作、复制、发布和传播具有反动、淫秽、色情、暴力、凶杀等内容的信息,一经发现立即删除。若您因此触犯法律,一切后果自负,我们对此不承担任何责任
5、所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其内容的准确性、可靠性、正当性、安全性、合法性等负责,亦不承担任何法律责任
6、所有作品仅供您个人学习、研究或欣赏,不得用于商业或者其他用途,否则,一切后果均由您自己承担,我们对此不承担任何法律责任
7、如涉及侵犯版权等问题,请您及时通知我们,我们将立即采取措施予以解决
8、联系人Email:admin@iyunv.com 网址:www.yunweiku.com