skills.rest
Percona-Lab
Percona-LabOFFICIAL
Explore all skills by this author →
GitHub

pxc-galera-operations

Manage Percona XtraDB Cluster Galera deployments with bootstrap, join, and recovery commands.

1|1|Updated May 29, 2026
Search Tags:#upgrade#sst#bootstrap#galera#pxc#wsrep#ist
One-click install
npx skills add https://github.com/Percona-Lab/skills --skill pxc-galera-operations
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: pxc-galera-operations
Source: https://github.com/Percona-Lab/skills/tree/main/pxc-galera-operations
Command: npx skills add https://github.com/Percona-Lab/skills --skill pxc-galera-operations

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill guides database engineers and operators through running Percona XtraDB Cluster (PXC) with Galera, covering lifecycle tasks from bootstrapping to upgrades and recovery, while avoiding common pitfalls such as split-brain and non-Primary clusters.

Core Features & Use Cases

  • Bootstrapping a cluster from a standalone to a multi-node PXC with safe practices.
  • Managing SST and IST methods, cluster join and configuration, and rolling upgrades across PXC versions.
  • Monitoring wsrep variables, flow control, and quorum behavior to maintain high availability and data consistency.

Quick Start

Boot a new PXC cluster by starting the first node with the bootstrap service, then start the remaining nodes to join automatically via IST/SST.

Frequently Asked Questions about pxc-galera-operations

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I bootstrap a Percona XtraDB Cluster from a standalone node?▼

To bootstrap a Percona XtraDB Cluster, start the first node using the bootstrap service to establish the Primary component, then start the remaining nodes to join the cluster automatically via IST or SST.

What is the difference between SST and IST when joining a PXC Galera node?▼

SST and IST are synchronization methods for joining a PXC Galera node. IST performs incremental state transfers from a donor, while SST provides a full state snapshot for initial joins.

How do I perform a rolling upgrade across PXC 8.0 and 8.4 nodes?▼

Rolling upgrades across PXC 8.0 and 8.4 are performed by sequentially upgrading one node at a time, ensuring the cluster maintains quorum and high availability throughout the process.

Why does my Galera cluster enter a non-Primary state and how do I recover it?▼

A Galera cluster enters a non-Primary state due to quorum loss, preventing split-brain. Recover it by bootstrapping the most advanced node to re-establish the Primary component safely.

How do I monitor wsrep variables and flow control in Percona XtraDB Cluster?▼

Monitor wsrep variables and flow control in Percona XtraDB Cluster by checking specific status variables, ensuring flow control pauses replication to maintain data consistency under load.

Can I use this to manage quorum handling and avoid split-brain in Galera deployments?▼

Yes, managing quorum handling and avoiding split-brain in Galera deployments is covered, providing safe recovery procedures and exact per-node commands to maintain cluster health.

Related Skills

Explore More Software Engineering Skills→
Impertio-StudioImpertio-Studio
2

mariadb-impl-galera-cluster

Set up a synchronous multi-master MariaDB cluster using Galera replication.

Official
Advanced
celticht32celticht32
4

couchbase-upgrade

Plan Couchbase Server upgrades with preflight checks and post-upgrade verification.

Community
Advanced
reverb256reverb256

infrastructure-monitoring

Manage and visualize system metrics with Prometheus, Grafana, and Alertmanager.

Community
Advanced
sckrollsckroll

mariadb

Manage MariaDB databases with Galera clustering for high availability.

Community
Intermediate