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.99.151 #当前节点的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
/var/lib/mysql/grastate.dat
文件,把其中的safe_to_bootstrap
属性值设置为1,再作为主节点启动