Upgrading Percona xtradb cluster

MySQL & MariaDB Percona XtraDB Cluster 8.x
1

Problem: We are unable to upgrade percona xtradb cluster from 8.0.30-22-1 to 8.0.31-22-1 on master node where percona xtra backup is installed

What we have done to install percona xtra db cluster and percona xtra backup:

  1. sudo apt update
  2. sudo apt install -y wget gnupg2 lsb-release curl
  3. wget https://repo.percona.com/apt/percona-release_latest.generic_all.deb
  4. sudo dpkg -i percona-release_latest.generic_all.deb
  5. sudo apt update
  6. sudo percona-release setup pxc80
  7. sudo apt install -y percona-xtradb-cluster
  8. wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb
  9. sudo dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb
  10. percona-release enable-only tools release
  11. sudo apt update
  12. sudo apt install percona-xtrabackup-80
2

Why did you run steps #8 and #9? Those are just duplicate steps of #3 and #4.

In order to upgrade PXC 8.0.30 to 8.0.31, you simply need to install/upgrade the PXC package on each PXC node, one at a time.

Shutdown node3. Upgrade node3. Start PXC node3. It will upgrade and then IST any delta. Repeat for node2. Repeat for node1. Do not write to any node which is 8.0.31 until ALL nodes are 8.0.31.