Galera Cluster安装配置

官网https://blog.csdn.net/danielchan2518/article/details/86608216

安装教程https://blog.csdn.net/jeanette_zlj/article/details/79550690

配置mariadb-galera源
https://downloads.mariadb.org/mariadb-galera/10.0.38/#os_group=rpm_package
最终选择源地址为
http://mirror.ufscar.br/mariadb//mariadb-10.0.38/yum/centos/7Server/x86_64/
配置galera.repo

在这里插入代码片

安装

yum install MariaDB-Galera-server galera

==========================================================================================================================
 Package                            架构                版本                                    源                   大小
==========================================================================================================================
正在安装:
 MariaDB-Galera-server              x86_64              10.0.38-1.el7.centos                    galera               32 M
      替换  mariadb-server.x86_64 1:5.5.64-1.el7
 MariaDB-client                     x86_64              10.0.38-1.el7.centos                    galera               10 M
      替换  mariadb.x86_64 1:5.5.64-1.el7
 MariaDB-shared                     x86_64              10.0.38-1.el7.centos                    galera              1.2 M
      替换  mariadb-libs.x86_64 1:5.5.64-1.el7
 galera                             x86_64              25.3.25-1.rhel7.el7.centos              galera              8.1 M
为依赖而安装:
 MariaDB-common                     x86_64              10.0.38-1.el7.centos                    galera               43 k
 boost-program-options              x86_64              1.53.0-27.el7                           base                156 k
 lsof                               x86_64              4.87-6.el7                              base                331 k
 rsync                              x86_64              3.1.2-6.el7_6.1                         base                404 k

事务概要
==========================================================================================================================
安装  4 软件包 (+4 依赖软件包)

总下载量：52 M
Is this ok [y/d/N]:

安装完成后，配置/etc/my.cnf.d/server.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-grant-table
symbolic-links=0

log-error=/var/log/mysqld.log
pidfile=/var/run/mysqld/mysqld.pid
server-id=101

default-storage-engine=innodb
innodb_autoinc_lock_mode=2
innodb_locks_unsafe_for_binlog=1
query_cache_size=0
query_cache_type=0
bind-address=0.0.0.0  #开启远程访问

wsrep_provider=/usr/lib64/galera/libgalera_smm.so
wsrep_provider_options='gmcast.listen_addr=tcp://172.18.0.164:4567' #修改为本节点地址
wsrep_cluster_name="my_wsrep_cluster" #集群名称，所有节点配置为同一个
wsrep_cluster_address=gcomm://172.18.0.164,172.18.0.144,172.18.0.110 #节点中所有节点地址
wsrep_node_name=node01 #node名称，每个节点名称唯一
wsrep_node_address='172.18.0.164' #本节点地址
wsrep_slave_threads=1
wsrep_certify_nonPK=1
wsrep_max_ws_rows=131072
wsrep_max_ws_size=1073741824
wsrep_debug=0
wsrep_convert_LOCK_to_trx=0
wsrep_retry_autocommit=1
wsrep_auto_increment_control=1
wsrep_drupal_282555_workaround=0
wsrep_causal_reads=0
wsrep_notify_cmd=
wsrep_sst_method=rsync
wsrep_sst_auth=root:123 #数据量库用户名密码
wsrep_sst_donor='node01,node02,node03' #节点中所有节点的node名称