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 30

Displaying posts with tag: Heartbeat (reset)

The Full Monty – Version 2
+0 Vote Up -0Vote Down

Installing MySQL on CentOS 6.2 with PaceMaker, MHA and more

When I work with High Availability software, I’m reminded of the maze in the original computer adventure game “You are Lost in a maze of twisty-turny passages all alike…”.

If you search the web for HA programs you will find many well maintained projects all related that refer each other. The goal of this document is to give you with a step by step guide to a production worthy MySQL system. It should provide at least 99.999% access to your data and be able to scale read requests as you grow.

I have chosen these programs and utilities because they are free (as in beer) and each has enterprise support available. (When you make the money to pay for it.) If you start with this MySQL platform you will

  [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...]
The Full Monty – Scientfic Linux 6.1, drbd, PaceMaker, MySQL, Tunsten Replication and more
+0 Vote Up -0Vote Down

PART 1 – This will be a multi part post.

THIS DOCUMENT IS BEING UPDATED – PLEASE WATCH FOR CHANGES!

After years of supporting MySQL, for many different companies, I’ve seen this story played out again and again.
The company:

  • chooses a Database Management System (MySQL)
  • installs the DBMS on a computer with other processes
  • writes many programs to access the data (Without concern on how the queries are written.)
  • moves DBMS to a computer of its own and writes more programs
  • buy bigger computer to run the DBMS and writes more programs
  • tires of DBMS response times and outages caused by developers working on production systems and hires a Database Administrator to fix the mess

This is a step by step description of  how I


  [Read more...]
Quick How-To for DRBD + MySQL + LVS
+0 Vote Up -0Vote Down

I wrote this up a while ago and decided that I didn’t want to lose it in a shuffle of documents during my transition to a new workstation. It’s the basics of setting up Heartbeat (LVS) + DRBD (block replication between active/passive master servers) + MySQL. This should give you the basics of a H/A system without the benefits of SAN but also without the associated cost. The validity of this setup for H/A purposes is highly dependent on your workload and environment. You should know the ins and outs of your H/A solution before deciding to blame the system for not performing as expected. As with all production systems you should test, test, test and test some more before going live.

When I get around to it later I’ll post my How-To for setting up RHCS + SAN + MySQL. You can download the DRBD document PDF here:

  [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...]
Linux-HA documentation updates
+1 Vote Up -0Vote Down

I’ve just announced a rather large update to the Linux-HA documentation.

We now finally have a Developer’s Guide for OCF resource agent authors and contributors. If you want to write a new resource agent to bundle with your project, or plan to send a patch for an existing resource agent, then this guide is for you.

In addition, we’ve released a new version of the Linux HA User’s Guide, which is the definitive reference and handbook for Heartbeat users.

PDF versions of these are, as always,

  [Read more...]
Howto setup MySQL on a DRBD volume
+2 Vote Up -0Vote Down
One more DRBD tutorial, this time I will describe howto setup MySQL with DRBD (Distributed Replicated Block Device). Purpose This document describes how to to setup a failover system with MySQL and DRBD (Distributed Replicated Block Device). Introduction In this tutorial we will setup two Debian Linux nodes with a DRBD volume. MySQL will be [...]
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...]
Upcoming High Availability Clustering miniconf at Linux Plumbers Conference
+0 Vote Up -0Vote Down

This year’s Linux Plumbers Conference is taking place November 3-5, in Cambridge, MA, United States. The CfP is already closed and the program is due any day now, but the co-located miniconference on high availability clustering is still accepting proposals. This is your chance to get involved!

So if you plan to attend Plumbers or just happen to be in the area, please submit your talk! Miniconference talks are not expected to be full-blown

  [Read more...]
MySQL HA with DRDB and Heartbeat on CentOS 5.5
+1 Vote Up -1Vote Down

This is one of a few MySQL High Availability strategies.  I have used this for years and found it work great.  If you don’t know about DRBD and MySQL you should read Peter’s comments.

These are step by step instructions for Redhat 5 or CentOS.

If you need more details please refer to:
http://www.drbd.org/users-guide/

Configuring MySQL for DRBD
http://dev.mysql.com/doc/refman/5.1/en/ha-drbd-install-mysql.html

Getting started:

The OS in this example is CentOS 5.5.  I added a new disk (/dev/sde) to the four disk RAID-5 and RAID-1 I was already using.   I’m only



  [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...]
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/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...]
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...]
Sydney MySQL User Group: SMUG#7 — The Reboot
+0 Vote Up -0Vote Down

Reanimating the Sydney MySQL User Group!

What: Sydney MySQL User Group meetup #7 - The Reboot

When: July 16, 2009 5:30 PM (please don’t forget to RSVP yes/no/maybe)

Where: Sydney, CBD - join the meetup for exact location.

We are back! After 3 years of being silent, SMUG (can I call it so? I know there are conflicts with other acronyms) resurrects the meetings.

The logistic of the meetup is the following:

  • 5:30pm — the gathering starts and we have pizza and beers and talking your
  [Read more...]
DRBD User’s Guide update — feedback appreciated!
+1 Vote Up -0Vote Down

A new version of the DRBD User’s Guide is up at http://www.drbd.org/users-guide. As this version has some major additions to the previous release, I’ve decided to create a release
candidate this time, before declaring this an “official reference” — everyone’s feedback is requested and highly encouraged.

What’s new is Chapter 8, “Integrating DRBD with Pacemaker clusters“. It deals with the new drbd OCF resource agent we are about to release with 8.3.2, and how to use it in Pacemaker clusters using the CRM shell. It also has setup examples for MySQL, as does the legacy chapter on Heartbeat. Please grab


  [Read more...]
MySQL Replication Heartbeat
+0 Vote Up -1Vote Down

Well isn’t that interesting, hidden all the way at the end of the MySQL 5.4 information are two words that really peaked my interest: Replication Heartbeat. And it wasn’t even using caps or other highlighting in the original text. Reading through the feature list of 5.4, I’m very impressed. All necessary/useful stuff for the real world, no marketing or enterprise blah.

Of course we’ll have to explore it in detail to have more opinion. Proof is in production, not paper. As this is the first most of us have heard/seen of it, it’ll take time to explore. Someone who tried to install the tarball this morning got an assertion during the system table installation. That’s not the best first impression, but that might be a build issue. I’m really pretty excited about the

  [Read more...]
