Solved

Sharepoint 2010 SQL 2008 R2 Mirroring over WAN link

Posted on 2011-03-23
4
797 Views
Last Modified: 2012-06-21
Has anyone experience of Sharepoint 2010 SQL 2008 R2 database mirroring over a WAN link ? I know the supported scenarios, our WAN link will be average anything from about 2ms-20ms round trip, and there will be a limited number of low-usage, smallish (less than 20GB) databases and ideally, would like to do High-Availability with automatic failover, but probably more realistically, to avoid spurious failovers due to loss of connection to witness, High Availability with manual failover. It is essentially for business continuance in the event that a WAN link goes down, or that we lose the SQL server in the primary site. We would also like to be able to use full failover and run completely from the other site (will install another WFE server in DR site for this).
So really looking for experiences, advice etc.

Thank you
0
Comment
Question by:TheGeezer2010
  • 2
  • 2
4 Comments
 
LVL 15

Expert Comment

by:sharepointguru14
ID: 35204050
I would say if you were 10ms or less than you wouldn't have any issues at all. Although then clustering would work as well. 20ms and small transactional data to be replicated I think you should be fine.

you issue will be if you lose the wan link for any extended period of time and replicating the backlog.
0
 
LVL 11

Author Comment

by:TheGeezer2010
ID: 35205535
Hi Sharepointguru14

Have you actually tried this yourself ? Regarding the backlog, if we were to lose the link a judgement call would need to be made on whether to suspend or stop the mirroring depending on likely time to fix.

The plan now is to get this up and running in synchronous - no auto failover mode, test full failover on the SQL back-end, if this works OK, will then introduce a WFE in DR site and try failover using the new FE. I am not sure however if you can span a WFE over different AD sites - suspect not, so this would have to be a DNS change to effect this failover - and hence some delay.

I have one lother question - if I then include all of the databases which CAN be mirrored (all content, service (with the exceptions shown in Microsoft documentation e.g. SyncDB), config), if the link goes down when all is synced and we failover, is there anything else which needs to be done in terms of backing up/restoring other databases etc, and indeed, if the link goes down are you actually ABLE to failover ?

Sorry for questions but this whole topic seems to get more confusing the deeper you delve !!
0
 
LVL 15

Accepted Solution

by:
sharepointguru14 earned 300 total points
ID: 35207101
mirroring I have not done myself. Typically I have implemented clustered backend and then you either SAN replication or Log shipping for the DR solution. I'm not a huge fan of mirroring in the same datacenter so I'm not going to tell you I like the idea over a wan. The good news is...it really doesn't take much to setup and test. I don't know what your links are and actually how much you are going to be mirroring to tell you whether or not it is going to work. Really you need to just set it up and test it. If its not much change and less than 20ms I expect that it will work but I wouldn't count on it being a completely seamless or automatic solution but it would be a viable DR strategy.
0
 
LVL 11

Author Comment

by:TheGeezer2010
ID: 35256488
Hi SPG and thanks for your input

Can you describe how your DR solution works as we also would have the possibility of using SAN replication + log shipping. The issue I have with log shipping is that you cannot use it for any service or config databases.

Am I right then that this will only be a useful DR solution if the server/database fails. If the link fails we will have to break mirroring and maybe lose small amount of data.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
In 2017, ransomware will become so virulent and widespread that if you aren’t a victim yourself, you will know someone who is.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
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…

773 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