| 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
| 
转播
