(1)环境介绍
galera官网：/downloads/
# cat /etc/redhat-release
CentOS Linux release 7.3.1611 (Core)
(2)以下配置三台服务器都相同
关闭防火墙和selinux
systemctl disable firewalld
systemctl stop firewalld
sed -ri '/SELINUX=/cSELINUX=disabled' /etc/selinux/config
setenforce 0
配置yum源
cat >>/etc/yum.repos.d/galera.repo<
[galera1]
name=galera1
baseurl=/mysql-wsrep-5.7/centos/7/x86_64/
gpgcheck=0
[galera2]
name=galera2
baseurl=/galera-3/centos/7/x86_64/
gpgcheck=0
EOF
安装mysql和galera插件
yum repolist
yum list | egrep "wsrep|galera"
yum -y install mysql-wsrep-server-5.7.x86_64 rsync galera-3.x86_64 -y
启动mysqld
systemctl start mysqld
systemctl enable mysqld
newpass=$(grep "temporary password" /var/log/mysqld.log | awk '{print $NF}')
mysqladmin -uroot -p"$newpass" password 'Redhat@123'
创建用于数据同步的用户
mysql -uroot -pRedhat@123 -e "grant all on *.* to 'copy'@'192.168.1.%' identified by 'Copy@123'"
mysql -uroot -pRedhat@123 -e "flush privileges;"
(3)修改配置文件：三台不一样
node1:192.168.1.31
#vi /etc/f
binlog_format=row
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0
wsrep_on=ON
wsrep_provider=/usr/lib64/galera-3/libgalera_smm.so
wsrep_cluster_address="gcomm://"
wsrep_cluster_name="test"
wsrep_node_address="192.168.1.31"
wsrep_node_name="node1"
wsrep_sst_auth=copy:Copy@123
wsrep_sst_method=rsync
重启mysqld服务器：systemctl restart mysqld
验证端口状态：ss -anltup | egrep "3306|4567"
node1节点上查看状态
node2:192.168.1.32
#vi /etc/f
binlog_format=row
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0
wsrep_on=ON
wsrep_provider=/usr/lib64/galera-3/libgalera_smm.so
wsrep_cluster_address="gcomm://192.168.1.31,192.168.1.32,192.168.1.33"
wsrep_cluster_name="test"
wsrep_node_address="192.168.1.32"
wsrep_node_name="node2"
wsrep_sst_auth=copy:Copy@123
wsrep_sst_method=rsync
重启mysqld服务器：systemctl restart mysqld
验证端口状态：ss -anltup | egrep "3306|4567"
node3:192.168.1.33
#vi /etc/f
binlog_format=row
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0
wsrep_on=ON
wsrep_provider=/usr/lib64/galera-3/libgalera_smm.so
wsrep_cluster_address="gcomm://192.168.1.31,192.168.1.32,192.168.1.33"
wsrep_cluster_name="test"
wsrep_node_address="192.168.1.33"
wsrep_node_name="node3"
wsrep_sst_auth=copy:Copy@123
wsrep_sst_method=rsync
重启mysqld服务器：systemctl restart mysqld
验证端口状态：ss -anltup | egrep "3306|4567"
注意：node定义刚开始定义集群是wsrep_cluster_address="gcomm://"，如果node1重启Mysql服务，
这个地址需要修改wsrep_cluster_address="gcomm://192.168.1.33,192.168.1.32,192.168.1.31"
参数解释
wsrep_incoming_addresses ：表示集群主机ip
wsrep_cluster_size ：集群主机统计数量
wsrep_connected ：连接状态
如果觉得《mysql galera_（十六）MySQL集群galera实现》对你有帮助，请点赞、收藏，并留下你的观点哦！
