Link to home
Start Free TrialLog in
Avatar of alexwhite19800
alexwhite19800

asked on

SQL replication over high latency link

Hello

I have two data centres - one in New York and one in Los Angeles. I have an application that will be located in both with standard Web/App/DB tiers.

Ideally, I'd like to have both data centres run Active/Active if not Active/Passive.

Network latency is about 50ms between the two.

There are three databases in the instance;

Users
Data1
Data2

Data2 gets updated very frequently.

Historically, we'd use something like log shipping for this as I don't think Mirroring, in either sync/async form, is supported for such high latencies.

With the advent of Availability Groups, AlwaysOn etc, is this still the same?
SOLUTION
Avatar of Jason clark
Jason clark
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of Máté Farkas
Máté Farkas
Flag of Hungary image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
AlwaysOn is the solution that replaced Mirroring. Big difference is with an AG you can access the Replicas with Read Only access. In Mirroring you would never be able to access secondary replicas.
But there's no miracles for the latency. AG will not work better with high latencies so my recommendation is to keep with Log Shipping until you have a faster network.
Avatar of alexwhite19800
alexwhite19800

ASKER

Is there any documentation / recommendation on which solutions (mirroring/AG/log shipping) to use for certain latencies?
I don't think so, at least from the part of Microsoft.
I'm telling you only by my experience working with these solutions.
Found an article from MSSQL Engineers about the AG latency. Unfortunally this was for MSSQL 2012. I don't know if they improved this up to MSSQL 2016.
alex, a feedback will be appreciated.
Cheers
Hi - I accepted the wrong answer! Does anyone know how I can revert this?
Alex, you can request the question to be reopened by clicking in the three dots button at the end of your main question.
Just fill a request for attention and a moderator will answer you.