Replication options for storage in multi-site cluster

I'm investigating the possibility of setting up a multi-site cluster on Windows 2008 Server R2 / SQL Server 2008. What are some replication options I should consider? Is SAN replication the only option, or are there software options for replication?

more ▼

asked Oct 12, 2009 at 12:25 PM in Default

avatar image

Tim Benninghoff
43 1 1 5

It looks like the option that we're most interested in would be storage-level mirroring. We're looking at a vendor for both a software option, and a hardware option.

Oct 16, 2009 at 05:46 PM Tim Benninghoff
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

One thing to beware of with SAN replication is that it does block level copies, and doesn't really have any intelligence as to what is in those blocks. If replication goes down half way through replicating a bunch of blocks, you can have a data file that's in an invalid state as far as the application using it is concerned. I have spoken to a lot of people whom this has never affected, and some whom it has. Certainly it can be mitigated with very high speed data links. If those aren't available, then for the first point of call, I would try to use SQL replication, if possible.

Edit ->

The SQL Replication I was referring to was for if the Multi-Site clustering wasn't a viable option because synchronous SAN replication couldn't be supported (for example, through lack of bandwidth). The options to look at then would be a replication scenario whereby both sites can be written, and merge replication takes care of any business rule conflicts, or where one site is read-only, in which case Database Mirroring would possibly be the answer.

more ▼

answered Oct 12, 2009 at 12:35 PM

avatar image

Matt Whitfield ♦♦
29.5k 62 66 88

(comments are locked)
10|1200 characters needed characters left


This blog post is a step-by-step tutorial on how to build a two node SQL Server 2008 multi-site cluster using SteelEye DataKeeper Cluster Edition.

more ▼

answered Nov 17, 2009 at 05:55 PM

avatar image

David Bermingham

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 12, 2009 at 12:25 PM

Seen: 5330 times

Last Updated: Oct 15, 2009 at 05:58 AM

Copyright 2018 Redgate Software. Privacy Policy