Post reply

Number of ip addresses required for active passive cluster active/active cluster

  • May 28, 2012 at 8:46 am

    #269544

    Hi Friends,

    I want to know the no of ip address required for active passive cluster active/active cluster

  • May 28, 2012 at 9:54 am

    #1493868

    viswanathan.mathi (5/28/2012)

    Hi Friends,

    I want to know the no of ip address required for active passive cluster active/active cluster

    You require

    1 IP address for each cluster node

    1 IP address for windows cluster access point

    1 IP address for each clustered sql server instance

    1 IP address for each clustered MSDTC instance

    So, if I had a 3 node windows cluster with 3 clustered instances of sql server and 2 MSDTC instances i would need 9 IP addresses

    if I had a 2 node windows cluster with 1 clustered instance of sql server and 1 MSDTC instance i would need 5 IP addresses

    How many nodes does your cluster have, how many instances of SQL Server and MSDTC do you require?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • May 28, 2012 at 10:28 am

    #1493879

    does that include the heartbeat IP addresses as well?

    MVDBA

  • May 28, 2012 at 3:52 pm

    #1493916

    michael vessey (5/28/2012)

    does that include the heartbeat IP addresses as well?

    No Mike, and for 3 very good reasons

    ➡ Your public network possibly services 100's or 1000's of IP addresses and are strictly controlled\assigned by network admins.

    ➡ Heartbeat networks are implemented on private physical switch gear, if you mirror your public ip assignment then your configuration will remain unique. (I.e. an admin assigns 192.168.1.55/24 for your public nic and you set your heartbeat to 10.10.10.55/8)

    ➡ Enhancements in Windows 2008 networking and quorum models mean that dedicated heartbeats are no longer required.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • June 6, 2012 at 10:06 am

    #1497728

    Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply