Upgrade only galera version in xtradb cluster

MySQL & MariaDB Percona XtraDB Cluster 8.x
1

Hi Team,
I am currently using xtradb 8.0.28 cluster and want to upgrade only Galera version to 26.4.12 and xtradb cluster(mysql) can only be 8.0.28, my understanding is I can’t download Galera outside Percona website as Percona makes enhancement and bug fixes on Galera and then package it with xtraDB Cluster.

So how can I only upgrade Galera Version available in Xtradb 8.0.29.(tar) package and also MySQL version remains 8.0.28?

I can’t change the MySQL version because it is the only version supported by the application and due to a bug I need to upgrade Galera to 26.4.12.

Is it possible if yes, can only updating the below 2 packages in the current 8.0.28 env will upgrade Galera without any issues? and Galera will be upgraded to which version if I upgrade below 2 RPM in the current running 8.0.28 xtradb cluster?
or can we also use Galera outside Percona if yes how?

percona-xtradb-cluster-garbd-8.0.29-21.1.el8.x86_64.rpm
percona-xtradb-cluster-garbd-debuginfo-8.0.29-21.1.el8.x86_64.rpm

Thanks
Adi

1 Like
2

Hi Team,
I tried to test by just upgrading 2 rpm in above message but these 2 have 2 many dependencies to other 8.0.29 packages.

How can I only upgrade the Galera version to the latest and also keep MySQL version to 8.0.28 under Xtradb Cluster?

root@rhel8t6 percona29]# rpm -Uvh percona-xtradb-cluster-garbd-debuginfo-8.0.29-21.1.el8.x86_64.rpm
warning: percona-xtradb-cluster-garbd-debuginfo-8.0.29-21.1.el8.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 8507efa5: NOKEY
error: Failed dependencies:
	percona-xtradb-cluster-debuginfo(x86-64) = 8.0.29-21.1.el8 is needed by percona-xtradb-cluster-garbd-debuginfo-8.0.29-21.1.el8.x86_64
[root@r percona29]# 
[root@r percona29]# 
[root@rh percona29]# 
[root@rh percona29]# rpm -Uvh percona-xtradb-cluster-garbd-debuginfo-8.0.29-21.1.el8.x86_64
error: open of percona-xtradb-cluster-garbd-debuginfo-8.0.29-21.1.el8.x86_64 failed: No such file or directory
[root@rh percona29]# rpm -Uvh  percona-xtradb-cluster-debuginfo-8.0.29-21.1.el8.x86_64.rpm
warning: percona-xtradb-cluster-debuginfo-8.0.29-21.1.el8.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 8507efa5: NOKEY
error: Failed dependencies:
	percona-xtradb-cluster-debuginfo(x86-64) = 8.0.28-19.1.el8 is needed by (installed) percona-xtradb-cluster-shared-debuginfo-8.0.28-19.1.el8.x86_64
	percona-xtradb-cluster-debuginfo(x86-64) = 8.0.28-19.1.el8 is needed by (installed) percona-xtradb-cluster-test-debuginfo-8.0.28-19.1.el8.x86_64

Thanks
Adi

1 Like
3

Hi Team,
I was able to install percona-xtradb-cluster-garbd-8.0.29 on 8.0.28 ctradb cluster but can’t find from where I can check that the Galera version has now changed to the latest version?

Also wsrep_provider_version still shows 4.11 but I need 26.4.12 Galera version.

rpm -Uvh percona-xtradb-cluster-garbd-8.0.29-21.1.el8.x86_64.rpm 
warning: percona-xtradb-cluster-garbd-8.0.29-21.1.el8.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 8507efa5: NOKEY
Verifying...                          ################################# [100%]
Preparing...                          ################################# [100%]
Updating / installing...
   1:percona-xtradb-cluster-garbd-8.0.################################# [ 50%]
Cleaning up / removing...
   2:percona-xtradb-cluster-garbd-8.0.################################# [100%]
1 Like
4

Hi Team,
After installing percona-xtradb-cluster-garbd-8.0.29, I also copied libgalera_smm.so from another env which is running xtradb cluster 8.0.29 after which wsrep_provider_version has changed to 4.12(04bfb95) but mysql version is still 8.0.28.
But is this a stable solution or some else steps should be followed?

Also another issue is when I login to MySQL prompt it’s still showing 26.4.3 but I need 26.4.12

mysql> show status like 'wsrep_provider_version';
+------------------------+---------------+
| Variable_name          | Value         |
+------------------------+---------------+
| wsrep_provider_version | 4.12(04bfb95) |
+------------------------+---------------+
1 row in set (0.00 sec)

mysql> select @@version;
+-------------+
| @@version   |
+-------------+
| 8.0.28-19.1 |
+-------------+
1 row in set (0.00 sec)

######Login Prompt Still shows 26.4.3####

mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 104
Server version: 8.0.28-19.1 Percona XtraDB Cluster (GPL), 
Release rel19, Revision f544540, WSREP version 26.4.3

Thanks
Adi

1 Like
5

Copying libgalera_smm.so is enough as the API didn’t change between these 2 versions.
The current version of libgalera_smm.so you can check by querying ‘wsrep_provider_version’.
Please note that such configuration “should” work, but is not tested by Percona, so most probably we can provide limited if any, support.

1 Like
6

Thanks @Kamil_Holubicki
For your response.
Thanks
Adi

1 Like