Share via

multi-subnet configuration on WSFC

Urbel 605 Reputation points
2024-07-22T14:53:04+00:00

Hi all,

it my first time using Multiple Subnet in creating AlwaysOn Availability...

but one of IP Address either AG Listener resource or IP Cluster resource comes offline and the other comes online, is it normal? if not, how should solve this issue?

very grateful thanks for all response in advanced

warm regard,

Urbel

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments

Answer accepted by question author

MikeyQiaoMSFT-0444 3,310 Reputation points
2024-07-23T03:33:12.9933333+00:00

Hi，UrBel

This is a normal phenomenon.

The listener IP address in the subnet currently hosting the Availability Group primary replica will be online. The other listener IP address(es) will be offline. Because not all of the IP addresses returned by DNS will be online.

Refer to this blog.

Best Regards,

Mikey Qiao

If you're satisfied with the answer, don't forget to "Accept it," as this will help others who have similar questions to yours.

Was this answer helpful?

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alex Bykovskyi 2,241 Reputation points
    2024-07-23T16:50:44.6633333+00:00

    Hey,

    As mentioned, in multisubnet clusters IP addresses are not owned by all the nodes at the same time. Might be helpful: https://learn.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/sql-server-multi-subnet-clustering-sql-server?view=sql-server-ver16

    In addition, the following guide might be helpful as well:

    https://www.starwindsoftware.com/resource-library/installing-and-configuring-sql-sever-2014-multi-subnet-cluster-on-windows-server-2012-r2/

    Cheers,

    Alex Bykovskyi

    StarWind Software

    Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Zahid Butt 966 Reputation points
    2024-07-22T20:02:38.8633333+00:00

    Hi,

    I have not worked on this but what I get is that this is normal:

    In a multi-subnet failover cluster configuration, the IP addresses are not owned by all the nodes in the failover cluster, and may not be all online during SQL Server startup. Beginning in SQL Server 2012 (11.x), you can set the IP address resource dependency to OR. This enables SQL Server to be online when there is at least one valid IP address that it can bind to.

    Please go through :https://learn.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/sql-server-multi-subnet-clustering-sql-server?view=sql-server-ver16

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.