Solved

SAN replication : WAN bandwidth sizing & comparison to MS SQL mirroring

Posted on 2012-03-19
4
717 Views
Last Modified: 2012-03-30
I have a need to mirror a Production MS SQL DB to a remote hot site.

Q1:
Would SAN replication be more efficient (ie requires less bandwidth
& less manual intervention in the event disaster strikes the Production
site) than MS SQL 2008 mirroring ?

Q2:
Currently we have MS SQL log shipping with the SQL log ship files being
sent over a 50Mbps WAN at regular intervals to DR site (I suppose this
is to update the DR database as I'm new to this project).  Can I base
the bandwidth required by taking the largest log ship file ever created
divided by the interval that the log ship file is being created?
Can this method of sizing the WAN bandwidth be used for both
SAN replication as well as MS SQL mirroring solutions?
0
Comment
Question by:sunhux
  • 2
4 Comments
 
LVL 39

Assisted Solution

by:lcohan
lcohan earned 265 total points
Comment Utility
"I have a need to mirror a Production MS SQL DB to a remote hot site."


In my opinion SAN replication will not work in your case and your best option would be: "Database Mirroring"  high-performance mode (runs asynchronously) OR high-safety mode (synchronous)

http://msdn.microsoft.com/en-us/library/ms189852.aspx
0
 
LVL 39

Accepted Solution

by:
lcohan earned 265 total points
Comment Utility
Please see "SAN-over-WAN Applications Assessment" from link below to help you answer the two questions above. It is an older article but principles still stand today and as a side note my above answer is based on failure from our data center, SAN vendors(s) to ACTUALLY make it work not just as described by product(s) features - all recovery tests failed on the "replicated" SAN snapshots therefore we dropped it and (still) rely on old good SQL method including log shipping you currently have in place. Its all about how much data you can afford to loose and that dictates your log shipping or mirroring scenario. You could choose high safety if you can't afford any data loss and its working perfectly (for me on SQL 2005 and 2008 since 2010) including periodic disaster/recovery testing.

http://www.qlogic.com/Resources/Documents/WhitePapers/Routers/SN0130937-00.pdf
0
 
LVL 9

Assisted Solution

by:Shani Basha
Shani Basha earned 110 total points
Comment Utility
In my opinion you can have SAN replication with compression and deduplication which saves WAN bandwidth

Recently lot of Enterprise storages and FC switches available in the market which supports these features

http://www.hds.com/groups/public/documents/webasset/hitachi-replication-solution.html?M=data-replication-solutions-cal
0
 
LVL 23

Assisted Solution

by:Racim BOUDJAKDJI
Racim BOUDJAKDJI earned 125 total points
Comment Utility
Q1/No.  Since SQL 2008 database mirroring is fully compressed, it actually works better than SAN replication since it guarantees better transactional coherence between the databases.  SAN has no clue of transactional coherence.
Q2/No.  Log shipping is file based while mirroring is stream based.  Mirroring is more comparable to replication.  Plus mirroring is compressed.
0

Featured Post

New My Cloud Pro Series - organize everything!

With space to keep virtually everything, the My Cloud Pro Series offers your team the network storage to edit, save and share production files from anywhere with an internet connection. Compatible with both Mac and PC, you're able to protect your content regardless of OS.

Join & Write a Comment

First I will try to share a design of a Veeam Backup Infrastructure without Direct NFS Access backup. Note: Direct NFS Access backup transport mechanism is only available in Veeam v9 In above I try to design the Veeam Backup flow between i…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now