云原生第五次作业

配置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
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值