配置mysql8.0使用PXC实现高可用
1
hostnamectl set-hostname pxc1
vim /ect/hosts +
192.168.234.131 pxc1
yum module disable mysql
percona-release setup pxc-80
yum install percona-xtrabd-cluster
vim /etc/my.cnf
server-id=1
wsrep_cluster_address=gcomm://192.168.234.131,192.168.234.132,192.168.234.133
wsrep_node_address=192.168.234.131
wsrep_node_name=pxc1
systemctl start mysql@bootstrap.service
grep -i password /var/log/mysqld.log
mysql -uroot -p'xxxxx'
alter user root@localhost identified by 'xxxxxx'
show status like 'wsrep%';
scp /var/lib/mysql/*.pem pxc2:/var/lib/mysql
xxxxxx
scp /var/lib/mysql/*.pem pxc3:/var/lib/mysql
xxxxxx
2
hostnamectl set-hostname pxc2
vim /ect/hosts +
192.168.234.132 pxc2
percona-release setup pxc-80
yum install percona-xtrabd-cluster
server-id=2
wsrep_cluster_address=gcomm://192.168.234.131,192.168.234.132,192.168.234.133
wsrep_node_address=192.168.234.132
wsrep_node_name=pxc2
cd /var/lib/mysql
rm if *.pem
chown mysql.mysql *.pem
systemctl restart mysql.service
3
hostnamectl set-hostname pxc3
vim /ect/hosts +
192.168.234.133 pxc3
percona-release setup pxc-80
yum install percona-xtrabd-cluster
server-id=3
wsrep_cluster_address=gcomm://192.168.234.131,192.168.234.132,192.168.234.133
wsrep_node_address=192.168.234.133
wsrep_node_name=pxc3
cd /var/lib/mysql
rm if *.pem
chown mysql.mysql *.pem
systemctl restart mysql.service