replication-manager have to be the best open source database cluster orchestator. Embed the best practices from configurations, deployments, HA operations, maintenance tasks, monitoring, troubleshooting in the MySQL, MariaDB, Percona and the tools around them. A toolkit for the best open source solutions. We design features to hide database clustering complexity, keeping Amazon RDS simplicity in mind.
replication-manager also aims to be configurable with nix style, multi tenant, secured via encryption and ACL and user-friendly by offering API, command line and HTML interfaces around familiar databases and proxying softwares.
replication-manager should bring multi cluster sharding and routing solutions to fixe the most difficult issue around databases: SCALABILITY and HIGH AVAILABILITY.
replication-manager was initially written with the goal of closing the gap between Galera Cluster and MySQL Master HA. While Galera Cluster is a really good product, it has some shortcomings such as performance and cluster-wide locking. replication-manager was first a tailored solution on top of new features in MySQL and MariaDB such as Global Transaction ID, Semi-Synchronous replication, binary log flashback, that aims to provide High Availability and node switchover without compromising performance by a too large factor.
replication-manager was since day one adapted to manage deployments of clustered databases solutions for his own testing requirements, a full stack cluster have to be provisioned, tested and unprovisioned, and move on using other topologies or product releases. We extend from solution for existing user deployments, to architecture as a service driven by external orchestrator. The oldest integration is OpenSVC, using 2 modes: with the collector API and more recently with direct cluster node VIP API. With the popularity of Kubenrnetes we also port our work to takeover. An other integration is on SlapOS an open source hyperconverged and Edge computing infrastructure where ou API is used to check and perform actions on each component of the database infrastructure.
To perform switchover on leader replicas , preserving data consistency, replication-manager uses an improved workflow similar to common MySQL failover tools such as MHA:
replication-manager is commonly used as an arbitrator with a layer that routes write database traffic to a single leader database node.
Based on each case one to many strategy can be used depending on each product feature maturity, security or performance requirements.