1

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.

4
  • What’s the bandwidth & latency between your sites? Mar 30, 2018 at 15:16
  • @BaronSamedi1958 the bandwidth between two sites is 10Mbps which is shared with other activities. Mar 30, 2018 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. Mar 30, 2018 at 20:06
  • @BaronSamedi1958 hmm. How about using AlwaysOn High Availability group with p2p transactional replication? Apr 2, 2018 at 1:40

0

You must log in to answer this question.