InsideDarkWeb.com

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

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

Database Administrators Asked by Kevin C on November 21, 2021

2 Answers

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!

Related Questions

duplicate key error index MongoDB

1  Asked on December 16, 2020 by simonell

     

Why is Postgres service failing?

1  Asked on December 13, 2020 by mike_butak

   

MySQL Shell dump utility – maximum possible chunk size?

1  Asked on December 10, 2020 by mihir-rane

   

Dbca hangs at 59%

0  Asked on December 6, 2020 by user133197

 

Ask a Question

Get help from others!

© 2021 InsideDarkWeb.com. All rights reserved.