Emergency

Testing Percona Replication Manager (prm) with Vagrant


Posted on:

|

By:


PREVIOUS POST
NEXT POST
Share Button

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:

Share Button
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.



Categories:
MySQL, Percona Software


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/

    Reply

  • Frederic Descamps Post author

    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.

    Reply

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.

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