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


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://,,"

Further googling showed that primary node should only have


then the second node:


and the thrid:


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

  • You've actually got two separate questions (as best I can tell). I recommend taking the second question out of this, and posting as another question. Otherwise, it may be closed as too broad.
    – RDFozz
    Jul 17, 2018 at 22:34
  • @RDFozz, well, I am gentoo user and it seems I forgot to check my db installation being compiled with proper SST methods (they are all disabled by default), enabled percona and rsync on compile, so the second part was just dropped.
    – M.Mass
    Jul 18, 2018 at 1:38
  • @M.Mass - If that is the "Answer", then self-Answer. And elaborate a little.
    – Rick James
    Jul 18, 2018 at 1:45
  • @RickJames, no, not really, I am still confused about what should wsrep_cluster_address include
    – M.Mass
    Jul 18, 2018 at 1:47

1 Answer 1


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



For more info see the official documentation here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.