How to create SQL active active instance

Question

Hello,

I have a webapp running in 2 separate regions West US and East US. There is a SQL multi subnet cluster configured which has nodes in each of the regions. Currently this is a Active/passive configuration in which the webapp talks to one of the sql node at a time. How can i configure this into an active active node in which the webapp can talk to both the nodes of the cluster.

Please suggest...Thanks!

Answer 1

Hi @NM ,

Welcome to Microsoft Q&A!

Active-Active is normally used to denote a multi-node Windows Server Failover Cluster that has multiple SQL Server instances installed, where each node has a separate instance. If you would like to configure Active-Active Clustering, you need to create a new SQL Server instance in your passive node. Please refer to SQL Server Clustering Active vs Passive and Creating an Active/Active SQL Cluster using Hyper-V: Part2 the Clustered Instances to get more information.

Best regards,
Carrin

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.