Figure HA-10 · Database tier
MariaDB high availability
Two designs; rConfig always connects through one endpoint to one writer
rConfig
Client traffic
Replication
Monitor
Primary/replica with MaxScale
rConfig active node
DB_HOST = 192.0.2.30
MaxScale
192.0.2.30 · readconnroute · master
second MaxScale or VIP
db1
PRIMARY
MariaDB
db2
REPLICA
MariaDB
mariadbmon · auto_failover
MaxScale sends writes to the primary and promotes db2 if it fails.
Galera cluster
rConfig active node
DB_HOST = 192.0.2.30
MaxScale or ProxySQL
one writer
galera1
WRITER
MariaDB Galera
galera2
MariaDB Galera
galera3
MariaDB Galera
every commit certified
or 2 nodes + garbd