IP address in Clustering

• SQLisAwe5oMe

  SSChampion

  Points: 14027

  More actions

  October 18, 2012 at 7:13 am

  #263439

  How many IP address you need.....for 2 node active/passive cluster environment.

  Here is my breakdown.

  1 - Virtual IP address

  1 - Virtual Network name

  1 - Public Network

  1 - Private Network

  1 - MSDTC

  So, I have 5 total IPs.......is this correct?

  Thanks,

  SueTons.

  Regards,
  SQLisAwe5oMe.

• Perry Whittle

  SSC Guru

  Points: 233792

  More actions

  October 19, 2012 at 2:11 am

  #1550743

  SQLCrazyCertified (10/18/2012)

  ---

  How many IP address you need.....for 2 node active/passive cluster environment.

  Here is my breakdown.

  1 - Virtual IP address

  1 - Virtual Network name

  1 - Public Network

  1 - Private Network

  1 - MSDTC

  So, I have 5 total IPs.......is this correct?

  Thanks,

  SueTons.

  For a 2 node cluster you will typically need the following IPs

  Node1 2 x IPs (1 public and 1 heartbeat)

  Node2 2 x IPs (1 public and 1 heartbeat)

  MSDTC 1 x IP

  Windows Cluster 1 x IP

  SQL Server virtual network name 1 x IP for each instance installed

  So with 1 instance installed that's 7 IP addresses and then + 1 for each further instance you install.

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

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