本文共 1691 字,大约阅读时间需要 5 分钟。
IP | hostname | 系统版本 | 备注 |
| 原Percona版本 | 新版本 |
10.45.7.128 | rac3 | redhat7.4 | Master节点(node1) | Keepalived双节点 | 5.7.26 | 5.7.27 |
10.45.7.129 | rac4 | redhat7.4 | Standby节点(node2) | |||
10.45.53.31 | rac2 | redhat7.4 | 备份节点(node3) | 5.7.26 | 5.7.27 |
1.先升级备份节点10.45.53.31
(1)卸载原包
rpm -qa|grep Percona
service mysql stop
rpm -e Percona-XtraDB-Cluster-server-57-5.7.26-31.37.1.el7.x86_64
rpm -e Percona-XtraDB-Cluster-shared-compat-57-5.7.26-31.37.1.el7.x86_64
rpm -e Percona-XtraDB-Cluster-devel-57-5.7.26-31.37.1.el7.x86_64
rpm -e Percona-XtraDB-Cluster-shared-57-5.7.26-31.37.1.el7.x86_64
rpm -e Percona-XtraDB-Cluster-client-57-5.7.26-31.37.1.el7.x86_64
rpm -e Percona-XtraDB-Cluster-garbd-57-5.7.26-31.37.1.el7.x86_64
(2)5.7.30及以上的Percona版本需要xtrabackup 2.4.21以上的版本,所以最好更新下xtrabackup版本
rpm -qa|grep percona
rpm -e percona-xtrabackup*
rpm -ivh percona-xtrabackup-24-2.4.21-1.el7.x86_64.rpm
(3)安装PXC
rpm -ivh Percona-XtraDB-Cluster-client-57-5.7.27-31.39.1.el7.x86_64.rpm
rpm -ivh Percona-XtraDB-Cluster-devel-57-5.7.27-31.39.1.el7.x86_64.rpm
rpm -ivh Percona-XtraDB-Cluster-garbd-57-5.7.27-31.39.1.el7.x86_64.rpm
rpm -ivh Percona-XtraDB-Cluster-shared-57-5.7.27-31.39.1.el7.x86_64.rpm
rpm -ivh Percona-XtraDB-Cluster-shared-compat-57-5.7.27-31.39.1.el7.x86_64.rpm
rpm -ivh Percona-XtraDB-Cluster-server-57-5.7.27-31.39.1.el7.x86_64.rpm
mv /etc/my.cnf.rpmsave /etc/my.cnf
mysqld --skip-grant-tables --user=mysql --wsrep-provider='none'(查看/mysql/log/mysqld.log确认启动成功后另开窗口执行mysql_upgrade)
mysql_upgrade -uroot -p*****
kill 掉当前mysql进程
service mysql start
2.升级10.45.7.129按照一样的步骤,但是要保证PXC两节点mysql进程活着,且执行最后一步service mysql start后要service start keepalived,保证升级10.45.7.128时vip可以漂移
3.升级10.45.7.128执行最后一步service mysql start后要service start keepalived
转载地址:http://olwmf.baihongyu.com/