Using AlwasyOn Failover Cluster Instance in conjunction of Peer to Peer Transactional Replicaiton

Asked Mar 30 '18 at 14:27

Active Mar 30 '18 at 14:27

Viewed 80 times

We are deploying two physical sites each with writable/readable access to its local SQL server. Each site has site redundancy and also cross site synchronization is required. My thought is to use the AlwaysOn Failover Cluster instance to achieve intra-site redundancy and Peer to Peer Transactional Replication to achieve cross site synchronization. In case of fail over within a site, will the Peer to Peer Transactional Replication be preserved? I assume it would since the entire SQL server instance is failed over. I cannot seem to find articles on the internet mentioning the combined use of these two technologies. Has anyone designed such a system and is it feasible to do so?

Thank you for your advice and help.

asked Mar 30 '18 at 14:27

MidTierDeveloper

What’s the bandwidth & latency between your sites? – BaronSamedi1958 Mar 30 '18 at 15:16
@BaronSamedi1958 the bandwidth between two sites is 10Mbps which is shared with other activities. – MidTierDeveloper Mar 30 '18 at 17:49
You won't be able to replicate anything in a sync manner with only 10 Mbps shared ;( FCI needs shared storage, and no shared storage can sync over 10 Mbps both ways. – BaronSamedi1958 Mar 30 '18 at 20:06
@BaronSamedi1958 hmm. How about using AlwaysOn High Availability group with p2p transactional replication? – MidTierDeveloper Apr 02 '18 at 01:40

Using AlwasyOn Failover Cluster Instance in conjunction of Peer to Peer Transactional Replicaiton

0 Answers0