MySQL HA – Let’s take a look at Sequoia
+0 Vote Up -0Vote Down
MySQL HA: 1. Desirable – most of the time, 2. Needed – often enough, 3. Available – there are some good options out there. Typical solutions consist of: Heartbeat with DRBD on Linux. Although HB was introduced to Linux, it can be used on Solaris, FreeBSD and others without the DRBD but with other solutions. Sun Cluster, Veritas (commercial), MySQL Proxy (still in [...]
DRBD Management Console
+0 Vote Up -0Vote Down

Wow, check out what just came out from Linbit: The DRBD Management Console. Written in Java (so it runs anywhere), completely open source (GPLv3), and allows you to manage DRBD and Heartbeat based clusters. You can install, configure, see your systems graphically, and a lot more. I’m interested to try the beta out, as soon as I get back to my lab (sitting in the airport now). If you know how to use DRBD/Heartbeat, and use it in production for your MySQL setup, it might be a good application to test out, and improve if need be.

From the screenshots, I’m surprised this isn’t a value added extra that Linbit would like to charge for. Kudos, Linbit, for keeping it GPLv3!

  [Read more...]
Shared-nothing synchronous storage replication with DRBD… for Zarafa!
+0 Vote Up -0Vote Down

Last Friday and Saturday I had the pleasure of presenting DRBD-based high availability at the 2008 Zarafa Summer Camp. What’s this Zarafa thing, you ask? Here’s a quick introduction.

Zarafa is a fully LAMP-based, drop-in replacement for Microsoft Exchange developed by a Delft, Netherlands-based company. Yes, that means that all those Windows desktop users out there can use their beloved Microsoft Outlook to connect to a full-fledged collaboration solution, including email, calendaring, contact management, a global address book, and task sharing. Using native


  [Read more...]
High Availability with DRBD and Heartbeat Presentation
+0 Vote Up -0Vote Down
Here's my presentation I gave June 9, 2008, at the Twin Cities MySQL and PHP User Group about my highly available cluster using DRBD and Heartbeat. I added a few slides and cleaned things up a bit. The presentation went well and we had a lot of good questions. The MySQL and PHP User Group will be taking some time off over the summer. There will be another meetup mid-summer to come up with some ideas for future meetings.
High Availability with DRBD and Heartbeat Presentation
+0 Vote Up -0Vote Down

Here's my presentation I gave June 9, 2008, at the Twin Cities MySQL and PHP User Group about my highly available cluster using DRBD and Heartbeat.


I added a few slides and cleaned things up a bit. The presentation went well and we had a lot of good questions.

The MySQL and PHP User Group will be taking some time off over the summer. There will be another meetup mid-summer to come up with some ideas for future meetings.

MySQL Conference Liveblogging: Monitoring Tools (Wednesday 5:15PM)
+0 Vote Up -0Vote Down
  • Tom Hanlon of MySQL presents
  • monitoring tool basics
    • SHOW FULL PROCESSLIST
    • SHOW GLOBAL STATUS
    • SHOW GLOBAL VARIABLES
  • basic tools
    • mysqladmin is provided with the server
      • mysqladmin -i 10 extended status: will repeat the same command every 10 seconds. Pipe through grep "and smoke it" (bad pun, hah hah)
      • -r: show only changed values
    • MySQL Administrator
  • cacti
    • rrdtool based network graphing tool
    • uses snmp
    • PHP apache and MySQL based solution
    • MySQL plugins, download and install
    • "poller" gathers data and populates the graphs
    • someone offers munin as an alternative
      • not snmp based, its own
  [Read more...]
High-availability MySQL and DRBD
+0 Vote Up -0Vote Down

The day of tutorials started out with All Bases Covered: A Hands-on Introduction to High-availability MySQL and DRBD by Florian Haas and Philipp Reisner.

After a brief introduction to DRBD, they started discussing the configuration file. There were a couple settings that I had set incorrectly on my servers.

Since I have my two servers connected via a gigabit crossover cable, I had my synchronization rate set to 125MB. They recommended approximately 1/3 your network and disk I/O so that you're applications don't freeze up during synchronization. Their test system used 30MB so I'll give it a try too.

Another setting they had different was the activity log extents. All of the references I looked at said to set

  [Read more...]
First official release of DRBD User’s Guide
+0 Vote Up -0Vote Down

After a month of intense public review by our community users and contributors, we have made the initial “official” release of the DRBD User’s Guide.

This does not only include helpful information about building, installing, and configuring DRBD, but also on DRBD integration with Xen and LVM, Heartbeat, and many other applications. MySQL users will find the example MySQL HA configurations for both Heartbeat R1 and Heartbeat CRM clusters particularly helpful.

The release announcement is here: http://lists.linbit.com/pipermail/drbd-user/2008-March/009071.html


  [Read more...]
Configuring Heartbeat links
+0 Vote Up -0Vote Down

I’ve heard from the guys at MySQL (http://www.mysql.com/drbd) that the configuration of Heartbeat communication paths in ha.cf seems to be confusing to some. So, here’s our best practice summary:

  • Never configure fewer than two communication paths. And I mean, never. Never. If you do, that’s an accident (read: split brain) waiting to happen.
  • On the device that you run your DRBD replication over, if it uses a direct back-to-back connection to the peer node (like it should), configure a bcast link. Simple and easy to configure, and since you’re not sharing that link with anything other than DRBD replication, those broadcast


  [Read more...]
Showing entries 1 to 30 of 30

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.