Solved

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

Posted on 2012-03-19
4
728 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 40

Assisted Solution

by:lcohan
lcohan earned 265 total points
ID: 37738874
"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 40

Accepted Solution

by:
lcohan earned 265 total points
ID: 37738963
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
ID: 37741495
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
ID: 37744921
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to backup a VMware farm using Nakivo Backup & Replication. In this tutorial we will install the software on a Windows 2012 R2 Server.
Many businesses neglect disaster recovery and treat it as an after-thought. I can tell you first hand that data will be lost, hard drives die, servers will be hacked, and careless (or malicious) employees can ruin your data.
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

691 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