… a cluster with 3 nodes (CentOS 6.3) and using PRM as OCF: [root@percona1 percona]# crm_mon -1 ============ Last updated…: [root@percona1 ~]# ccs -f /etc/cluster/cluster.conf –createcluster lefred_prm Now add the nodes to the cluster: [root@percona1 ~]# ccs…:52:03 percona3 [root@percona3 ~]# clustat Cluster Status for lefred_prm @ Thu May 23 10:20:36 2013 Member Status: Quorate…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… indicate that something is up. FWIW, solutions like MHA and PRM simply attempt to connect and run a simple query, but…
Post: Percona replication manager (PRM) documentation available (beta)
June 8, 2012 By 5 Comments
Since the new MySQL Pacemaker resource agent supporting PRM is now included in version 3.9.3 of the … 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 but…
Post: Testing Percona Replication Manager (prm) with Vagrant
April 17, 2012 By 2 Comments
… Yves Trudeau, you may have heard about Percona Replication Manager (PRM), a new high availability tool for MySQL. Percona Live DC 2012 Percona Live MySQL Conference & Expo 2012 PRM is an OCF Resource Agent for Corosync / Pacemaker that take… and the puppet recipes is https://github.com/lefred/percona-prm. You can use the CentOS 6 base box I used…
Post: Upcoming webinar on PRM
September 20, 2012 By 2 Comments
… at 10am Pacific time, I’ll give a webinar on PRM, the Percona replication manager. During the webinar, I’ll walk you through the setup of a PRM cluster and show you how to perform some basic management…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 27, 2012 By 102 Comments
…, 2 expected votes 7 Resources configured. ============ Node PRM_S2: UNCLEAN (offline) Online: [ PRM_M PRM_S1 ] Failed actions: reader_vip_1_start_0…, status=complete): not configured reader_vip_2_start_0 (node=PRM_S1, call=8, rc=6, status=complete): not configured reader…=6, rc=5, status=complete): not installed [root@PRM_M ~]# And that seem PRM can not work. Please help me if I…
Post: Debugging MySQL SSL problems
November 8, 2012 By Leave a Comment
… thought would be worth sharing. I was setting up a PRM install for a customer and one of the requirements was SSL replication. In this particular case, I had setup PRM first, and then was working to get the other requirements… first before trying to get replication to use it via PRM‘s automation that does the CHANGE MASTER for you. Eliminate…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… case with PXC but it’s also the same with PRM). But why and what are the risks ? The goal of… of shared resources or provide simultaneously the cluster service. On PRM the problem is obvious, both nodes will try to run…
Comment: Testing Percona Replication Manager (prm) with Vagrant
April 17, 2012 By 2 Comments
… it can be any other MySQL version using standard replication). PRM works with “normal” MySQL acting as Master -> Slaves and in… Yves plans to look on how to use MHA with PRM. The goal of my approach here it to automate the…
Post: The Math of Automated Failover
September 18, 2012 By 9 Comments
… high availability solutions for MySQL such as Clustrix, Tungsten Replicator, PRM, Percona XtraDB Cluster, MySQL and DRBD as well as many…
