Bootstrap a Percona XtraDB Cluster on AlmaLinux 9

Nodes: 192.168.1.10 (bootstrap) · 192.168.1.11 · 192.168.1.12

Step 1 – Configure Node 1 (/etc/my.cnf)

[mysqld]
server-id            = 1
wsrep_on             = ON
wsrep_provider       = /usr/lib64/galera4/libgalera_smm.so
wsrep_cluster_name   = "pxc_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     = xtrabackup-v2
wsrep_sst_auth       = sstuser:SSTpass!
innodb_autoinc_lock_mode = 2
binlog_format        = ROW

Step 2 – Open firewall ports (all nodes)

# RHEL/AlmaLinux
firewall-cmd --permanent --add-port={3306,4444,4567,4568}/tcp && firewall-cmd --reload
# Ubuntu/Debian
ufw allow 3306/tcp && ufw allow 4444/tcp && ufw allow 4567/tcp && ufw allow 4568/tcp

Step 3 – Bootstrap Node 1

systemctl stop mysql
systemctl start mysql@bootstrap

Step 4 – Create SST user

CREATE USER 'sstuser'@'localhost' IDENTIFIED BY 'SSTpass!';
GRANT PROCESS, RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'sstuser'@'localhost';
FLUSH PRIVILEGES;

Step 5 – Verify

SHOW STATUS LIKE 'wsrep_cluster_size';       -- should be 1
SHOW STATUS LIKE 'wsrep_local_state_comment'; -- Synced