skills.rest
Impertio-Studio
Impertio-StudioOFFICIAL
Explore all skills by this author →
WebsiteGitHub

mariadb-impl-galera-cluster

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

2|Updated May 19, 2026
Search Tags:#cluster#MariaDB#wsrep#Galera#multi-master#Galera cluster setup
One-click install
npx skills add https://github.com/Impertio-Studio/MariaDB-Claude-Skill-Package --skill mariadb-impl-galera-cluster
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: mariadb-impl-galera-cluster
Source: https://github.com/Impertio-Studio/MariaDB-Claude-Skill-Package/tree/main/skills/source/mariadb-impl/mariadb-impl-galera-cluster
Command: npx skills add https://github.com/Impertio-Studio/MariaDB-Claude-Skill-Package --skill mariadb-impl-galera-cluster

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires mariadb, galera, mariabackup, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill addresses the complexities of configuring and maintaining Galera multi-master clusters, ensuring robustness, performance, and reliability with a focus on minimizing common mistakes.

Core Features & Use Cases

  • Galera Cluster Setup: Provides step-by-step guidance for creating a stable 3-node minimum quorum cluster.
  • Bootstrap and Join Procedures: Explains how to bootstrap the first node and join additional nodes into the cluster.
  • SST Method Choice: Details the benefits and usage of mariabackup SST over other methods like mysqldump and rsync.
  • Weighted Quorum: Offers strategies for handling asymmetric deployments and leveraging weighted quorum for fault tolerance.
  • Monitoring and Retry Strategies: Provides insights into monitoring cluster health and implementing application-side retries for transaction management.

Quick Start

Set up a 3-node Galera cluster with mariadb-impl-galera-cluster. Run the following commands on each node:

galera_new_cluster
systemctl start mariadb

Frequently Asked Questions about mariadb-impl-galera-cluster

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

FAQPage Schema
How do I set up a 3-node Galera cluster for MariaDB?▼

To set up a 3-node Galera cluster, bootstrap the first node using `galera_new_cluster` and then join additional nodes by starting the MariaDB service with `systemctl start mariadb` to establish quorum.

What is the best SST method to use for Galera cluster synchronization?▼

The `mariabackup` SST method is recommended over `mysqldump` and `rsync` for Galera cluster synchronization because it provides non-blocking state transfers and minimizes downtime when joining nodes.

Does Galera multi-master replication support weighted quorum for asymmetric deployments?▼

Yes, Galera multi-master replication supports weighted quorum strategies to manage asymmetric deployments effectively, ensuring fault tolerance by adjusting node voting weights.

What MariaDB versions are required for running a Galera cluster?▼

Running a Galera cluster requires MariaDB version 10.6-LTS, 10.11-LTS, 11.x, or 12.x, alongside a solid understanding of wsrep replication semantics for proper configuration.

Why do I need application-side retries with wsrep replication?▼

Application-side retries are needed with wsrep replication to handle transaction deadlocks and certification failures inherent in synchronous multi-master clusters, ensuring data consistency during node conflicts.

Related Skills

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

mariadb-impl-replication-setup

Configure MariaDB replication with CHANGE MASTER TO and GTID settings.

Official
Advanced
dralgorhythmdralgorhythm
111

chaos-engineering

Run controlled chaos experiments to assess system resilience and fault tolerance.

Community
Advanced
sbsbhongsbsbhong

zustand

Adapt Zustand state management to json-render's StateStore for React Native JSON UI components.

Community
Intermediate
pluginagentmarketplacepluginagentmarketplace
1

redis-replication

Automate Redis master-replica replication with Sentinel-based high availability and monitoring.

Community
Advanced