1

I have a Galera cluster with Geo-redundancy setup. First site : 2 Mysql nodes and 1 arbitrator Second site : 2 Mysql nodes and 1 arbitrator Third site : only one arbitrator.

  1. My First question is , in my.cnf file of each mysql node we have wsrep_cluster_address="" Above parameter should have all IP addresses listed ( like MYSQL nodes as well as 3 arbitrators IPs) right ? Is it correct ?
  2. My second question is , in file /etc/sysconfig/garb of each arbitrator, we have GALERA_NODES="" Above parameter should have IPs of only MYSQL nodes ?or it should have MYSQL nodes as well as remaining 2 arbitrator IPs( excluding itself) Please let me know.
gaurav_hodade
  • 11
  • 1
  • 7 nodes seems like overkill. Seems like (2 nodes) + (2 nodes) + (1 garbd) would be just as robust, and possibly faster (due to many fewer links). – Rick James Apr 06 '22 at 23:04

1 Answers1

0

The my.cnf file serves to configure the MYSQL nodes that are part of your Galera cluster, whereas the Galera Arbitrator is started and managed as a seperate and independent process [see this link for more explanation]. Hence, in the wsrep_cluster_address option you add only the MYSQL node addresses.

The /etc/sysconfig/garb system configuration file will be used if you start the garbd as a service, where the argument GALERA_NODES refers to the MYSQL nodes of the cluster.

In both cases, you only add the MYSQL nodes, not the arbitrator itself.

M M
  • 429
  • 5
  • 13