multi-subnet configuration on WSFC

UrBel 120 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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,629 questions
0 comments
Accepted answer
  1. MikeyQiaoMSFT-0444 2,550 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.

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alex Bykovskyi 2,006 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://video2.skills-academy.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.

    1 person found this answer helpful.
    0 comments
  2. Zahid Butt 956 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://video2.skills-academy.com/en-us/sql/sql-server/failover-clusters/windows/sql-server-multi-subnet-clustering-sql-server?view=sql-server-ver16

    0 comments

Your answer

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