Forum Discussion
Solved
Switch from Always On on the same subnet to a multisubnet cluster
HI,
I have a question to ask you.
I currently have a sql 2019 Always on cluster consisting of two nodes in the same subnet.
Now, since we have taken some VMs in the cloud, we will want to see if it is possible to create an always on multisubnet cluster made up of 4 nodes (2 on prem and 2 in the cloud).
My question is it possible to switch the current cluster to a multisubnet cluster and dock the two new nodes?
Is there a procedure to do this configuration?
Thank you
- Prepare and configure the new nodes in the cloud with SQL Server installed.
Add the new nodes to the existing Windows Server Failover Cluster (WSFC) that hosts the SQL Server Always On Availability Group.
Adjust quorum settings in the WSFC to accommodate the new nodes.
Modify the availability group listener configuration to include the new subnets for the new nodes.
Join the new nodes to the existing availability group as replicas.
Synchronize data across all replicas.
Test failover between different subnets.
Monitor and maintain the multisubnet cluster and availability group regularly.
2 Replies
- Prepare and configure the new nodes in the cloud with SQL Server installed.
Add the new nodes to the existing Windows Server Failover Cluster (WSFC) that hosts the SQL Server Always On Availability Group.
Adjust quorum settings in the WSFC to accommodate the new nodes.
Modify the availability group listener configuration to include the new subnets for the new nodes.
Join the new nodes to the existing availability group as replicas.
Synchronize data across all replicas.
Test failover between different subnets.
Monitor and maintain the multisubnet cluster and availability group regularly.Harrum_Fatima thank you
