June 6, 2012 at 9:59 am
What would be better for two independent systems to be kept in sync and can they be an active / active configuration without clustering the SQL instance? The latency would be >1 millisecond for the network portion. What type of replication and how quickly does it keep the databases in sync and could the two systems be behind a load balancer?
Thank you!
June 6, 2012 at 10:31 am
Hi Vertigo44,
Answer to first Question (What would be better for two independent systems to be kept in sync):- Replication is the best candidate to keep the data in sync from what I understand from your scenario
Answer to Second Question ( can they be an active / active configuration without clustering the SQL instance? ):- No you cannot have them configured in Active/Active unless you cluster the sql instance;
Below is a practical solutions and I have implemented this on production servers which really worked well.
Win_Server_1 (node A) and Win_Server_2 (node B) will need to be clustered (windows clustered)
Then Configure the SQL server instances as below:
Win_Server_1
SQLA (Active)
SQLB(Passive)
Win_Server_2
SQLA(Passive)
SQLB(Active)
Answer to third question (What type of replication ) :- Transactional replication is the best candidate;
Answer to fourth question (how quickly does it keep the databases in sync ) :- It depends on the network latency and server configuration, transactional replication with 1 sec latency is also acheivable.
Answer to fifth Question (could the two systems be behind a load balancer? ) :- Yes, the two systems can definately be behind load balancers;
=======================================================================================
Visit my technical reference; you might find some of your issues already documented.
June 6, 2012 at 10:38 am
Outstanding! Thank you!
June 6, 2012 at 12:27 pm
Vertigo44 (6/6/2012)
What would be better for two independent systems to be kept in sync and can they be an active / active configuration without clustering the SQL instance? The latency would be >1 millisecond for the network portion. What type of replication and how quickly does it keep the databases in sync and could the two systems be behind a load balancer?Thank you!
what are you attempting to protect against?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply