I’ve been trying to install Percona onto a 3 node cluster. I cant’ even get the first node to show up a cluster size of 1:
mysql> show status like 'wsrep%';
+--------------------------+----------------------+
| Variable_name | Value |
+--------------------------+----------------------+
| wsrep_cluster_conf_id | 18446744073709551615 |
| wsrep_cluster_size | 0 |
| wsrep_cluster_state_uuid | |
| wsrep_cluster_status | Disconnected |
| wsrep_connected | OFF |
| wsrep_local_bf_aborts | 0 |
| wsrep_local_index | 18446744073709551615 |
| wsrep_provider_name | |
| wsrep_provider_vendor | |
| wsrep_provider_version | |
| wsrep_ready | ON |
+--------------------------+----------------------+
11 rows in set (0.00 sec)
running:
sudo /etc/init.d/mysql bootstrap-pxc
produces this:
[ ok ] Bootstrapping Percona XtraDB Cluster database server: mysqld already running.
So I have no idea why the cluster size is not 1.