PXC

centos8下安装pxc-80

官方地址

https://www.percona.com/doc/percona-repo-config/index.html

https://www.percona.com/doc/percona-xtradb-cluster/LATEST/install/yum.html#yum

yum仓库配置

# 安装仓库管理器
yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm -y

# 禁用mysql模组
yum module disable mysql -y

安装pxc

# 安装pxc
percona-release enable-only pxc-80 release
percona-release enable tools release
yum install percona-xtradb-cluster -y

初始化及配置

# 创建证书文件
mkdir -p /etc/mysql/certs/
mysql_ssl_rsa_setup -d /etc/mysql/certs/
# 将文件复制到集群所有节点的/etc/mysql/certs/目录，并设置所有者为mysql
scp /etc/mysql/certs/* 10.1.1.22:/etc/mysql/certs/
chown -R mysql:mysql /etc/mysql/

编辑/etc/my.cnf

# /etc/my.cnf
[mysqld]
ssl-ca = /etc/mysql/certs/ca.pem
ssl-cert = /etc/mysql/certs/server-cert.pem
ssl-key = /etc/mysql/certs/server-key.pem
datadir=/var/lib/mysql
socket=/tmp/mysql.sock
log-error=/var/log/mysqld.log
skip-host-cache
binlog_format=ROW
default_storage_engine=InnoDB
innodb_flush_log_at_trx_commit  = 0
innodb_flush_method             = O_DIRECT
innodb_file_per_table           = 1
innodb_autoinc_lock_mode=2
bind_address = 0.0.0.0
wsrep_slave_threads=2
wsrep_cluster_address=gcomm://10.1.1.20,10.1.1.21,10.1.1.22 # 集群地址
wsrep_provider=/usr/lib64/galera4/libgalera_smm.so
wsrep_cluster_name=pxc-cluster
#wsrep_node_address=10.1.1.20 # 所在节点的ip地址，可以不配置
wsrep_sst_method=xtrabackup-v2
[client]
socket=/tmp/mysql.sock
ssl-ca = /etc/mysql/certs/ca.pem
ssl-cert = /etc/mysql/certs/client-cert.pem
ssl-key = /etc/mysql/certs/client-key.pem
[sst]
progress=/var/lib/mysql/sst_in_progress
encrypt = 4
ssl-ca = /etc/mysql/certs/ca.pem
ssl-cert = /etc/mysql/certs/server-cert.pem
ssl-key = /etc/mysql/certs/server-key.pem

将配置文件复制到其他节点 scp /etc/my.cnf 10.1.1.22:/etc ，并修改wsrep_node_address的值为对应的节点ip

启动集群

# 启动初始化节点
systemctl start mysql@bootstrap.service

初始化节点配置

# 查询密码
grep 'temporary password' /var/log/mysqld.log
# 初始化设置
mysql_secure_installation

# 登陆配置
mysql -u root -p
# select * from mysql.user where User='root' \G;
update mysql.user set Host='%' where User='root';
flush privileges;

其他节点加入集群

systemctl start mysql

集群查看 show status like 'wsrep_cluster%';

其他

# 安装percona-server
percona-release enable ps-80 release
# percona-release setup ps80
yum install percona-server-server
# 开启防火墙
firewall-cmd --add-port=3306/tcp --add-port=4444/tcp --add-port=4567/tcp --add-port=4568/tcp --permanent
firewall-cmd --reload