PRM: automatic MySQL/MariaDB replication managment

| 0 comments

5.00 avg. rating (91% score) - 1 vote

percona-logo

The Percona replication manager (PRM) is a framework using the Linux HA resource agent Pacemaker that manages replication and provides automatic failover. This covers the installation of the framework on a set of servers. The PRM framework is made of 4 components: Corosync, Pacemaker, the mysql resource agent and MySQL itself.

It’s easy to setup, better if you already know how to use Pacemaker and it works like a charm. In fact it setup a master and x slaves. If the master crashes, it will switch a slave to a master node and reconfigure automatically all slaves to connect to the new master. Of course it will manage all VIPs.

It works quite well and recently support GTID replication. If you want to setup, look at the official documentation which is well written and fast to setup.

You should test it if you want to have multiple slaves servers automatically managed with a master node. This solution is very interesting and I prefer this one instead of MMM & co.

Author: Deimos

I'm a passionate DevOps. I love transmit my skills and I love working on high availability infrastructures/technologies.

Laisser une réponse