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.