mariadb galera cluster+haproxy+keepalived

最新推荐文章于 2021-12-29 08:56:01 发布

叶叶叶叶叶子Gladys

最新推荐文章于 2021-12-29 08:56:01 发布

阅读量683

点赞数

分类专栏：互联网技术

本文链接：https://blog.csdn.net/weixin_42153254/article/details/105325334

版权

互联网技术专栏收录该内容

2 篇文章 0 订阅

订阅专栏

参考资料

https://blog.51cto.com/changeflyhigh/1886032

https://blog.csdn.net/wo18237095579/article/details/81270954

https://www.iteye.com/news/30701

拓扑结构

操作步骤

一、安装mysql galera软件

1.1、创建用户

[root@Xia yum.repos.d]# groupadd -r -g 500 mysql
[root@Xia yum.repos.d]# useradd -r -g 500 -u 500 mysql

1.2、创建数据文件文件夹

[root@Xia yum.repos.d]# mkdir -p /data/mysql
[root@Xia yum.repos.d]# chown mysql:mysql /data/mysql

1.3、安装mysql（需要注意依赖性，最好按顺序安装）

rpm下载地址：

http://releases.galeracluster.com/mysql-wsrep-5.7/redhat/7/x86_64/

http://rpmfind.net/linux/rpm2html/search.php?query=galera&submit=Search+...

[root@Xia galera]# yum install -y galera-25.3.12-2.el7.x86_64.rpm
[root@Xia galera]# yum -y install mysql-wsrep-libs-compat-5.7-5.7.29-25.21.el7.x86_64.rpm
[root@Xia galera]# yum install -y mysql-wsrep-common-5.7-5.7.29-25.21.el7.x86_64.rpm
[root@Xia galera]# yum install -y mysql-wsrep-libs-5.7-5.7.29-25.21.el7.x86_64.rpm
[root@Xia galera]# yum install -y mysql-wsrep-devel-5.7-5.7.29-25.21.el7.x86_64.rpm
[root@Xia galera]# yum install -y mysql-wsrep-client-5.7-5.7.29-25.21.el7.x86_64.rpm
[root@Xia galera]# yum install -y mysql-wsrep-server-5.7-5.7.29-25.21.el7.x86_64.rpm
[root@Xia galera]# yum -y install mysql-wsrep-5.7-5.7.29-25.21.el7.x86_64.rpm
[root@Xia galera]# rpm -ivh mysql-wsrep-test-5.7-5.7.29-25.21.el7.x86_64.rpm --nodeps

mysql-wsrep-test有依赖性的问题，直接使用rpm忽略依赖性安装即可

二、修改mysql相关配置

2.1、修改配置文件

启动第一个节点的时候需把配置改为wsrep_cluster_address=gcomm://，其他节点启动的时候加上带ip的地址启动，第一个节点启动完毕后，把配置文件修改为带ip的参数配置

