pxc5.7集群本地安装

1.安装基础依赖包

yum install -y net-tools ntp unzip zip perl perl-devel libaio libaio-devel perl-Time-HiRes perl-DBD-MySQL rsync perl perl-Digest-MD5 libev.* lrzsz

2.配置percona安装源

yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm

3.使用percona-release工具管理版本

percona-release enable original

4.安装qpress和xtrabackup

wget https://repo.percona.com/yum/release/7/RPMS/x86_64/qpress-11-1.el7.x86_64.rpm
wget https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.4/\
binary/redhat/7/x86_64/percona-xtrabackup-24-2.4.4-1.el7.x86_64.rpm

rpm -ivh percona-xtrabackup-24-2.4.4-1.el7.x86_64.rpm
rpm -ivh qpress-11-1.el7.x86_64.rpm 

5.下载pxc5.7安装包并本地安装

https://www.percona.com/downloads/Percona-XtraDB-Cluster-57/LATEST/
yum localinstall -y --skip-broken Percona-XtraDB-Cluster*

6.初始化mysql

启动mysql
service mysql start
修改root密码
cat /var/log/mysqld.log | grep "A temporary password"
mysql_secure_installation

创建xtrabakcup同步账号
mysql -u root -p

CREATE USER 'admin'@'%' IDENTIFIED BY 'Abc_123456';
GRANT all privileges ON *.* TO 'admin'@'%';
FLUSH PRIVILEGES;

7.配置pxc

[root@node1 ~]# ls /etc/percona-xtradb-cluster.conf.d/
mysqld.cnf  mysqld_safe.cnf  wsrep.cnf
[root@node1 ~]# 

server-id=1  #PXC集群中MySQL实例的唯一ID，不能重复，必须是数字
wsrep_provider=/usr/lib64/galera3/libgalera_smm.so
wsrep_cluster_name=pxc-cluster  #PXC集群的名称
wsrep_cluster_address=gcomm://192.168.56.61,192.168.56.62,192.168.56.63
wsrep_node_name=pxc1  #当前节点的名称
wsrep_node_address=192.168.56.61  #当前节点的IP
wsrep_sst_method=xtrabackup-v2  #同步方法（mysqldump、rsync、xtrabackup）
wsrep_sst_auth= admin:Abc_123456  #同步使用的帐户
pxc_strict_mode=ENFORCING  #同步严厉模式
binlog_format=ROW  #基于ROW复制（安全可靠）
default_storage_engine=InnoDB  #默认引擎
innodb_autoinc_lock_mode=2  #主键自增长不锁表

8.主节点的启动命令

systemctl start mysql@bootstrap.service
systemctl stop mysql@bootstrap.service
systemctl restart mysql@bootstrap.service

9.非主节点启动

service start mysql
service stop mysql
service restart mysql

注：
非主节点启动过程中会加入集群并同步数据,启动过程中可查看日志
tailf /var/log/mysqld.log

10.节点启动成功后,查看pxc集群状态

mysql> show status like 'wsrep_cluster%' ;
+--------------------------+--------------------------------------+
| Variable_name            | Value                                |
+--------------------------+--------------------------------------+
| wsrep_cluster_weight     | 3                                    |
| wsrep_cluster_conf_id    | 3                                    |
| wsrep_cluster_size       | 3                                    |
| wsrep_cluster_state_uuid | 3f28da1d-e451-11ea-bb91-2304743d587b |
| wsrep_cluster_status     | Primary                              |
+--------------------------+--------------------------------------+
5 rows in set (0.00 sec)

11.pxc节点启动与关闭

[root@node1 ~]# find / -name grastate.dat
/var/lib/mysql/grastate.dat

• 如果最后关闭的PXC节点是安全退出的，那么下次启动要最先启动这个节点，而且要以主节点启动
• 如果最后关闭的PXC节点不是安全退出的，那么要先修改/var/lib/mysql/grastate.dat 文件，把其中的safe_to_bootstrap属性值设置为1，再作为主节点启动