mysql-集群-二进制部署

所有主机上操作
一、环境清理
yum erase $(rpm -qa | grep mysql) -y ; yum erase $(rpm -qa | grep mariadb) -y
##安装epel拓展源
yum install epel-release -y

然后开始搞信任进行相互传输
ssh root@192.168.171.18

##二进制安装包上传到这里
mkdir /soft
cd /soft

含有wsrep补丁mysql的二进制包下载地址
http://releases.galeracluster.com/mysql-wsrep-5.7/binary/mysql-wsrep-5.7.43-25.35-linux-x86_64.tar.gz

mysql-wsrep-相关包下载地址
http://releases.galeracluster.com/mysql-wsrep-5.7/centos/7/x86_64/

galera下载地址
http://releases.galeracluster.com/galera-3/centos/7/x86_64/
要下载的文件列表
galera-3-25.3.37-1.el7.x86_64.rpm

同步安装包至其他主机
rsync -avz /soft root@192.168.241.25:/
rsync -avz /soft root@192.168.241.26:/

在全部主机上操作，进行二进制包安装(含有wsrep补丁)
开始部署
cd /soft
INSTALLDIR=‘/usr/local/mysql’
INIT_PASSWD_MODE=‘initialize-insecure’

##解包建账号授权
tar xzvf mysql-wsrep-5.7.43-25.35-linux-x86_64.tar.gz
mv mysql-wsrep-5.7.43-25.35-linux-x86_64 ${INSTALLDIR}
id mysql &>/dev/null || useradd -M -s /sbin/nologin mysql
chown -R mysql:mysql ${INSTALLDIR}

安装相关包
yum install epel-release
yum install galera lsof -y
rpm -qa|egrep ‘galera|rsync|lsof’

#检查一下是否有mysql
cd /usr/local

开始配置集群
在第一台主机上操作,创建新集群

##查看一下路径 find / -name libgalera_smm.so
跟wsrep_provider路径是否一致
/usr/lib64/galera/libgalera_smm.so

cat >/etc/my.cnf<<EOF
[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/usr/local/mysql/data/mysql.sock
port=3306
default-storage-engine = innodb
innodb_large_prefix=on
innodb_file_per_table = on
innodb_file_per_table
max_connections = 10000
collation-server = utf8_general_ci
character_set_server=utf8
user=mysql
log-error=/usr/local/mysql/mysql.log
##galera_conf
server-id=1
binlog_format=row
innodb_file_per_table=1
innodb_autoinc_lock_mode=2
wsrep_on=ON
wsrep_provider=/usr/lib64/galera/libgalera_smm.so
wsrep_cluster_name=‘galera’
wsrep_cluster_address=‘gcomm://’
wsrep_node_name=‘galera1’
wsrep_node_address=‘192.168.171.17’
wsrep_sst_auth=syncuser:‘QianFeng@123’
wsrep_sst_