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

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

@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.

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 ?

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.

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