June 20, 2013

Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4

…-release CentOS release 6.3 (Final) [root@percona1 ~]# rpm -q pacemaker pacemaker-1.1.7-6.el6.x86_64 [root@percona1 ~]# rpm…-release CentOS release 6.4 (Final) [root@percona1 ~]# rpm -q pacemaker pacemaker-1.1.8-7.el6.x86_64 [root@percona1 ~]# rpm…: [root@percona1 ~]# ccs -f /etc/cluster/cluster.conf –createcluster lefred_prm Now add the nodes to the cluster: [root@percona1 ~]# ccs…

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

… situation. Typically DRBD is run in combination with heartbeat or pacemaker or something similar, and if one of the servers in… 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)

… the new MySQL Pacemaker resource agent supporting PRM is now included in version 3.9.3 of the official Pacemaker resource agents package… write some documentation. I wrote a first draft of the PRM documentation that is likely far from perfect, but I hope…. The PRM documentation is available here. Comments and suggestions are welcome but please use the linux-ha or the pacemaker mailing lists…

Post: Testing Percona Replication Manager (prm) with Vagrant

… Yves Trudeau, you may have heard about Percona Replication Manager (PRM), a new high availability tool for MySQL. Percona Live DC… Percona Live MySQL Conference & Expo 2012 PRM is an OCF Resource Agent for Corosync / Pacemaker that take cares of MySQL and manages….) It also provides messaging between servers within the same cluster. Pacemaker manages the resources and applications on a node within the…

Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker

… IP addresses, VIPs, management. We decided to call this solution PRM for Percona Replication Manager. All the parts are opensource and… 3 pieces: The Pacemaker cluster manager A Pacemaker configuration A MySQL resource agent Here I will not cover the Pacemaker installation since this…. As a final thought on the Pacemaker configuration, remember that in order for a pacemaker cluster to run correctly on a 2…

Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker

…, pacemaker configuration is: node PRM_M \ attributes IP=”192.168.163.205″ node PRM_S1 \ attributes IP=”192.168.163.206″ node PRM_S2… I start corosync, and pacemaker, then check it with command: crm_mon -1, this is my results: [root@PRM_M ~]# crm_mon…, 2 expected votes 7 Resources configured. ============ Node PRM_S2: UNCLEAN (offline) Online: [ PRM_M PRM_S1 ] Failed actions: reader_vip_1_start_0…

Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker

… deeper understanding of pacemaker. This is not a criticism, but an observation: in order to set up the PRM high-avaliability solution… all DBAs will know how to manage and analyze a Pacemaker configuration. Just consider the fact that you, as in Percona…, who is probably one of the most knowledgeable people on Pacemaker, to make it work (e.g. Florian told you you…