一、系统配置（3台openEuler系统上均操作）

1.1、配置hosts解析

1.2、关闭selinux

sudo setenforce 0

sudo vim /etc/selinux/config

#找到SELINUX=这一行，将其值从enforcing改为disabled。

 SELINUX=disabled

1.3、关闭防火墙或者开发端口（tcp:3306,4567）

二、安装mariadb-galera 数据库集群

2.1、yum安装

yum -y install mariadb-server-galera rsync mariadb-server-utils

2.2、启动

systemctl start mariadb
systemctl enable mariadb

2.3、配置一个同步账号vivi

create user 'vivi'@'%' identified by 'your_password';
GRANT ALL PRIVILEGES  ON *.* TO 'vivi'@'%'  WITH GRANT OPTION;
FLUSH PRIVILEGES;

2.4、登录到数据库集群配置目录，配置同步服务galera

vim /etc/my.cnf.d/galera.cnf

[mysqld]
server_id=2
binlog_format=row
default_storage_engine=InnoDB
innodb_file_per_table=1
innodb_autoinc_lock_mode=2

wsrep_on=ON
wsrep_provider=/usr/lib64/galera/libgalera_smm.so
wsrep_cluster_name='galera'
wsrep_cluster_address='gcomm://'
#wsrep_cluster_address='gcomm://10.0.2.100,10.0.2.101,10.0.2.102'
wsrep_node_name='mariadb02'
wsrep_node_address='10.0.2.101'
wsrep_sst_auth=vivi:your_password
wsrep_sst_method=rsync

vim /etc/my.cnf.d/ mysql-clients.cnf

[mysql]
default-character-set=utf8mb4

vim /etc/my.cnf.d/mariadb-server.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mariadb/mariadb.log
pid-file=/run/mariadb/mariadb.pid

character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
skip-character-set-client-handshake
default-time_zone='+8:00'
lower_case_table_names=1


max_prepared_stmt_count=500000
max_connections = 5000
auto_increment_increment = 3  # 集群节点总数
auto_increment_offset = 1     # 当前节点偏移值（如节点1设为1，节点2设为2...）

2.5、重启数据库

systemctl restart mysql