sudo su -
nano /etc/hosts
10.5.108.14 node-01 node-01
10.5.108.13 node-02 node-02
10.5.108.15 node-03 node-03
10.5.108.16 node-04 node-04

[galera]
# Mandatory settings
wsrep_on=ON
wsrep_provider=/usr/lib/galera/libgalera_smm.so
wsrep_cluster_name="linoxide-cluster"
wsrep_cluster_address="gcomm://node-01,node-02,node-03"

binlog_format=row
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
#
# Allow server to accept connections on all interfaces.
#
bind-address=0.0.0.0
#
wsrep_sst_method=rsync

wsrep_node_address="10.32.84.135"
wsrep_node_name="node-01"

CREATE USER 'maxscale'@'%' IDENTIFIED BY 'you-password-here';
Query OK, 0 rows affected (0.00 sec)

GRANT SELECT ON mysql.db TO 'maxscale'@'%';
Query OK, 0 rows affected (0.01 sec)

GRANT SELECT ON mysql.user TO 'maxscale'@'%';
Query OK, 0 rows affected (0.01 sec)

GRANT SHOW DATABASES ON *.* TO 'maxscale'@'%';
Query OK, 0 rows affected (0.01 sec)

ufw allow 4006
ufw allow 4007

[maxscale]
admin_host=0.0.0.0
admin_port=8989
admin_secure_gui=false
log_info=true
# The number of worker threads that are handling the events coming from the kernel.
threads=auto

#admin_ssl_key=/var/lib/maxscale/certs/server.key
#admin_ssl_cert=/var/lib/maxscale/certs/server.crt
#admin_ssl_ca_cert=/var/lib/maxscale/certs/ca.crt

# Enable or disable the substitution of environment variables in the MaxScale configuration file
substitute_variables=true
# Enable or disable the logging of messages whose syslog priority is notice
log_notice=on
syslog=0
maxlog=1

#List of servers in the Cluster
[stg-galeramaster101]
type=server
address=10.5.108.14
port=3306
protocol=MariaDBBackend
priority=1

[stg-galeramaster102]
type=server
address=10.5.108.13
port=3306
protocol=MariaDBBackend
priority=2

[stg-galeramaster103]
type=server
address=10.5.108.15
port=3306
protocol=MariaDBBackend
priority=3


# Monitoring for the Galera server nodes
[Galera-Monitor]
type=monitor
module=galeramon
servers=stg-galeramaster101,stg-galeramaster102,stg-galeramaster103
user=<username>
password=<password>
monitor_interval=200
use_priority=true
available_when_donor=true

# This will ensure that the current master remains the master as long as it's up and dunning
disable_master_failback=true
backend_connect_timeout=3s
backend_write_timeout=3s
backend_read_timeout=3s


# Galera Read/Write Splitter service
[Galera-RW-Service]
type=service
router=readwritesplit
servers=stg-galeramaster101,stg-galeramaster102,stg-galeramaster103
user=<username>
password=<password>
master_reconnection=true
transaction_replay=true
transaction_replay_retry_on_deadlock=true
master_failure_mode=error_on_write
# ADAPTIVE_ROUTING, based on server average response times. See below.
slave_selection_criteria=ADAPTIVE_ROUTING

# Galera cluster listener
[Galera-Listener]
type=listener
service=Galera-RW-Service
protocol=MariaDBClient
port=4006
address=0.0.0.0

[Replication-Service]
type=service
router=readconnroute
router_options=master
servers=stg-galeramaster101,stg-galeramaster102,stg-galeramaster103
user=<username>
password=<password>

[Replication-Listener]
type=listener
service=Replication-Service
protocol=MariaDBClient
port=4007
address=0.0.0.0