MariaDB Galera Cluster Flush-Hosts

[bargent...@gmail.com]

Hi, I have just set up a MariaDB Galera Cluster (latest release) which contains 3 nodes all running Ubuntu 16.04 LTS with all the updates.

These are sitting behind two physical Barracuda 340 load balancers, configured as a TCP Proxy to node with least connections.

I keep getting the error message requiring me to flush-hosts. I have looked in the logs and nothing seems to be showing.

To get round this I set the max_connect_errors=4294967295 and have a cron job to flush the hosts every 5 hours.

This is my config:

[mysqld]

### Custom Configuration

binlog_format=ROW

default-storage-engine=innodb

innodb_autoinc_lock_mode=2

bind-address=0.0.0.0

max_connect_errors=4294967295

skip-name-resolve

#Error/Logs

general_log_file=/var/log/mysql.log

general_log=2

log_error=/var/log/mysql.err

### Replication and Galera Cluster Configuration

# Galera Provider Configuration

wsrep_on=ON

wsrep_provider=/usr/lib/galera/libgalera_smm.so

# Galera Cluster Configuration

wsrep_cluster_name="DMZ_HA_MariaDB_Cluster"

wsrep_cluster_address="gcomm://192.168.1.71,192.168.1.72,192.168.1.73"

# Galera Synchronization Configuration

wsrep_sst_method=rsync

# Galera Node Configuration

wsrep_node_address="192.168.1.71"

wsrep_node_name="DMZ-HA-MariaDB-01"

Ideally I don't want to leave it like that, has anyone had this problems or knows a solution.

Thanks.