MariaDB Galera Cluster on RHEL 9

Nodes: 192.168.1.10 · 192.168.1.11 · 192.168.1.12

Step 1 – Install Galera on all nodes

dnf install -y mariadb-server-galera galera

Step 2 – Configure Node 1 (/etc/mysql/conf.d/galera.cnf)

[mysqld]
binlog_format            = ROW
default-storage-engine   = innodb
innodb_autoinc_lock_mode = 2
bind-address             = 0.0.0.0
wsrep_on                 = ON
wsrep_provider           = /usr/lib/galera/libgalera_smm.so
wsrep_cluster_name       = "mariadb_cluster"
wsrep_cluster_address    = "gcomm://192.168.1.10,192.168.1.11,192.168.1.12"
wsrep_node_address       = "192.168.1.10"
wsrep_node_name          = "node1"
wsrep_sst_method         = rsync

Step 3 – Bootstrap Node 1

systemctl stop mariadb
galera_new_cluster

SHOW STATUS LIKE 'wsrep_cluster_size';   -- 1

Step 4 – Start remaining nodes

Configure with correct wsrep_node_address / wsrep_node_name, then:

systemctl start mariadb

SHOW STATUS LIKE 'wsrep_cluster_size';   -- 3