[root@commondb2 init.d]# grep -Ev "#|^$" /etc/my.cnf
[mysqld]
datadir=/data/mysql
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid
port = 3306
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
symbolic-links=0
max_connections=400
innodb_file_per_table=1
lower_case_table_names=1
character_set_server=utf8
wsrep_on=ON
wsrep_node_name=permitdb2
wsrep_provider=/usr/lib64/galera/libgalera_smm.so
wsrep_cluster_name=galera_cluster
wsrep_cluster_address="gcomm://130.166.1.105,130.166.1.104,130.166.1.106"
wsrep_sst_method = rsync
wsrep_node_address=130.166.1.104
wsrep_provider_options="gmcast.listen_addr=tcp://130.166.1.104:4567"
wsrep_sst_auth=root:mysql
default_storage_engine=InnoDB
socket=/var/lib/mysql/mysql.sock
[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid
[client]
socket=/var/lib/mysql/mysql.sock
!includedir /etc/my.cnf.d

wsrep_on=ON wsrep_node_name=permitdb2 # wsrep节点的ID，必须是唯一的，集群各个节点也不同 wsrep_provider=/usr/lib64/galera/libgalera_smm.so # wsrep提供者,必须配置(.so文件的路径在哪，就配置成哪,一般安装好后都是在这个目录下) wsrep_cluster_name=galera_cluster # galera集群的名字，必须是统一的 wsrep_cluster_address="gcomm://130.166.1.105,130.166.1.104,130.166.1.106" # 集群中的其他节点地址，可以使用主机名或IP wsrep_sst_method = rsync # 集群同步方式，我的系统没有可以用yum安装一下这个远程连接 yum -y install rsync wsrep_node_address=130.166.1.104 # 本机节点地址，可以使用主机名或IP wsrep_provider_options="gmcast.listen_addr=tcp://130.166.1.104:4567" # 指定wsrep启动端口号,4567为默认值 wsrep_sst_auth=root:mysql # 集群同步的用户名密码

2.2、创造mysql的相关文件

[root@Xia lib]# cd /var/log/
[root@Xia log]# mkdir mariadb
[root@Xia mariadb]# chown -R mysql:mysql ../mariadb/
[root@Xia mariadb]# cd /var/run/
[root@Xia run]# mkdir mariadb
[root@Xia run]# cd mariadb/
[root@Xia mariadb]# touch mariadb.pid
[root@Xia mariadb]# chown -R mysql:mysql ../mariadb/

2.3、初始化

[root@Xia mariadb]# /sbin/mysqld --initialize --user=mysql

三、验证集群情况

3.1、修改root密码

[root@Xia mysql]# service mysqld start
[root@Xia bin]# mysql -uroot -p
mysql> set password=PASSWORD('mysql'); //只要第一个节点改密码即可

3.2、查看集群情况

mysql> show status like "wsrep%";

四、部署haproxy+keepalived

4.1、安装配置haproxy（两个节点都一样的操作，一样的配置中）

[root@node166 ~]# yum -y install haproxy keepalived
[root@node166 ~]# cd /etc/haproxy/
[root@node166 haproxy]# cp haproxy.cfg{,.bak}
[root@node166 haproxy]# vim /etc/haproxy/haproxy.cfg //更改以下部分，后面的通通不要
	#---------------------------------------------------------------------
	# main frontend which proxys to the backends
	#---------------------------------------------------------------------
	listen mysql_proxy 0.0.0.0:3306
	    mode tcp
	    balance leastconn
	    server mysql1 130.166.1.104:3306 weight 1
	    server mysql1 130.166.1.105:3306 weight 1
	    server mysql1 130.166.1.106:3306 weight 1
[root@node166 haproxy]# systemctl start haproxy

4.2、安装配饰keepalived（两个节点配置不一样，分主和备）

4.2.1、主节点keepalived.conf配置

[root@node166 haproxy]# cd /etc/keepalived/
[root@node166 keepalived]# vim keepalived.conf
! Configuration File for keepalived
global_defs {
   notification_email {
     acassen@firewall.loc
     failover@firewall.loc
     sysadmin@firewall.loc
   }
   notification_email_from Alexandre.Cassen@firewall.loc
   smtp_server 192.168.200.1
   smtp_connect_timeout 30
   router_id LVS_DEVEL
}
vrrp_script chk_haproxy {
    script "/etc/keepalived/check_haproxy.sh"
    interval 5
    weight -5    
}
vrrp_instance VI_1 {
    state MASTER
    interface ens192
    virtual_router_id 51
    priority 100
    advert_int 1
    authentication {
        auth_type PASS
        auth_pass 111199
    }
    virtual_ipaddress {
        130.166.1.66/16 dev ens192 label ens192:1
    }
    track_script {
        chk_haproxy
    }
}

4.2.2、主节点check_haproxy.sh脚本

[root@node166 keepalived]# vim check_haproxy.sh
[root@node166 ~]# grep -Ev "#|^$" /etc/keepalived/check_haproxy.sh
A=`ps -C haproxy --no-header | wc -l`
if [ $A -eq 0 ]; then
        systemctl restart haproxy
        echo "Start haproxy" &> /dev/null
        sleep 3
        if [ `ps -C haproxy --no-header | wc -l`  -eq 0 ];then
                systemctl stop keepalived
                echo "Stop keepalived" &> /dev/null
        fi
fi
[root@node166 keepalived]# chmod +x check_haproxy.sh
[root@node166 keepalived]# systemctl start keepalived

4.2.3、备节点keepalived.conf配置

[root@node188 haproxy]# cd /etc/keepalived/
[root@node188 keepalived]# vim keepalived.conf
[root@node188 keepalived]# grep -Ev "#|^$" /etc/keepalived/keepalived.conf 
! Configuration File for keepalived
global_defs {
   notification_email {
     acassen@firewall.loc
     failover@firewall.loc
     sysadmin@firewall.loc
   }
   notification_email_from Alexandre.Cassen@firewall.loc
   smtp_server 192.168.200.1
   smtp_connect_timeout 30
   router_id LVS_DEVEL
}
vrrp_script chk_haproxy {
    script "/etc/keepalived/check_haproxy.sh"
    interval 5
    weight -5    
}
vrrp_instance VI_1 {
    state BACKUP
    interface ens192
    virtual_router_id 51
    priority 99
    advert_int 1
    authentication {
        auth_type PASS
        auth_pass 111199
    }
    virtual_ipaddress {
        130.166.1.66/16 dev ens192 label ens192:1
    }
    track_script {
        chk_haproxy
    }
}

4.2.3、备节点check_haproxy.sh配置

[root@node188 keepalived]# vim check_haproxy.sh
[root@node188 ~]# grep -Ev "#|^$" /etc/keepalived/check_haproxy.sh
[root@node188 keepalived]# grep -Ev "#|^$" /etc/keepalived/check_haproxy.sh
A=`ps -C haproxy --no-header | wc -l`
if [ $A -eq 0 ]; then
        systemctl start haproxy
        echo "Start haproxy" &> /dev/null
        sleep 3
        if [ `ps -C haproxy --no-header | wc -l`  -eq 0 ];then
                echo "Stop keepalived" &> /dev/null
        fi
fi
[root@node166 keepalived]# chmod +x check_haproxy.sh
[root@node166 keepalived]# systemctl start keepalived

这些都部署完之后使用130.166.1.66去访问mysql就稳稳的了

叶叶叶叶叶子Gladys

关注

0
点赞
踩
3

收藏

觉得还不错? 一键收藏
0
评论
mariadb galera cluster+haproxy+keepalived

目录参考资料相关知识拓扑结构操作步骤一、安装mysql galera软件1.1、创建用户1.2、创建数据文件文件夹1.3、安装mysql（需要注意依赖性，最好按顺序安装）二、修改mysql相关配置2.1、修改配置文件2.2、创造mysql的相关文件2.3、初始化三、验证集群情况3.1、修改root密码3.2、查看集群情况四、部署hap...
复制链接

扫一扫