Setup Percona XtraDB Cluster with one node

MySQL & MariaDB Percona XtraDB Cluster 5.x
,
1

Hi all,

Is it possible to setup a percona xtradb cluster with just one node? If yes. Is there anything to consider before?

Hope you guys help me…

Thanks

3 Likes
2

Hello Buddy,

That’s a good question, I did it by editing /etc/my.cnf file.

Basically I removed lines that includes others directories.

running 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                   |
+--------------------------+----------------------+

I don’t know if it is the best way to do, Let me know guys if there is another way.

1 Like
3

@Carlos,
Yes, you can run a “cluster of 1” by simply bootstrapping that node. You always and only bootstrap the very first node of a PXC. So if you do this, then you have a cluster of 1.

My question is “why”? That’s not really a cluster, so why do you want only 1 node?

2 Likes