TransWikia.com

Percona XtraDB Cluster - do I add arbiter IP in gcomm://?

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://...

2 Answers

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:

While Galera Arbitrator does not participate in replication, it does receive the same data as all other nodes.

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

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP