Forum Discussion
pazzoide76
Feb 01, 2024Iron Contributor
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 i...
- Mar 04, 2024Prepare 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
Mar 04, 2024Copper Contributor
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.
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.
pazzoide76
Mar 04, 2024Iron Contributor
Harrum_Fatima thank you