How to upgrade to xtradb cluster from 5.6 to 8

MySQL & MariaDB Percona XtraDB Cluster 8.x
1

Hello,

I’ve 3 nodes running xtra db cluster 5.6 on production VMs. And i need to upgrade to xtra db cluster 8.

How could this be done?
system: CentOS Linux release 7.5.1804 (Core)

[root@ppdb01 ~]# rpm -qa |grep perc
percona-release-0.1-8.noarch
percona-xtrabackup-2.3.10-1.el7.x86_64
percona-toolkit-3.0.12-1.el7.x86_64
[root@ppdb01 ~]# mysql -V
mysql Ver 14.14 Distrib 5.6.41-84.1, for Linux (x86_64) using 6.2

2

Hello @elkhedewy,
Because you are currently on such an old version of PXC, the best solution for you is to create a brand new PXC 8 and import the data. Start with a single PXC 8 node. Bootstrap it. Use mydumper on the 5.6 to dump and then import this into the single PXC8 node. After that is done, start node2, then start node3.

3

Thanks for your reply.
what if i upgrade to 5.7 and then another upgrade to 8.
is that possible?

4

Yes that is. Shut down all but 1 node of PXC 5.6. Upgrade it to 5.7. Disable all galera config. Start plain mysql. Run mysql_upgrade. Shut down mysql. Enable galera config. Bootstrap. Then upgrade mysql on node2. start it normally, let it join node1. it will most likely SST. repeat for node3.
After all 3 nodes are 5.7, repeat the entire process for 8.