centos 6.8 mysql集群_CentOS 6.8搭建Galera Cluster（innodb引擎）

注：

共需要3台服务器

下载网址：

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 [email protected]=password(‘xxxxxx‘);

grant all on . to [email protected]%‘ 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 [email protected]=password(‘xxxxxx‘);

grant all on . to [email protected] identified by ‘xxxxx‘;

flush privileges;

exit

第3台基本同第2台

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

验证：

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

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