In order to bootstrap your Galera cluster, manually bring up the cluster IP address on the desired interface. In this example, we’ll use 192.168.122.99 and eth1:
ip address add 192.168.122.99/24 dev eth1 label eth1:galera
And initialize the Galera cluster:
mysqld --wsrep_cluster_address=gcomm:// &
Note the empty
An avalanche of output is likely to follow. Near the end, you should see entries similar to these:
[Note] WSREP: Synchronized with group, ready for connections [Note] mysqld: ready for connections.
At this point, your MySQL/Galera cluster is properly initialized. It only has one node, and it is not under cluster management yet, but it’s already a working Galera installation.
This article originally appeared on the
hastexo.com website (now defunct).