https://galeracluster.com/downloads/

# mariadb

yum remove -y mariadb-libs 

yum install -y unzip boost-devel lsof perl-DBI perl-Data-Dumper

rpm -ivh MariaDB-10.0.37-centos73-x86_64-*

rpm -ivh MariaDB-Galera-10.0.37-centos73-x86_64-*

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

node1:

vim  /etc/my.cnf.d/server.conf

[galera]
# Mandatory settings
wsrep_provider= /usr/lib64/galera/libgalera_smm.so
wsrep_cluster_address="gcomm://192.168.20.1,192.168.20.2,192.168.20.3"
wsrep_cluster_name = 'mycluster'
wsrep_node_name = 'jiankong01.yl.com'
wsrep_node-address = '192.168.20.1'
binlog_format=row
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0

node2:

vim  /etc/my.cnf.d/server.conf

[galera]
# Mandatory settings
wsrep_provider= /usr/lib64/galera/libgalera_smm.so
wsrep_cluster_address="gcomm://192.168.20.1,192.168.20.2,192.168.20.3"
wsrep_cluster_name = 'mycluster'
wsrep_node_name = 'jiankong02.yl.com'
wsrep_node-address = '192.168.20.2'
binlog_format=row
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0

node3:

vim  /etc/my.cnf.d/server.conf

[galera]
# Mandatory settings
wsrep_provider= /usr/lib64/galera/libgalera_smm.so
wsrep_cluster_address="gcomm://192.168.20.1,192.168.20.2,192.168.20.3"
wsrep_cluster_name = 'mycluster'
wsrep_node_name = 'jiankong03.yl.com'
wsrep_node-address = '192.168.20.3'
binlog_format=row
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0

 # 启动集群

---在 集群的 任意一个节点(node3)上 执行

service mysql start --wsrep-new-cluster

---其他节点(node1,node2)执行

service mysql start

#创建数据库实例

node3:  

mysql -uroot -p

create database abc;

node1,node2:

show databases;