mysql主主+keepalived高可用

最新推荐文章于 2025-04-16 16:23:09 发布

weixin_51886593

最新推荐文章于 2025-04-16 16:23:09 发布

阅读量130

点赞数

本文链接：https://blog.youkuaiyun.com/weixin_51886593/article/details/110749431

版权

本文详细介绍如何在CentOS 7环境下搭建MySQL主从复制及Keepalived高可用集群，包括配置Mariadb数据库、实现主从复制、安装及配置Keepalived等关键步骤。

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

192.168.81.109 vip
192.168.81.100 centos7 客户端
192.168.81.101 centos7 mysql主+keepalived主
192.168.81.102 centos7 mysql主+keepalived备

192.168.81.100
部署数据库
yum -y install mariadb mariadb-server
修改配置文件
vim /etc/my.cnf
server-id=1
log-bin=mysqlbin
relay-log=relays-log
启动mariadb
systemctl start mariadb
部署主服务器
mysql -e "grant all on *.* to mysql@'%' identified by 'mysql';"
mysql -e "show master status;"
mysql -e "change master to master_host='192.168.81.102',master_user='mysql',master_passowrd='mysql',master_log_file='mysqlbin.000001',master_log_pos=123456"
mysql -e "slave start;"
mysql -e "show slave status \G;"
部署keepalived
yum -y install keepalived ipvsadm
修改keepalived配置文件
vim /etc/keepalived/keepalived.conf
vrrp_instance VI_1 {
    state MASTER
    interface eth0
    virtual_router_id 51
    priority 100
    advert_int 1
    authentication {
        auth_type PASS
        auth_pass 1111
    }
    virtual_ipaddress {
        192.168.81.109
    }
}
virtual_server 192.168.81.109 3306 {
    delay_loop 6
    lb_algo rr
    lb_kind NAT
    persistence_timeout 50
    protocol TCP

    real_server 192.168.81.100 3306 {
        weight 1
        TCP_CHECK {
            connect_timeout 3
            nb_get_retry 3
            delay_before_retry 3
            connect_port 3306
        }
    }
}
启动keepalived
systemctl start keepalived
开机启动
chkconfig keepalived on
查看ipvsadm
ipvsadm

192.168.81.100
部署数据库
yum -y install mariadb mariadb-server
修改配置文件
vim /etc/my.cnf
server-id=1
log-bin=mysqlbin
relay-log=relays-log
启动mariadb
systemctl start mariadb
部署主服务器
mysql -e "grant all on *.* to mysql@'%' identified by 'mysql';"
mysql -e "show master status;"
mysql -e "change master to master_host='192.168.81.101',master_user='mysql',master_passowrd='mysql',master_log_file='mysqlbin.000001',master_log_pos=123456"
mysql -e "slave start;"
mysql -e "show slave status \G;"
部署keepalived
yum -y install keepalived ipvsadm
修改keepalived配置文件
vim /etc/keepalived/keepalived.conf
vrrp_instance VI_1 {
    state SLAVE
    interface eth0
    virtual_router_id 51
    priority 50
    advert_int 1
    authentication {
        auth_type PASS
        auth_pass 1111
    }
    virtual_ipaddress {
        192.168.81.109
    }
}
virtual_server 192.168.81.109 3306 {
    delay_loop 6
    lb_algo rr
    lb_kind NAT
    persistence_timeout 50
    protocol TCP

    real_server 192.168.81.101 3306 {
        weight 1
        TCP_CHECK {
            connect_timeout 3
            nb_get_retry 3
            delay_before_retry 3
            connect_port 3306
        }
    }
}
启动keepalived
systemctl start keepalived
开机启动
chkconfig keepalived on
查看ipvsadm
ipvsadm

192.168.81.100
部署mariadb
yum -y install mariadb mariadb-server
systemctl start mariadb
远程登陆mysql主主架构
mysql -umysql -pmysql -h192.168.81.109 -P3306
mysql -e "show variables like 'server_id';"
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| server_id     | 1     |
+---------------+-------+
1 row in set (0.00 sec)
关闭keepalived主的keepalived和mysql
systemctl stop keepalived
systemctl stop mariadb
再远程登陆mysql
mysql -umysql -pmysql -h192.168.81.109 -P3306
mysql -e "show variables like 'server_id';"
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| server_id     | 2     |
+---------------+-------+
1 row in set (0.00 sec)
自动切换为keepalived备用mysql数据库