Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 30 of 33 Next 3 Older Entries

Displaying posts with tag: Pacemaker (reset)

Percona Replication Manager – Renaming Cluster Hostnames
+1 Vote Up -0Vote Down

Recently I’ve had to rename a node on a production cluster – however, I did not have an experience on this yet so I decided to try on a sandbox and establish a known procedure. Without further ado, assuming we have 3 nodes and we want to rename ha3′s hostname to ha03.

[root@ha01 ~]# crm status
Last updated: Wed Jun  4 21:55:01 2014
Last change: Wed Jun  4 21:53:35 2014 via crm_attribute on ha01.localdomain
Stack: classic openais (with plugin)
Current DC: ha01.localdomain - partition with quorum
Version: 1.1.10-14.el6_5.2-368c726
3 Nodes configured, 3 expected votes
6 Resources configured


Online: [ ha01.localdomain ha02.localdomain ha3.localdomain ]

 Master/Slave Set: ms_MySQL [p_mysql]
     Masters: [ ha01.localdomain ]
     Slaves: [ ha02.localdomain ha3.localdomain ]
 Clone Set: ping_gw_clone [ping_gw]
  [Read more...]
How to add VIPs to Percona XtraDB Cluster or MHA with Pacemaker
+1 Vote Up -0Vote Down

It is a rather frequent problem to have to manage Virtual IP addresses (VIPs) with a Percona XtraDB Cluster (PXC) or with MySQL master HA (MHA). In order to help solving these problems, I wrote a Pacemaker agent, mysql_monitor that is a simplified version of the mysql_prm agent. The mysql_monitor agent only monitors MySQL and set attributes according to the state of MySQL, the read-only variable, the slave status and/or the output of the clustercheck script for PXC. The agent can operate in 3 modes or cluster types: replication (default), pxc and read-only.

The simplest mode is read-only, only the state of the read_only variable is looked at. If the node has the read_only variable set to OFF, then the writer is set to 1 and reader attributes

  [Read more...]
Choosing a MySQL HA Solution – MySQL Webinar: June 5
+1 Vote Up -0Vote Down

Selecting the most appropriate solution for a MySQL HA infrastructure is as much a business and philosophical decision as it is a technical one, but often the choice is made without adequately considering all three perspectives.  When too much attention is paid to one of these aspects at the cost of the others, the resulting system may be over-engineered, poorly-performing, and/or various other flavors of suboptimal.

On Wednesday, June 5, at 10 a.m. PDT (1700 UTC), I will be presenting a webinar entitled, Choosing a MySQL HA Solution, in

  [Read more...]
Pacemaker Failed Actions ‘not installed’ And ‘not configured’
+0 Vote Up -0Vote Down

Playing around with Percona Replication Manager, and being new to Pacemaker, some errors were somewhat cryptic.

May 26 09:53:39 [2181] ha01.localdomain    pengine:   notice: unpack_rsc_op:    Preventing p_mysql from re-starting on ha02.localdomain: operation monitor failed 'not installed' (rc=5)
May 26 09:53:39 [2181] ha01.localdomain    pengine:   notice: unpack_rsc_op:    Preventing op from re-starting on ha02.localdomain: operation monitor failed 'not installed' (rc=5)

First, it says here that I have ‘operation monitor failed’ on node ha02.localdomain. This error simply means ‘I cannot run the operation monitor because it is not installed’. Where does this operation supposed to come from, from the resource agent. Turns out, I did not have the mysql resource agent in place under

  [Read more...]
Pacemaker and the recent GitHub service interruption
+2 Vote Up -0Vote Down

It never fails. Someone manages to break their Pacemaker cluster, and Henrik starts preaching his usual sermon of why Pacemaker is terrible and why you should never-ever use it. And when that someone is GitHub, which we all know, use and love, then that sermon gets a bit of excess attention. Let's take a quick look at the facts.

read more

High Availability in OpenStack
+0 Vote Up -0Vote Down

A few thoughts on high availability features (or the current absence thereof) in OpenStack.

I've just proposed a session for the OpenStack Folsom design summit which Jay Pipes was nice enough to invite me to (thanks!), and I thought I'd write up a few thoughts of mine ahead of time to get the discussion started.

read more

Now available: Slides from Percona Live and Linuxcon Europe
+0 Vote Up -1Vote Down

The slides from last week’s talks I (co-)presented at Percona Live and Linuxcon Europe are now available from our web site.

  [Read more...]
Busy weeks ahead!
+0 Vote Up -0Vote Down

I’m speaking at Percona Live, LinuxCon Europe, and linux.conf.au. And I just co-founded a new company.

I have a few busy weeks behind me, and even busier weeks ahead. If you’ve been wondering why recently I haven’t been updating this space too frequently, here’s why:

Yours truly and fellow ex-Linbiters Martin Loschwitz and Andreas Kurz have recently founded hastexo, an independent professional services organization focused on open-source high availability and disaster recovery. We are already offering both on-site and remote

  [Read more...]
New documentation just in time for OSCON!
+1 Vote Up -1Vote Down

