MySQL 8.0使用PXC实现高可用
MySQL 8.0使用PXC实现高可用
-
环境说明
-
Pre-task preparation
-
PXC安装
-
验证集群同步状态
-
环境说明
序号 操作系统 IP 主机名 备注
1 CentOS7.6 192.168.100.33 node1
2 CentOS7.6 192.168.100.22 node2
3 CentOS7.6 192.168.100.55 node3
- Pre-task preparation
2.1 config hostname、hosts file、ip address
cat /etc/hosts
cat > /etc/hosts > /etc/sysctl.conf > /etc/security/limits.conf
mysql> ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘rootPass’;
Query OK, 0 rows affected (0.02 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.02 sec)
systemctl stop mysql
[root@node1 ~]# systemctl stop mysql
3.6 编辑配置文件/etc/my.cnf
node1：
[root@node1 ~]# grep -Ev “#|$” /etc/my.cnf
[client]
socket=/var/lib/mysql/mysql.sock
[mysqld]
server-id=333306
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
binlog_expire_logs_seconds=604800
wsrep_provider=/usr/lib64/galera4/libgalera_smm.so
wsrep_cluster_address=gcomm://192.168.100.33,192.168.100.22,192.168.100.55
binlog_format=ROW
wsrep_slave_threads=8
wsrep_log_conflicts
innodb_autoinc_lock_mode=2
wsrep_node_address=192.168.100.33
wsrep_cluster_name=pxc-cluster
wsrep_node_name=pxc-cluster-node-1
pxc_strict_mode=ENFORCING
wsrep_sst_method=xtrabackup-v2
wsrep_provider_options=“socket.ssl_key=server-key.pem;socket.ssl_cert=server-cert.pem;socket.ssl_ca=ca.pem”
[sst]
encrypt=4
ssl-key=server-key.pem
ssl-ca=ca.pem
ssl-cert=server-cert.pem
其他节点配置
scp /etc/my.cnf 192.168.100.22:/etc/my.cnf
scp /etc/my.cnf 192.168.100.55:/etc/my.cnf
node2：
