I need help setting up a cluster for Percona MySQL 5.7, I tried setting it up on Ubuntu 20 following this documentation Installing Percona Server for MySQL 5.7 on Debian and Ubuntu - Percona Server for MySQL but when I check the database via
show status like 'wsrep%';
The result shows empty instead of showing the cluster size and other info.
Hi, you are following the instructions for Percona Server, which is drop-in replacement for Oracle MySQL but does not have clustering. What you want is Percona XtraDB Cluster instead. Here’s the documentation you should be following: Installing Percona XtraDB Cluster on Debian or Ubuntu - Percona XtraDB Cluster
Thanks Ivan, I was following the wrong guide all along
Just FYI, you should be doing 8.0 as 5.7 will die Oct 2023.