With OSCON in Portland under way (where LINBIT has a presence, of course), we are making three new documents available in the popular Tech Guides section of our web site.

  [Read more...]
Cluster Stack update for Debian
+1 Vote Up -0Vote Down

Last week, the Linux-HA project made its Heartbeat 3.0.4 and Cluster Glue 1.0.7 release, and Pacemaker released 1.0.10 a few weeks back. Thanks to the amazing Simon Horman (horms to IRC regulars), those releases have been uploaded to Debian unstable (sid) yesterday.

What’s sid?

sid is the permanent code name of the Debian unstable distribution. It’s where package maintainers upload fresh builds and maintain the latest versions of distribution packages. It’s not meant for general

  [Read more...]
High Availability MySQL Cookbook , the review
+1 Vote Up -0Vote Down

When I read on the internetz that Alex Davies was about the publish a Packt book on MySQL HA I pinged my contacts at Packt and suggested that I'd review the book .

I've ran into Alex at some UKUUG conferences before and he's got a solid background on MySQL Cluster and other HA alternatives so I was looking forward to reading the book.

Alex starts of with a couple of indepth chapters on MySQL Cluster, he does mention that it's not a fit for all problems, but I'd hoped he did it a bit more prominently ... an upfront chapter outlining the different approaches and when which approach is a match could have been better. The avid reader now might be 80 pages into MySQL cluster before he realizes it's not going to be a match

  [Read more...]
Upstart support coming to Pacemaker
+1 Vote Up -0Vote Down

Thanks primarily to the efforts of Senko Rašić and Ante Karamatić, the Pacemaker cluster stack is being augmented with support for Upstart services. This is in addition to support for OCF resource agents and LSB/SysV init scripts, both of which have been supported in Pacemaker for years.

This is functionality now present in the upstream Mercurial trees, and we need testers to get in shape for release. Yes, that means you can help!

This is primarily relevant to you if you use a distribution with upstart as its default init daemon. This includes Ubuntu lucid, OpenSuSE 11.3, recent

  [Read more...]
Automating MySQL replication with Pacemaker
+2 Vote Up -0Vote Down

A little while back we did a webinar on using Pacemaker to fully automate MySQL replication. We now have a recording of that webinar available from our web site.


New webinar recordings available
+0 Vote Up -0Vote Down

A couple of new webinar recordings are available from our web site:

Like our live webinars, the recordings are of course free of charge. Enjoy!



  [Read more...]
Speaking at LinuxTag 2010 this Friday
+0 Vote Up -0Vote Down

Just as a quick reminder, as LinuxTag 2010 in Berlin is going into full swing: I am speaking on highly available, distributed, open source storage this Friday in room Europa I at 4pm CEST.

If you’re in Berlin, drop by! Admission is free.



  [Read more...]
Reminder: Pacemaker/Debian webinar, today 1400 UTC
+0 Vote Up -0Vote Down

For those of you who haven’t yet registered, this is our reminder for today’s Clustering in Debian webinar at 1400 UTC. If you’re planning to run Pacemaker on the upcoming Debian squeeze release, don’t miss this!



  [Read more...]
Upcoming webinar: migrating to Pacemaker on Debian squeeze
+0 Vote Up -0Vote Down

Martin Loschwitz, the longest-serving Debian Developer in our ranks, will present a walk-through of going from Linux clustering on Debian lenny (with Heartbeat 2.1.3, shudder) to squeeze (with Heartbeat 3 and Pacemaker). In this webinar you will learn everything you need to know about a painless migration to the new Linux cluster stack.

This webinar will be held on Monday, June 7, at 1400 UTC. You must provide a valid email address to receive a meeting key. Register below!


The widget should

  [Read more...]
In case you haven’t noticed, we no longer manage clusters with XML
+0 Vote Up -0Vote Down

While Yves presents a valid approach for managing NDB with Pacemaker and the anything Linux-HA resource agent (a generic wrapper for any daemon based application), the XML configuration shown is likely to have people running away screaming. This is how we had to do things back in the Heartbeat 2 days, which meant that as a cluster admin you would permanently run around with a loaded cocked shotgun with the muzzle pressed firmly against your foot.

Those days are long gone. Please don’t do this anymore. You also no longer need to use the low-level tools such as cibadmin or crm_attribute.

  [Read more...]
Setting up DRBD in Pacemaker clusters on Fedora 13
+0 Vote Up -0Vote Down

Andrew just published an update to his Clusters from Scratch documentation that contains a step-by-step guide for initially setting up DRBD based cluster resources on Fedora 13.

Yes, that’s the Fedora release with Linux 2.6.33, so no more installing DRBD kernel modules.



  [Read more...]
Linux cluster stack hits Debian squeeze
+0 Vote Up -0Vote Down

The full Linux cluster stack, including Pacemaker, Heartbeat, Corosync and related packages, cleared all hurdles and migrated to the Debian testing repository this morning. This means that Pacemaker and both messaging layers it supports will be in the upcoming Debian release, codenamed squeeze.

