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
[root@ppdb01 ~]# mysql -V
mysql Ver 14.14 Distrib 5.6.41-84.1, for Linux (x86_64) using 6.2
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.
Thanks for your reply.
what if i upgrade to 5.7 and then another upgrade to 8.
is that possible?
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.