galera wsrep_cluster_address value

Question

I am trying to deploy galera multimaster replication but faced some problems, google does not solve it it seems, but I see some people had the same problems in the past.

Say, I have 3 servers

• 192.168.1.1
• 192.168.1.2
• 192.168.1.3

first I figured out that primary node has to be intianalized like this only once (init system independent below).

/etc/init.d/mysql start --wsrep-new-cluster

how should the wsrep_cluster_address="gcomm://" kook like on the each node?

somewhere I read it has to list each address on the each node:

like wsrep_cluster_address="gcomm://192.168.1.1,192.168.1.2,192.168.1.3"

Further googling showed that primary node should only have

wsrep_cluster_address="gcomm://"

then the second node:

wsrep_cluster_address="gcomm://192.168.1.1"

and the thrid:

wsrep_cluster_address="gcomm://192.168.1.1,192.168.1.2

Sorry if it looks too long, I have been digging up for 4 days already every day :/

Answer 1

wsrep_cluster_address is a comma-separated list in quotation marks, with all the nodes

e.g.:

wsrep_cluster_address="gcomm://192.168.0.1,192.168.0.2,192.168.0.3"

For more info see the official documentation here