Upgrade only galera version in xtradb cluster

MySQL & MariaDB Percona XtraDB Cluster 8.x
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