Clustering For Mere Mortals

Step-by-Step: Configuring a 2-node multi-site cluster on Windows Server 2008 R2 – Part 2

Posted in DataKeeper, High Availability, Hyper-V, virtualization, WSFC by daveberm on September 18, 2009

Integrating your storage replication with Failover Clustering

Introduction

In Part 1 of this series, we took a look at the first steps required for building a multi-site cluster. We got to the point where we had a two node cluster that used a node and file share majority quorum, with no resources yet defined. In this section we will start where we left off and look at how your replication solution will integrate with your failover clustering. Because each vendor’s replication solution will be implemented differently, it is hard to have one document that describes them all. The important thing to remember is that you want to purchase a replication solution that integrates with failover clustering and is certified by Microsoft. Your choices are basically array based, appliance based or host based replication solutions. EMC makes both appliance-based and array-based replication solutions and seem to do a great job at both. EMC’s John Toner maintains a blog that is dedicated to Geographically Dispersed Clusters and if you are going the EMC route, I’m sure he could lead you in the right direction. All the major vendors have solutions, you will just need to contact them to get the details.

For this demonstration, I’m going to use a host based replication solution, SteelEye DataKeeper Cluster Edition, from my company, SteelEye Technology. It is so easy, that I thought instead of doing a long article, I would just record the steps and share it with you in a video. One of the advantages of host based replication is that you can utilize your existing storage, whether it is just some local attached disks, iSCSI or an expensive SAN. Host based replication can replicate across any storage devices.

Here is a summary of what you will see in the video.

  • Launch the SteelEye DataKeeper MMC Snap-in
    • Create a new DataKeeper job, define mirror end points, network, compression, etc.
  • Launch the Failover Cluster MMC Snap-in
    • Create a Hyper-V resource
    • Add a DataKeeper Volume Resource
    • Edit the properties of the DataKeeper Volume resource to associate it with the mirror created earlier
    • Make the Virtual Machine configuration dependent upon the new DataKeeper volume resource

That’s it! You are now done. Sit back and enjoy your new Hyper-V multi-site cluster.

CLICK TO WATCH VIDEO

In Part 3 of this series, we will tackle SQL 2008 multi-site clusters on Windows Server 2008 R2. There are a few more steps and some tips and tricks you will definitely need to know, so make sure you check back to get all of the details. In the meantime, if you need assistance, leave me a comment or contact me through SIOS and I’d be glad to help you out.

16 Responses

Subscribe to comments with RSS.

  1. [...] prepare your multi-site cluster, including setting up the Node and File Share Majority Quorum. In Part 2, we saw a video example of how to integrate SteelEye DataKeeper, one of the available cluster [...]

  2. isolinx said, on July 27, 2010 at 2:04 pm

    Hi Admin
    thanks for unique info publishing on Integrating the storage replication with Failover Clustering. more help and informative page
    thanks again…………..really unique

  3. Traveller said, on August 3, 2010 at 12:01 pm

    It would be nice if there was some indication of how much it costs..

    • daveberm said, on September 16, 2010 at 10:02 pm

      A lot less than array based replication :) Seriously, don’t hesitate to contact SteelEye for a quote, the price is very competitive.

  4. [...] Step-by-Step: Configuring a 2-node multi-site cluster on Windows Server 2008 R2 – Part 2 September 20094 comments 5 [...]

  5. ibrahim naji said, on June 9, 2011 at 9:05 am

    Video URL doesnt seem to be valid anymore :(. Shame, was really getting into the article!

    • daveberm said, on June 9, 2011 at 1:24 pm

      Thanks for letting me know. The link referenced a site that was re-launched last week and apparently dropped some of my videos. I have asked them to put them back up, hopefully I’ll have it fixed before the end of next week.

      • ibrahim naji said, on June 9, 2011 at 2:53 pm

        Thats cool :) great content by the way, explains multi-site clustering really well.

        Am just wondering out of interest, what do you think are the advantages of doing a multi-site cluster architecture over mirroring with a witness in terms of availability and automated failover strategy?

        I do appreciate that disk replication through SteelEye is probably quicker than doing Synchronous Mirroring, and also you have the added over-head of redesigning application logic to allow for failover to mirror server (which is generally just a change of the connection string in most cases), but what am worried about with storage replication (independent of the DB) is that it will replicate integrity errors in the DB as well, basically its a server-level availability & automatic failover solution, not DB-level one, with mirroring it seems that you could get both.

        Also, with mirroring you get the added advantage that both servers are available for querying (the primary and mirror), with clustering the 2nd server (node) is on stand-by until it becomes primary, so you cant get any use out it.

        Am swaying towards mirroring, but maybe am missing something!.

        Cheers

      • daveberm said, on June 10, 2011 at 7:38 pm

        Database mirroring is good in many circumstances. The biggest difference is database mirroring replicates a single database where multisite clusters replicate the entire SQL instance. Some of the limitations of database mirroring are that it does not support databases that participate in distribute transactions and not all applications support the failover mechanism associated with database mirroring. Also, database mirroring addesses just SQL replication; if you have other data outside of SQL that needs replication and failover you will need to find a solution for that as well.

  6. Jane said, on June 19, 2011 at 9:26 am

    Nice. Thanks for posting this. Not sure that I completely understand it,but thanks for taking the time to write this out
    Long necklaces
    Latest fashion clothing
    New jewelry accessories

  7. ford fiesta workshop manual said, on September 3, 2011 at 10:08 am

    When reading this post it reminded me of something I read the other month, would there be any chance I could have the authors email address, Super blog thanks for the infomation.

    • daveberm said, on September 3, 2011 at 3:28 pm

      I just tried to email you with the email you supplied in your comment but it bounced back as undeliverable. Comment again with an active email address and I will send you an email.

  8. infrastructure | Pearltrees said, on January 18, 2012 at 4:44 pm

    [...] Launch the Failover Cluster MMC Snap-in Create a Hyper-V resource Create a new DataKeeper job, define mirror end points, network, compression, etc. Add a DataKeeper Volume Resource Launch the SteelEye DataKeeper MMC Snap-in Edit the properties of the DataKeeper Volume resource to associate it with the mirror created earlier Step-by-Step: Configuring a 2-node multi-site cluster on Windows Server 2008 R2 – Part 2 « Cluste… [...]

  9. Zarb said, on January 25, 2012 at 3:26 pm

    Hi,

    The link to your video is broken but I found it here : http://www.steeleye.com/downloads/multi-site-hyper-v-configuration-step-by-step/

    Thanks for your post.

    Max

  10. Beah said, on May 16, 2014 at 4:31 pm

    Hi Daveberm
    could you recommended a similar document for windows 2012 r2 ? or general design doc for windows 2012 r2 hyper-v multi site cluster


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 256 other followers

%d bloggers like this: