环境说明:
mysql1 10.200.137.107
mysql2 10.200.137.108
mysql3 10.200.137.109
1、下载安装包
一般通过yum直接安装时速度比较慢,所以可以考虑到官网直接用迅雷下载
下载地址: https://www.percona.com/downloads/Percona-XtraDB-Cluster-LATEST/
下载Percona-XtraDB-Cluster-5.7.18-29.20-r346-el7-x86_64-bundle.tar(该包中包含依赖的各个包)
将下载好的tar包上传到mysql1上,创建PXC目录并解压下载好的包
2、配置yum源
该步骤主要是解决步骤一中的包版本不正确或者缺少时自动到网上下载
yum -y install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm
3、本地安装
yum localinstall Percona-XtraDB-Cluster-57-5.7.18-29.20.1.el7.x86_64.rpm
4、修改密码
查找到root初始化时的临时密码:grep "temporary password" /var/log/mysqld.log
Query OK, 0 rows affected (0.00 sec)
mysql> grant all on *.* to sstuser@'%';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
6、关闭三个节点的数据库服务
vim /etc/percona-xtradb-cluster.conf.d/wsrep.cnf
配置如下:
wsrep_provider=/usr/lib64/galera3/libgalera_smm.so
wsrep_cluster_address=gcomm://10.200.137.107,10.200.137.108,10.200.137.109
binlog_format=ROW
default_storage_engine=InnoDB
wsrep_slave_threads= 8
wsrep_log_conflicts
innodb_autoinc_lock_mode=2
wsrep_node_address=10.200.137.108(本机ip)
wsrep_cluster_name=pxc-cluster
wsrep_node_name=pxc-cluster-node-2(node名称,分别为pxc-cluster-node-【1-3】)
pxc_strict_mode=ENFORCING
wsrep_sst_method=xtrabackup-v2
systemctl start mysql@bootstrap.service
systemctl start mysql
mysql1 10.200.137.107
mysql2 10.200.137.108
mysql3 10.200.137.109
1、下载安装包
一般通过yum直接安装时速度比较慢,所以可以考虑到官网直接用迅雷下载
下载地址: https://www.percona.com/downloads/Percona-XtraDB-Cluster-LATEST/
下载Percona-XtraDB-Cluster-5.7.18-29.20-r346-el7-x86_64-bundle.tar(该包中包含依赖的各个包)
将下载好的tar包上传到mysql1上,创建PXC目录并解压下载好的包
2、配置yum源
该步骤主要是解决步骤一中的包版本不正确或者缺少时自动到网上下载
yum -y install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm
3、本地安装
yum localinstall Percona-XtraDB-Cluster-57-5.7.18-29.20.1.el7.x86_64.rpm
4、修改密码
查找到root初始化时的临时密码:grep "temporary password" /var/log/mysqld.log
数据库安全设置:mysql_secure_installation
5、创建sst用户,在节点1上执行
mysql> create user sstuser@'%' identified by 'mypass@';Query OK, 0 rows affected (0.00 sec)
mysql> grant all on *.* to sstuser@'%';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
6、关闭三个节点的数据库服务
systemctl stop mysql
vim /etc/percona-xtradb-cluster.conf.d/wsrep.cnf
配置如下:
wsrep_provider=/usr/lib64/galera3/libgalera_smm.so
wsrep_cluster_address=gcomm://10.200.137.107,10.200.137.108,10.200.137.109
binlog_format=ROW
default_storage_engine=InnoDB
wsrep_slave_threads= 8
wsrep_log_conflicts
innodb_autoinc_lock_mode=2
wsrep_node_address=10.200.137.108(本机ip)
wsrep_cluster_name=pxc-cluster
wsrep_node_name=pxc-cluster-node-2(node名称,分别为pxc-cluster-node-【1-3】)
pxc_strict_mode=ENFORCING
wsrep_sst_method=xtrabackup-v2
wsrep_sst_auth="sstuser:mypass@"
systemctl start mysql@bootstrap.service
注意:之所以用bootstrap.service启动,是因为这是第一个节点,不用进行数据的同步!
systemctl start mysql