MySQL

The world's most popular open source database

Contact a MySQL Representative


  • MySQL.com
  • Developer Zone
  • Partners & Solutions
  • Customer Login
  • DevZone
  • Downloads
  • Documentation
  • Articles
  • Forums
  • Bugs
  • Forge
  • Blogs
 
  • Pages

    • Press Release: “Kaj Arnö Appointed MySQL VP of Community Relations”
  • Archives

    • August 2008
    • July 2008
    • June 2008
    • May 2008
    • April 2008
    • March 2008
    • February 2008
    • January 2008
    • December 2007
    • November 2007
    • October 2007
    • September 2007
    • August 2007
    • July 2007
    • June 2007
    • May 2007
    • April 2007
    • March 2007
    • February 2007
    • January 2007
    • December 2006
    • November 2006
    • October 2006
    • September 2006
    • August 2006
    • July 2006
    • June 2006
    • May 2006
    • April 2006
    • March 2006
    • February 2006
    • January 2006
    • December 2005
    • November 2005
    • October 2005
    • September 2005
  • Categories

    • Architecture of Participation (50)
    • Connectors (12)
    • Documentation (4)
    • Events (46)
    • Falcon (5)
    • GPL (8)
    • GUI (3)
    • Licensing (11)
    • MySQL (206)
    • MySQL Cluster (5)
    • MySQL Proxy (4)
    • MySQL Server (31)
    • MySQL Users Conferences (25)
    • MySQL Workbench (5)
    • Photography (11)
    • PHP (9)
    • Release Policy (20)
    • Ruby on Rails (5)
    • Running (5)
    • Summer of Code (8)
    • Sun (46)
    • Sun visits (23)
    • Travel (20)
    • Uncategorized (1)
    • Use cases (8)
    • Virtual company (36)



Kaj Arnö
« Why the Architecture of Participation is compatible with commercial interests
Building bridges to PostgreSQL »

High Availability: DRBD rcks

On Thursday/Friday this week, I visited Linbit in Vienna. They are the creators of DRBD. Quoting Wikipedia,

DRBD is an acronym for Distributed Replicated Block Device. It is a Linux kernel module, that, working together with some scripts, offer a distributed storage system, frequently used on high availability clusters. DRBD works as a kind of network RAID.

This means DRBD can give high availability to MySQL users. Through configuring DRBD to be used on your system, you can have synchronous replication between two different servers, giving a MySQL database a failover server to redirect to instantaneously, should the main server running MySQL fail.

For those interested in more detail on how to combine DRBD and MySQL, let me mention that Kristian Köhntopp of MySQL has written a great blog article on “Quick tour of DRBD“.

I was impressed when listening to DRBD’s main author DI Philipp Reisner describing the technical workings and business opportunities of DRBD. In many respects, he reminds me of our very own Monty years ago.

I also learnt plenty of things from Florian Haas, Senior Software Engineer with Linbit. Among other things, he taught me that r is a vowel (in many of Austria’s neighbouring countries), meaning that you can pronounce DRBD without spelling out the letters. Sounds like “Good day!” in Slovenian.

On a more serious note, I think the prospects for DRBD look fascinating. Or in other words, remembering my recent insight on vowels: DRBD rcks!

This entry was posted on Saturday, March 24th, 2007 at 14:50 and is filed under MySQL, MySQL Cluster, Use cases. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “High Availability: DRBD rcks”

  1. Eric Bergen » DRBD in the real world. Says:
    April 2nd, 2007 at 19:28

    […] Kaj Arnö has written an excellent blog post on the basics of DRBD. DRBD has one great feature that binary log replication doesn’t have. It can ensure that a write is synced to disk on two different hosts before allowing the application to continue. This is great for data redundancy but it introduces potential for instability in the setup. In a good fail over scenario a problem on the backup master should never cause an issue on the primary master. With DRBD the second master lagging behind because of a degraded raid, network issue, operator error, name your poison causes issues on the primary master because MySQL has to wait for writes to be synced to disk on _both_ machines before continuing. I know there are 3 different protocol modes that DRBD can operate in. Protocol C is really the only one that gives any extra data security over binary log replication so it’s the one I’m focusing my attention on. If an issue on one master causes problems on another then the benefit of having redundant masters is effectively lost. […]

Leave a Reply

Kaj Arnö is proudly powered by WordPress MU running on Blogs.mysql.com.
Entries (RSS) and Comments (RSS).