Database Administrators Asked by Kevin C on November 21, 2021
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://...
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.
Answered by jerichorivera on November 21, 2021
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.
Answered by Flourid on November 21, 2021
Get help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP