question

Tim Benninghoff avatar image
Tim Benninghoff asked

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?

sql-server-2008sql-server-2008-r2replicationhigh-availability
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tim Benninghoff avatar image Tim Benninghoff commented ·
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.
0 Likes 0 ·
Matt Whitfield avatar image
Matt Whitfield answered

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.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

David Bermingham avatar image
David Bermingham answered

http://clusteringformeremortals.com/2009/10/07/step-by-step-configuring-a-2-node-multi-site-cluster-on-windows-server-2008-r2-%e2%80%93-part-3/

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.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.