Install Percona XtraDB Cluster (PXC) on OpenBSD 7.5

PXC provides synchronous multi-master MySQL replication using the Galera library.

Step 1 – Install

# PXC is primarily packaged for RHEL/Debian.
# On OpenBSD 7.5, use Percona's binary tarball:
# https://www.percona.com/downloads/Percona-XtraDB-Cluster/

Step 2 – Initial root password

grep 'temporary password' /var/log/mysqld.log
mysql -u root -p
# ALTER USER 'root'@'localhost' IDENTIFIED BY 'StrongRoot123!';

Architecture

  Node 1 (192.168.1.10) <──► Node 2 (192.168.1.11) <──► Node 3 (192.168.1.12)
         All writes replicated synchronously via wsrep / Galera

Next: Bootstrap the cluster then add nodes.