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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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
Cheers
ASKER
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.
Just fill a request for attention and a moderator will answer you.
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.