Upgradin Percona Components

MySQL & MariaDB
1

Hi

We have percona xtradb cluster in following version

backup: tpercona-xtradb-cluster-operator:1.13.0-pxc8.0-backup-pxb8.0.32
pxc: percona-xtradb-cluster:8.0.32-24.2
operator: percona-xtradb-cluster-operator:1.13.0

and we want to upgrade them to following version

backup: docker.io/percona/percona-xtradb-cluster-operator:1.17.0-pxc8.0-backup-pxb8.0.35
pxc: docker.io/percona/percona-xtradb-cluster:8.0.41-32.1
operator:docker.io/perconalab/percona-xtradb-cluster-operator:1.17.0

What is the best way to do it?

Our first approach;

-take backup of mysql from old env

-uninstall existing env and install new env with new version

-restore backup to new env

1- Is this approach work or not?

2- This approach takes downtime, is there anyway to upgrade new env without downtime or limited downtime

3- Can the replication be used for this upgrade

Regards

2

Here, you can check if you can utilize the cross-site cluster replication to achieve your goal.

3

Hi @Abhinav_Gupta

actually i am asking which method i should use? i hope to get feedback from someone who has experience on it

Regards

4

Hello @acelayir

If you are talking about taking a backup, uninstalling, installing a new version and then restoring. This will take a significant amount of time, depending on the database size and available resources.

Yes as my colleague mentioned, you can create a replication, upgrade the new environment and cutover. This will require only the limited downtime during cutover.

You can also use the operator-recommended upgrade in our documentation,

We suggest you to go through this document as the upgrade is quite a long jump from 1.13.0 to 1.17.0

Also, you should plan for 1.18.0 as it is the latest version