Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I'm configuring Percona XtraDB Cluster 8 on two nodes, and use a 3rd node to act as an arbiter.
I cannot make up out of the docs whether to add the IP of the arbiter in the galera nodes addresses of the arbiter’s configuration.
# A comma-separated list of node addresses (address[:port]) in the cluster
# GALERA_NODES=""
Also, do I add the IP of the arbiter in the wsrep_clsuter_address of the Galera configuration? Again, it's not described in the docs.
wsrep_cluster_address=gcomm://...
While I too could not find a definite answer in the documentation, the following link states:
Which leads me to believe that yes, you would have to add the Arbitrator IPs to all configuration files as if it were another node.
EDIT: This guide seems to indicate the same, although it is not official documentation.
I would suggest adding the IP and port of the garbd node in the wsrep_cluster_address and in the GALERA_NODES parameter. It is not a strict requirement but considering the garbd is still a member of the cluster albeit it is not a data bearing node it would be best to keep all nodes in the gcomm:// list. However, there is no strict requirement but remember that the garbd node also becomes a "relay" in case of a network connection glitch between two data nodes in a 3-node cluster.
