Install Percona XtraDB Cluster (PXC) on NetBSD 10

Percona XtraDB Cluster provides multi-master MySQL replication using the Galera library with zero data loss.

Step 1 – Install PXC

# Percona XtraDB Cluster is primarily packaged for RHEL/Debian families.
# On NetBSD 10, use Percona's binary tarball:
# https://www.percona.com/downloads/Percona-XtraDB-Cluster/
# Or consider MariaDB with Galera Cluster as an alternative.

Step 2 – Secure initial installation

# Get the temporary root password
grep 'temporary password' /var/log/mysqld.log

# Connect and change password
mysql -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'StrongRoot123!';

Start service:

# See Percona docs for platform-specific instructions

Step 3 – Configure node 1 (bootstrap node)

See Bootstrap a PXC Cluster on NetBSD 10.

Step 4 – Add additional nodes

See Add a Node to PXC Cluster on NetBSD 10.

Architecture overview

     ┌──────────┐        ┌──────────┐        ┌──────────┐
     │  Node 1  │◄──────►│  Node 2  │◄──────►│  Node 3  │
     │ Primary  │        │          │        │          │
     └──────────┘        └──────────┘        └──────────┘
          All writes replicated synchronously (wsrep)