Credit goes to the debian-ha maintainers crowd for making this possible: Martin Loschwitz, Simon Horman,

  [Read more...]
Ubuntu 10.04 with full cluster stack support
+1 Vote Up -0Vote Down

Just in case you haven’t noticed, Ubuntu 10.04 “Lucid Lynx” has arrived. I upgraded my personal box over the weekend, and am happy to report that things went pretty flawlessly for me. So I’m now a happy lucid user.

What’s more important for the ever-growing cluster community is the fact that this LTS release comes with built-in support for the Pacemaker cluster stack — and indeed, it’s the first commercially-supported distribution that comes with support for both the Heartbeat and the Corosync cluster messaging layer. And it’s easy, too!

Here’s how I install the Pacemaker stack with Heartbeat

  [Read more...]
MySQL master/slave support merged into Linux-HA
+1 Vote Up -0Vote Down

MySQL replication support for the Pacemaker cluster manager (the stuff that we explained in this webinar) has made it into the Linux-HA resource agents default branch. If you are interested in testing — and you should! — please read the extended announcement. Feedback is extremely welcome on the linux-ha-dev mailing list.

We are expecting to release this as part of resource-agents 1.0.4, in late May/early

  [Read more...]
Upcoming webinar: Oracle high availability with DRBD and Pacemaker
+0 Vote Up -0Vote Down

We’re sticking with databases for our current round of webinars. Up next is an overview of Oracle high availability clustering on Linux.

In this 45-minute presentation, we will show you how to quickly and easily configure an Oracle database with an associated TNS Listener in a failover configuration, how to monitor both your database and your listener for failures, and how to have Pacemaker automatically intervene and recover from outages.

Brought to you in association with our friends over at Novell, we’ll showcase Oracle in combination with SUSE Linux Enterprise High Availability Extension.

This webinar is scheduled for April 28, 2010 at 1500 UTC.

As all of our

  [Read more...]
See you at LinuxTag 2010
+0 Vote Up -0Vote Down

I just got word that a talk about iSCSI High Availability with Pacemaker and DRBD, which I submitted for LinuxTag 2010, has been accepted by the selection committee.

The presentation is entitled Storage Done Right: Building a Resilient, Distributed, Highly Available Open Source iSCSI SAN and I will talk in the Storage track, in English. Questions in German, of course, won’t be a problem.

As the conference organizers have asked speakers not to publicize the temporary schedule (for obvious reasons — hey it’s temporary), I can’t give the exact time and location yet. But if you want to hear about how you can replace your six-figure SAN with something much more open, much less locked-in and much less

  [Read more...]
MySQL/Pacemaker scaleout webinar recording available
+0 Vote Up -0Vote Down

Yesterday’s webcast is now available for playback.

If you want a PDF of the slides, please leave a note on our web site.

Update, July 19, 2010: We have switched our webinar service provider. The webinar recordings are still available, albeit under a different URL, see

  [Read more...]
Complete Pacemaker cluster stack now in Debian
+0 Vote Up -0Vote Down

Thanks to the efforts of the Debian HA Maintainers team, the complete Pacemaker cluster stack is now available in Debian GNU/Linux. Packages are currently included only in Debian unstable (“sid“), but we expect them to make their way into squeeze (and lenny, via backports.org) relatively soon.

See the following links in the Debian package database for details:

  [Read more...]
Reminder: MySQL/Pacemaker scaleout webinar Wednesday 1500 UTC
+0 Vote Up -0Vote Down

As announced previously, our MySQL/Replication/Pacemaker webinar is on tomorrow (Wednesday April 7) at 1500 UTC. A few seats are still left; you may want to register quickly.



  [Read more...]
April Fool
+0 Vote Up -0Vote Down

Relax. There is no DRBD Windows port.

And of course, deploying Windows machines in a highly available, synchronously replicated enterprise cloud is something you can do today. Heartbeat, Pacemaker, DRBD, libvirt and KVM make an excellent, fully integrated HA virtualization stack.



  [Read more...]
MySQL scale-out with replication and Pacemaker
+1 Vote Up -0Vote Down

It seems that the MySQL Conference selection committee didn’t seem to like the talk (and tutorial) I submitted about integrating MySQL Replication with the Pacemaker cluster stack, enabling full MySQL scale-out in an environment you previously knew only for its synchronous-replication High Availability (http://www.mysql.com/drbd) features. But — fear not, my fellow HA geeks! — we are instead making the talk available for free, over the web, one week ahead of the conference.

In this 45-minute presentation, we will give an overview about

  • the Pacemaker cluster stack and the Linux-HA project it evolved out of;
  • the current state of MySQL integration in Pacemaker, and of course
  • leveraging Pacemaker’s built-in clone infrastructure for MySQL Replication.
  [Read more...]
Got Interviewed
+0 Vote Up -0Vote Down

by @botchagalupe
on Virtualization, Open Source tools and DNS Problems

Technorati Tags: dnsproblem drupal ha heartbeat linux-ha mysql pacemaker puppet virtualization xen
  [Read more...]
Showing entries 1 to 30 of 33 Next 3 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.