Technical guides for MariaDB Galera Cluster and Percona XtraDB Cluster

Technical documentation and community updates cover the configuration and deployment of database clustering solutions.

One guide details the process of configuring a TLS-secured MariaDB Galera Cluster. This involves setting up an active-active MySQL Cluster using MySQL-wsrep, utilizing rsync with TLS, and managing data transfers through State Snapshot Transfer (SST) or Incremental State Transfer (IST). The setup utilizes Vagrant to simulate a three-node environment to ensure a quorum and prevent split-brain scenarios.

Additionally, developments in the dbdeployer community include support for Percona XtraDB Cluster (PXC). Efforts to extend dbdeployer features allow for the deployment of multiple PXC nodes on a single host. The deployment process requires specific port configurations for regular MySQL traffic and communication for SST, noting that PXC nodes require specific initialization sequences where the first node must be established before others can join the cluster.