Quick How-To for DRBD + MySQL + LVS

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: DRBD_LVS_Install-Configure_HowTo

Tagged , , , ,

4 thoughts on “Quick How-To for DRBD + MySQL + LVS

  1. [...] Matt Reid discuss the basics of setting up Heartbeat (LVS) + DRBD (block replication between active/passive master servers) + MySQL. [...]

  2. [...] Matt Reid discuss the basics of setting up Heartbeat (LVS) + DRBD (block replication between active/passive master servers) + MySQL. [...]

  3. Mark Grennan says:

    Looks like we are all reading from the same play book.

    http://www.mysqlfanboy.com/2010/07/mysql-ha-with-drdb-and-heartbeat-on-centos-5-5/

    Watch my blog for an update.

  4. admin says:

    I’m surprised to see that you’re recommending that people use Ext3 for DRDB. XFS is not only more stable but allows you to not rely on sync_binlog=0 for performance. Also, you may want to test your process monitoring via an additional check than just ipfail, like dopd or others are rather useful for prod environments if you don’t want data integrity issues during failover.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>