【Mariadb】centos7搭建mariadb Galera集群

时间:2022-09-19 20:12:39

机器列表

1) 192.168.88.104
2) 192.168.88.105

关闭SELINUX

修改/etc/selinux/config文件中的SELINUX="" 为 disabled ,然后重启。

关闭防火墙

systemctl stop firewalld.service
systemctl disable firewalld.service

设置mariadb的yum源并安装(所有节点都要

vi /etc/yum.repos.d/mariadb.repo

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
enabled=0

yum --enablerepo=mariadb -y install MariaDB-server galera

配置 第一个 节点(192.168.88.104)

vi /etc/my.cnf.d/server.cnf

[galera]
# Mandatory settings
wsrep_on=ON
wsrep_provider=/usr/lib64/galera/libgalera_smm.so 
wsrep_cluster_address=gcomm:// 
binlog_format=row
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0

# add follows
# cluster name
wsrep_cluster_name="MariaDB_Cluster"
# own IP address(当前节点的IP)
wsrep_node_address="192.168.88.104"
# replication provider
wsrep_sst_method=rsync

启动集群:/bin/galera_new_cluster 

配置 其它 节点(192.168.88.105)

vi /etc/my.cnf.d/server.cnf

[galera]
# Mandatory settings
wsrep_on=ON
wsrep_provider=/usr/lib64/galera/libgalera_smm.so 

# specify all nodes in cluster(所有节点的IP,这里只有2台机器)
wsrep_cluster_address="gcomm://192.168.88.104,192.168.88.105" 

binlog_format=row
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0

# add follows
# cluster name
wsrep_cluster_name="MariaDB_Cluster"
# own IP address(当前节点的IP)
wsrep_node_address="192.168.88.105"
# replication provider
wsrep_sst_method=rsync

启动集群节点:systemctl start mariadb

测试集群状态

mysql -u root -p
show status like 'wsrep_%'; 
如果 "wsrep_local_state_comment" is "Synced" 则表明集群创建成功