注：
共需要3台服务器

下载网址：

http://releases.galeracluster.com/galera-3.23/centos/6/x86_64
http://releases.galeracluster.com/mysql-wsrep-5.6/centos

galera-3-25.3.23-2.el6.x86_64.rpm

mysql-wsrep-client-5.6-5.6.43-25.25.el6.x86_64.rpm
mysql-wsrep-libs-compat-5.6-5.6.43-25.25.el6.x86_64.rpm
mysql-wsrep-server-5.6-5.6.43-25.25.el6.x86_64.rpm
mysql-wsrep-shared-5.6-5.6.43-25.25.el6.x86_64.rpm
mysql-wsrep-test-5.6-5.6.43-25.25.el6.x86_64.rpm

第1台：

yum install boost-devel

rpm -U mysql-wsrep-client-5.6-5.6.43-25.25.el6.x86_64.rpm mysql-wsrep-libs-compat-5.6-5.6.43-25.25.el6.x86_64.rpm mysql-wsrep-server-5.6-5.6.43-25.25.el6.x86_64.rpm mysql-wsrep-shared-5.6-5.6.43-25.25.el6.x86_64.rpm mysql-wsrep-test-5.6-5.6.43-25.25.el6.x86_64.rpm

rpm -i /home/setup/Galera/galera-3-25.3.23-2.el6.x86_64.rpm

vi /etc/my.cnf

[mysqld]
datadir=/home/mysqldb/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql

Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

binlog_format=ROW
bind-address=0.0.0.0
default_storage_engine=innodb
innodb_autoinc_lock_mode=2
innodb_flush_log_at_trx_commit=0
wsrep_cluster_name=‘ming‘
wsrep-provider=/usr/lib64/galera-3/libgalera_smm.so
wsrep_cluster_address="gcomm://" （第1台这样写）
wsrep_node_name=gamysql01
wsrep_node_address=10.0.1.2
wsrep_sst_method=rsync
wsrep_sst_auth=ming:xxxxxx

[mysqld_safe]
log-error=/home/mysqldb/mysql_logs/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

:wq

service mysql start --wsrep-new-cluster （第1台第1次加--wsrep-new-cluster,后面服务器不用加）

cat .mysql_secret

mysql -u root -p‘xxxxxx‘

SET PASSWORD for root@‘localhost‘=password(‘xxxxxx‘);
grant all on . to ming@‘10.%‘ identified by ‘xxxxx‘;
flush privileges;
show status like ‘wsrep_%‘; （看到“wsrep_incoming_addresses | 10.0.1.2:3306”说明启动了 ）
exit

第2台：

rpm -U mysql-wsrep-client-5.6-5.6.43-25.25.el6.x86_64.rpm mysql-wsrep-libs-compat-5.6-5.6.43-25.25.el6.x86_64.rpm mysql-wsrep-server-5.6-5.6.43-25.25.el6.x86_64.rpm mysql-wsrep-shared-5.6-5.6.43-25.25.el6.x86_64.rpm mysql-wsrep-test-5.6-5.6.43-25.25.el6.x86_64.rpm

service mysql restart

vi /etc/my.cnf

[mysqld]
datadir=/home/mysqldb/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql

Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

binlog_format=ROW
bind-address=0.0.0.0
default_storage_engine=innodb
innodb_autoinc_lock_mode=2
innodb_flush_log_at_trx_commit=0
wsrep_cluster_name=‘ming‘
wsrep-provider=/usr/lib64/galera-3/libgalera_smm.so
wsrep_cluster_address="gcomm://10.0.1.2,10.0.1.3,10.0.1.4"
wsrep_node_name=gamysql02
wsrep_node_address=10.0.1.3
wsrep_sst_method=rsync
wsrep_sst_auth=ming:xxxxxx

[mysqld_safe]
log-error=/home/mysqldb/mysql_logs/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

:wq

service mysql start

cat .mysql_secret

mysql -u root -p‘xxxxxx‘

SET PASSWORD for root@‘localhost‘=password(‘xxxxxx‘);
grant all on . to ming@‘10.0.1.2‘ identified by ‘xxxxx‘;
flush privileges;
exit

第3台基本同第2台

此时再回到第1台mysql里执行show status like ‘wsrep_%‘;会看到3台服务器

验证：

在任意1台上新建库，其它2台会自动同步

CentOS 6.8搭建Galera Cluster（innodb引擎）

原文：https://blog.51cto.com/yangzhiming/2411978