做网站空间哪家好,学校 网站源码,帮人做设计的网站,东莞网站建设方案外包MYSQL双主双从#xff0c;使用Keepalived双机热备LVS高可用群集
文档只记录KeepalivedLVSmysql主从#xff0c;不包含检验#xff0c;如需检验#xff0c;请自行添加web服务器
一、IP规划
服务器IP备注master1192.168.100.131master2的从master2192.168.100.132maste…MYSQL双主双从使用Keepalived双机热备LVS高可用群集
文档只记录KeepalivedLVSmysql主从不包含检验如需检验请自行添加web服务器
一、IP规划
服务器IP备注master1192.168.100.131master2的从master2192.168.100.132master1的从slave1192.168.100.134master1的从slave2192.168.100.135master2的从KI1192.168.100.137主KI2192.168.100.138从虚拟ip192.168.100.200热备ip
二、具体配置
1.master1
配置ip192.168.100.131
关闭防护墙selinux
# 关闭防火墙
systemctl stop firewalld# 关闭selinux
setenforce 0 下载mariadb
yum -y install mariadb mariadb-server 编辑mariadb配置文件
vi /etc/my.cnf 添加以下内容
# 标识0-65535范围
server-id1# 日志文件名称前缀
log-binmysql-bin# 排除不复制的库
binlog-ignore-dbmysql
binlog-ignore-dbinformation_schema
binlog-ignore-dbperformance_schema
binlog-ignore-dbsys# 配置中继日志名称
relay-logmysql-relay-bin# 配置排除的库
replicate-ignore-dbmysql
replicate-ignore-dbinformation_schema
replicate-ignore-dbperformance_schema
replicate-ignore-dbsys# 编码格
init-connectSET NAMES UTF8
skip-character-set-client-handshake
character-set-serverutf8# 开启联等备份
log_slave_updates1 修改完成重启服务
# 重启服务
systemctl restart mariadb# 配置mysql密码123456
mysql_secure_installation 授权
# 进入mysql
mysql -uroot -p123456# 创建用户
create user backup% identified by 123456;# 授权
grant replication slave on *.* to backup% identified by 123456;
grant all privileges on *.* to root% identified by 123456;# 刷新权限
flush privileges;# 查询Log_filelog_pos
show master status;
-------------------------------------------------------------------------------------------
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
-------------------------------------------------------------------------------------------
| mysql-bin.000003 | 1947 | | mysql,information_schema,performance_schema,sys |
-------------------------------------------------------------------------------------------
1 row in set (0.00 sec)# 从库连接主库MASTER_LOG_FILE与MASTER_LOG_POS的值由主库信息获得
change master to
MASTER_HOST192.168.100.132,
MASTER_USERbackup,
MASTER_PASSWORD123456,
MASTER_PORT3306,
MASTER_LOG_FILEmysql-bin.000003,
MASTER_LOG_POS1947;# 开启复制
start slave;# 查看slave状态Slave_IO_RunningSlave_SQL_Running的状态要为Yes
show slave status \G;2.master2
配置ip192.168.100.132
关闭防护墙selinux
# 关闭防火墙
systemctl stop firewalld# 关闭selinux
setenforce 0 下载mariadb
yum -y install mariadb mariadb-server 编辑mariadb配置文件
vi /etc/my.cnf 添加以下内容
# 标识0-65535范围
server-id2# 日志文件名称前缀
log-binmysql-bin# 排除不复制的库
binlog-ignore-dbmysql
binlog-ignore-dbinformation_schema
binlog-ignore-dbperformance_schema
binlog-ignore-dbsys# 配置中继日志名称
relay-logmysql-relay-bin# 配置排除的库
replicate-ignore-dbmysql
replicate-ignore-dbinformation_schema
replicate-ignore-dbperformance_schema
replicate-ignore-dbsys# 编码格
init-connectSET NAMES UTF8
skip-character-set-client-handshake
character-set-serverutf8# 开启联等备份
log_slave_updates1 修改完成重启服务
# 重启服务
systemctl restart mariadb# 配置mysql密码123456
mysql_secure_installation 授权
# 进入mysql
mysql -uroot -p123456# 创建用户
create user backup% identified by 123456;# 授权
grant replication slave on *.* to backup% identified by 123456;
grant all privileges on *.* to root% identified by 123456;# 刷新权限
flush privileges;# 查询Log_filelog_pos
show master status;
-------------------------------------------------------------------------------------------
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
-------------------------------------------------------------------------------------------
| mysql-bin.000003 | 1947 | | mysql,information_schema,performance_schema,sys |
-------------------------------------------------------------------------------------------
1 row in set (0.00 sec)# 从库连接主库MASTER_LOG_FILE与MASTER_LOG_POS的值由主库信息获得
change master to
MASTER_HOST192.168.100.134,
MASTER_USERbackup,
MASTER_PASSWORD123456,
MASTER_PORT3306,
MASTER_LOG_FILEmysql-bin.000004,
MASTER_LOG_POS1947;# 开启复制
start slave;# 查看slave状态Slave_IO_RunningSlave_SQL_Running的状态要为Yes
show slave status \G;3.slave1
配置ip192.168.100.134
关闭防护墙selinux
# 关闭防火墙
systemctl stop firewalld# 关闭selinux
setenforce 0 下载mariadb
yum -y install mariadb mariadb-server 编辑mariadb配置文件
vi /etc/my.cnf 添加以下内容
# 标识0-65535范围
server-id3# 配置中继日志名称
relay-logmysql-relay-bin# 配置排除的库
replicate-ignore-dbmysql
replicate-ignore-dbinformation_schema
replicate-ignore-dbperformance_schema
replicate-ignore-dbsys# 编码格式
init-connectSET NAMES UTF8
skip-character-set-client-handshake
character-set-serverutf8 修改完成重启服务
# 重启服务
systemctl restart mariadb# 配置mysql密码123456
mysql_secure_installation 授权
# 连接数据库
mysql -uroot -p123456# 授权
grant all privileges on *.* to root% identified by 123456; # 刷新权限
flush privileges;# 从库连接主库MASTER_LOG_FILE与MASTER_LOG_POS的值由主库信息获得
change master to
MASTER_HOST192.168.100.131,
MASTER_USERbackup,
MASTER_PASSWORD123456,
MASTER_PORT3306,
MASTER_LOG_FILEmysql-bin.000003,
MASTER_LOG_POS1947;# 开启复制
start slave;# 查看slave状态Slave_IO_RunningSlave_SQL_Running的状态要为Yes
show slave status \G;4.slave2
配置ip192.168.100.135
关闭防护墙selinux
# 关闭防火墙
systemctl stop firewalld# 关闭selinux
setenforce 0 下载mariadb
yum -y install mariadb mariadb-server 编辑mariadb配置文件
vi /etc/my.cnf 添加以下内容
# 标识0-65535范围
server-id4# 配置中继日志名称
relay-logmysql-relay-bin# 配置排除的库
replicate-ignore-dbmysql
replicate-ignore-dbinformation_schema
replicate-ignore-dbperformance_schema
replicate-ignore-dbsys# 编码格
init-connectSET NAMES UTF8
skip-character-set-client-handshake
character-set-serverutf8 修改完成重启服务
# 重启服务
systemctl restart mariadb# 配置mysql密码123456
mysql_secure_installation 授权
# 连接数据库
mysql -uroot -p123456# 授权
grant all privileges on *.* to root% identified by 123456; # 刷新权限
flush privileges;# 从库连接主库MASTER_LOG_FILE与MASTER_LOG_POS的值由主库信息获得
change master to
MASTER_HOST192.168.100.132,
MASTER_USERbackup,
MASTER_PASSWORD123456,
MASTER_PORT3306,
MASTER_LOG_FILEmysql-bin.000003,
MASTER_LOG_POS1947;# 开启复制
start slave;# 查看slave状态Slave_IO_RunningSlave_SQL_Running的状态要为Yes
show slave status \G;5.KI1
配置ip192.168.100.137
关闭防护墙selinux
# 关闭防火墙
systemctl stop firewalld# 关闭selinux
setenforce 0 下载keepalived和ipvsadm
yum -y install keepalived ipvsadm 备份默认配置文件
cp -p /etc/keepalived/keepalived.conf /etc/keepalived/keepalived.conf.bak 删除原有文件创建新内容
# 删除原有文件
rm -rf /etc/keepalived/keepalived.conf # 创建新文件
vi /etc/keepalived/keepalived.conf 添加以下内容
! Configuration File for keepalived# 配置双机热备主
lobal_defs {router_id 1
}
vrrp_instance VI_1 {state MASTERinterface ens33virtual_router_id 1priority 120advert_int 1authentication {auth_type PASSauth_pass 123456}virtual_ipaddress {192.168.100.200}
}# 虚拟服务器ip及mysql地址
virtual_server 192.168.100.200 3306 {delay_loop 15lb_algo rrlb_kind DRprotocol TCPreal_server 192.168.100.131 3306 {weight 1TCP_CHECK {connect_port 3306connect_timeout 3nb_get_retry 3delay_before_retry 4}}real_server 192.168.100.132 3306 {weight 1TCP_CHECK {connect_port 3306connect_timeout 3nb_get_retry 3delay_before_retry 4}}
} 启动keepalived
systemctl start keepalived 服务模块
# 加载系统内核的服务模块
modprobe ip_vs# 查看运行状态
lsmod | grep ip_vs 查看规则
ipvsadm -l 下载net网络工具
yum -y install net-tools 查看网卡信息
# 停用物理网卡
ifconfig ens33 down# 启动物理网卡如在连接工具上需到虚拟机上启动
ifconfig ens33 up# 查看网卡信息在ens33网卡下是否有ip192.168.100.200
ip a 虚拟网卡
# 添加虚拟网卡回环地址
cat /etc/sysconfig/network-scripts/ifcfg-lo:0 EOF
DEVICElo:0
IPADDR192.168.100.200
NETMASK255.255.255.255
ONBOOTyes
EOF# 重启网络
systemctl restart network# 查看是否有虚拟ip
ip a 写入路由指向
# 添加路由信息
route add -host 192.168.100.200 dev lo:06.KI2
配置ip192.168.100.138
关闭防护墙selinux
# 关闭防火墙
systemctl stop firewalld# 关闭selinux
setenforce 0 下载keepalived和ipvsadm
yum -y install keepalived ipvsadm 备份默认配置文件
cp -p /etc/keepalived/keepalived.conf /etc/keepalived/keepalived.conf.bak 添加以下内容
! Configuration File for keepalived# 配置双机热备备
lobal_defs {router_id 2
}
vrrp_instance VI_1 {state BACKUPinterface ens33virtual_router_id 1priority 100advert_int 1authentication {auth_type PASSauth_pass 123456}virtual_ipaddress {192.168.100.200}
}# 虚拟服务器ip及mysql地址
virtual_server 192.168.100.200 3306 {delay_loop 15lb_algo rrlb_kind DRprotocol TCPreal_server 192.168.100.131 3306 {weight 1TCP_CHECK {connect_port 3306connect_timeout 3nb_get_retry 3delay_before_retry 4}}real_server 192.168.100.132 3306 {weight 1TCP_CHECK {connect_port 3306connect_timeout 3nb_get_retry 3delay_before_retry 4}}
} 启动keepalived
systemctl start keepalived 服务模块
# 加载系统内核的服务模块
modprobe ip_vs# 查看运行状态
lsmod | grep ip_vs 查看规则
ipvsadm -l 下载net网络工具
yum -y install net-tools 查看网卡信息
# 停用物理网卡
ifconfig ens33 down# 启动物理网卡如在连接工具上需到虚拟机上启动
ifconfig ens33 up# 查看网卡信息在ens33网卡下是否有ip192.168.100.200
ip a 虚拟网卡
# 添加虚拟网卡回环地址
cat /etc/sysconfig/network-scripts/ifcfg-lo:0 EOF
DEVICElo:0
IPADDR192.168.100.200
NETMASK255.255.255.255
ONBOOTyes
EOF# 重启网络
systemctl restart network# 查看是否有虚拟ip
ip a 写入路由指向
# 添加路由信息
route add -host 192.168.100.200 dev lo:0三、检验
可自行添加一台web服务器连接虚拟ip开启KI1或KI2的防火墙进行检测
或者开启KI1的防火墙查看ip是否跳转到KI2上 文章转载自： http://www.morning.gnkbf.cn.gov.cn.gnkbf.cn http://www.morning.btns.cn.gov.cn.btns.cn http://www.morning.spnky.cn.gov.cn.spnky.cn http://www.morning.zshuhd015.cn.gov.cn.zshuhd015.cn http://www.morning.ydryk.cn.gov.cn.ydryk.cn http://www.morning.dnconr.cn.gov.cn.dnconr.cn http://www.morning.tqbyw.cn.gov.cn.tqbyw.cn http://www.morning.tymnr.cn.gov.cn.tymnr.cn http://www.morning.fdjwl.cn.gov.cn.fdjwl.cn http://www.morning.knscf.cn.gov.cn.knscf.cn http://www.morning.ogzjf.cn.gov.cn.ogzjf.cn http://www.morning.wyrkp.cn.gov.cn.wyrkp.cn http://www.morning.hfbtt.cn.gov.cn.hfbtt.cn http://www.morning.xdxpq.cn.gov.cn.xdxpq.cn http://www.morning.bkqdg.cn.gov.cn.bkqdg.cn http://www.morning.wjlkz.cn.gov.cn.wjlkz.cn http://www.morning.rmtxp.cn.gov.cn.rmtxp.cn http://www.morning.lsfzq.cn.gov.cn.lsfzq.cn http://www.morning.rbyz.cn.gov.cn.rbyz.cn http://www.morning.ssrjt.cn.gov.cn.ssrjt.cn http://www.morning.wfjrl.cn.gov.cn.wfjrl.cn http://www.morning.ahscrl.com.gov.cn.ahscrl.com http://www.morning.bqfpm.cn.gov.cn.bqfpm.cn http://www.morning.kqcqr.cn.gov.cn.kqcqr.cn http://www.morning.rbtny.cn.gov.cn.rbtny.cn http://www.morning.jrqbr.cn.gov.cn.jrqbr.cn http://www.morning.sqqdy.cn.gov.cn.sqqdy.cn http://www.morning.qhqgk.cn.gov.cn.qhqgk.cn http://www.morning.xwzsq.cn.gov.cn.xwzsq.cn http://www.morning.tkyry.cn.gov.cn.tkyry.cn http://www.morning.tqpr.cn.gov.cn.tqpr.cn http://www.morning.trsdm.cn.gov.cn.trsdm.cn http://www.morning.wfzdh.cn.gov.cn.wfzdh.cn http://www.morning.lhgkr.cn.gov.cn.lhgkr.cn http://www.morning.dkbsq.cn.gov.cn.dkbsq.cn http://www.morning.yqqgp.cn.gov.cn.yqqgp.cn http://www.morning.rjhts.cn.gov.cn.rjhts.cn http://www.morning.jwfqq.cn.gov.cn.jwfqq.cn http://www.morning.stbhn.cn.gov.cn.stbhn.cn http://www.morning.mcgsq.cn.gov.cn.mcgsq.cn http://www.morning.kmqlf.cn.gov.cn.kmqlf.cn http://www.morning.thmlt.cn.gov.cn.thmlt.cn http://www.morning.hwlk.cn.gov.cn.hwlk.cn http://www.morning.jbpdk.cn.gov.cn.jbpdk.cn http://www.morning.jpjpb.cn.gov.cn.jpjpb.cn http://www.morning.bsqbg.cn.gov.cn.bsqbg.cn http://www.morning.npmpn.cn.gov.cn.npmpn.cn http://www.morning.jfjpn.cn.gov.cn.jfjpn.cn http://www.morning.phwmj.cn.gov.cn.phwmj.cn http://www.morning.bkfdf.cn.gov.cn.bkfdf.cn http://www.morning.ljbpk.cn.gov.cn.ljbpk.cn http://www.morning.zryf.cn.gov.cn.zryf.cn http://www.morning.wgtr.cn.gov.cn.wgtr.cn http://www.morning.hsgxj.cn.gov.cn.hsgxj.cn http://www.morning.fhbhr.cn.gov.cn.fhbhr.cn http://www.morning.nzwp.cn.gov.cn.nzwp.cn http://www.morning.nqmdc.cn.gov.cn.nqmdc.cn http://www.morning.lsmgl.cn.gov.cn.lsmgl.cn http://www.morning.hxlch.cn.gov.cn.hxlch.cn http://www.morning.frpfk.cn.gov.cn.frpfk.cn http://www.morning.lhrxq.cn.gov.cn.lhrxq.cn http://www.morning.mflhr.cn.gov.cn.mflhr.cn http://www.morning.wnqfz.cn.gov.cn.wnqfz.cn http://www.morning.cfynn.cn.gov.cn.cfynn.cn http://www.morning.taipinghl.cn.gov.cn.taipinghl.cn http://www.morning.skql.cn.gov.cn.skql.cn http://www.morning.pwhjr.cn.gov.cn.pwhjr.cn http://www.morning.qsmmq.cn.gov.cn.qsmmq.cn http://www.morning.sdamsm.com.gov.cn.sdamsm.com http://www.morning.rzysq.cn.gov.cn.rzysq.cn http://www.morning.qbtkg.cn.gov.cn.qbtkg.cn http://www.morning.qcztm.cn.gov.cn.qcztm.cn http://www.morning.mzgq.cn.gov.cn.mzgq.cn http://www.morning.rjfr.cn.gov.cn.rjfr.cn http://www.morning.zmqb.cn.gov.cn.zmqb.cn http://www.morning.qyllw.cn.gov.cn.qyllw.cn http://www.morning.jrlxz.cn.gov.cn.jrlxz.cn http://www.morning.rnribht.cn.gov.cn.rnribht.cn http://www.morning.pcrzf.cn.gov.cn.pcrzf.cn http://www.morning.zxfdq.cn.gov.cn.zxfdq.cn
