Different versions of MySQL 5.7.x on Ubuntu 22.04 LTS - identical servers

MySQL & MariaDB Percona XtraDB Cluster 5.x
,
1

Hi,

I have 3 bare metal servers which 2 days ago, I upgrade from Ubuntu 20.04 LTS to ubuntu 22.04 LTS AMD/Intel 64 bits.

When I ran the upgrade, some how one of the servers, DB 2 - it has a most recent version of Percona XtraDB MySQL. Here are the versions:

DB 1 and DB 3
Server version: 5.7.43-47-57-log Percona XtraDB Cluster (GPL), Release rel47, Revision 69b5c96, WSREP version 31.65, wsrep_31.65

DB 2
Server version: 5.7.44-48-57-log Percona XtraDB Cluster (GPL), Release rel48, Revision 32be3bd, WSREP version 31.65, wsrep_31.65

And I have another Debian 11 VM which it also has installed: 5.7.44-48-57-log

From the DB 1-2-3 I have the same OS version, which I upgraded from Ubuntu 20.04 LTS to 22.04 LTS at the same hour.

and the 3 Ubuntu Servers are showing the same exact info about the OS, etc


[root@db1 ~]  lsb_release -a
No LSB modules are available.
Distributor ID:	Ubuntu
Description:	Ubuntu 22.04.4 LTS
Release:	22.04
Codename:	jammy


[root@db1 ~]  uname -a
Linux db1 5.15.0-118-generic #128-Ubuntu SMP Fri Jul 5 09:28:59 UTC 2024 x86_64 x86_64 x86_64 GNU/Linux


[root@db1 ~]  cat /etc/os-release
PRETTY_NAME="Ubuntu 22.04.4 LTS"
NAME="Ubuntu"
VERSION_ID="22.04"
VERSION="22.04.4 LTS (Jammy Jellyfish)"
VERSION_CODENAME=jammy
ID=ubuntu
ID_LIKE=debian
HOME_URL="https://www.ubuntu.com/"
SUPPORT_URL="https://help.ubuntu.com/"
BUG_REPORT_URL="https://bugs.launchpad.net/ubuntu/"
PRIVACY_POLICY_URL="https://www.ubuntu.com/legal/terms-and-policies/privacy-policy"
UBUNTU_CODENAME=jammy

Then, how I can upgrade the 5.7.43-47-57-log Percona XtraDB Cluster to 5.7.44-48-57-log Percona XtraDB Cluster on my DB 1 and DB 3.

Thanks

2

@jbiancot, you can stop PXC on node1. Upgrade the package. Start MySQL. Wait for IST/join. Repeat for node3. This is the typical “rolling upgrade” process.

3

Hi,

The data is fine, I don’t have a problem, what I’d like to know is how I can install the same binaries which DB2 (more up-to-date) has in comparison to DB1 and DB3 ?

4

Hi @jbiancot, yes, I explained how to install the same binaries in my previous comment. Stop mysql on DB1. Install the updated package (ex: apt update mysql) (<-- that’s not the correct command, you need to look up the correct command for your package manager).

After the new package is installed, start mysql back up. It’s that simple.

5

You also need to update Percona apt file to get correct package