mha4mysql-node

Orchestrator

MySQL replication topology management and HA

replication-manager

Signal 18 repman - Replication Manager for MySQL / MariaDB / Percona Server

Galera Cluster

Synchronous multi-master replication library

Percona Replication Manager

This tool manages asynchronous replication between Percona XtraDB Cluster (PXC) or MariaDB clusters, enabling complex topologies like master-master links across multiple data centers. It leverages the existing Galera communication layer within clusters to coordinate replica election and failover, ensuring high availability and geographic distribution. ## Key Features - **Automatic Replica Election** — Nodes within a cluster coordinate via a shared table to elect a replica based on weight and local index, avoiding conflicts. - **Multi-Source Replication Support** — Handles scenarios where a cluster acts as a replica to multiple remote clusters, distributing replicas across nodes by default. - **Failover and Reconnection** — If a replica loses connection to its master, it attempts to reconnect to alternate masters; if unsuccessful, it reports a "Failed" state so another node can take over. - **GTID-Based Replication** — Works exclusively with GTID-based replication, supporting both Oracle MySQL and MariaDB implementations (with version-specific notes). - **Geo-Distributed Clusters** — Facilitates replication across geographically separated data centers using tools like booth for cluster coordination. ## Philosophy The project emphasizes automation and resilience in complex replication topologies, using a lightweight, agent-based approach that integrates seamlessly with existing Galera cluster communication to minimize overhead and simplify management.