EmergencyEMERGENCY? Get 24/7 Help Now!

Testing Percona Replication Manager (prm) with Vagrant

 | April 17, 2012 |  Posted In: MySQL, Percona Software

PREVIOUS POST
NEXT POST

If you have recently attended some Percona Live events or if you have checked some slides from Yves Trudeau, you may have heard about Percona Replication Manager (PRM), a new high availability tool for MySQL.

 

PRM is an OCF Resource Agent for Corosync / Pacemaker that take cares of MySQL and manages the replication.

Corosync allows any number of servers to be part of the cluster using any number of fault-tolerant configurations (active/passive, active/active, N+1, etc.) It also provides messaging between servers within the same cluster.

Pacemaker manages the resources and applications on a node within the cluster.

I have created a Vagrant environment to speed up installation and testing this new solution for HA.

The url of the git repository including the Vagrant file and the puppet recipes is https://github.com/lefred/percona-prm.

You can use the CentOS 6 base box I used in the previous post (Testing Percona XtraDB Cluster with Vagrant).

In the follow “terminalcast” you can see how to deploy the setup and some basic commands to check and manage your cluster:

PREVIOUS POST
NEXT POST
Frederic Descamps

Frédéric joined Percona in June 2011, he is an experienced Open Source consultant with expertise in infrastructure projects as well in development tracks and database administration. Frédéric is a believer of devops culture.

2 Comments

  • Is the PRM based on Percona’s XraDB cluster? I think I might have blogged a HOWTO about building such a system.

    http://www.mysqlfanboy.com/2012/02/the-full-monty-version-2-3/

  • Hi Mark,

    No it’s not, in these setup Percona XtraDB Server is used (but it can be any other MySQL version using standard replication).

    PRM works with “normal” MySQL acting as Master -> Slaves and in case of the master being evicted (intentionally or not) from the cluster the “best” slave will be promoted as Master.

    Your howto seems very interesting and it’s similar to this setup. I know Yves plans to look on how to use MHA with PRM.

    The goal of my approach here it to automate the installation and to allow everybody to test it easily.

Leave a Reply

 
 

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.