EmergencyEMERGENCY? Get 24/7 Help Now!

Percona replication manager (PRM) documentation available (beta)

 | June 8, 2012 |  Posted In: MySQL


Since the new MySQL Pacemaker resource agent supporting PRM is now included in version 3.9.3 of the official Pacemaker resource agents package and things have stabilized a bit, I have been able to write some documentation. I wrote a first draft of the PRM documentation that is likely far from perfect, but I hope it will be useful and improve rapidly. The PRM documentation is available here. Comments and suggestions are welcome, please use the PRM discuss or the PRM devel mailing lists instead of replying to the blog post directly.

2013-06-24: Code is now here: https://github.com/percona/percona-pacemaker-agents

Yves Trudeau

Yves is a Principal Consultant at Percona, specializing in distributed technologies such as MySQL Cluster, Pacemaker and XtraDB cluster. He was previously a senior consultant for MySQL and Sun Microsystems. He holds a Ph.D. in Experimental Physics.


  • Yves,

    Good stuff! We are looking to implement an HA mysql solution built upon EC2 for one of our customers and I noticed your documentation had a section under testing called VIPless cluster (cloud). Do you have any information here? Are you planning on using EIPs or DNS failover? Do you have any preliminary information or something you can point me to which hooks pacemaker up with EC2 or Route53?



    • @Jeremy and @Jacky,
      basically, the VIPless solution use a fake mysql agent on the application servers. When the promote notification is received on the application servers, announcing a new master, the fake agent, instead of adjusting mysql replication just issue an iptables DNAT rule to redirect outgoing mysql traffic to the new master. Directing reads to slaves can also be handled but in a less efficient way.

  • +1 to the suggestion to Jeremy

    Currently I am also looking into a proper setup for HA solution for EC2. (“proper” mean that the design have take into consideration of EC2 limitation and environment)

  • Excellent work Yves! I don’t think Pacemaker is the best place for most database failover scenarios, but this is actually a pretty sweet system you built. I am going to enjoy going through your agent source code.

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.