IP addresses for cluster - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

High Availability (2008)

IP addresses for cluster

Author

Topic

Charoniv
Starting Member

21 Posts

Posted - 2012-07-10 : 09:26:56

Which IP addresses will I need for 2 instance 2 node cluster.
At the moment havean IP address for the each of the machines and another for the cluster.
Do we need two more for the sql server instances? I would have thought these would use the cluster IP address (different ports?) but have read a paper suggesting they need to be allocated separately.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2012-07-10 : 10:25:41

You need an IP address for each SQL Server instance, in addition to the cluster's IP address. These are all virtual IPs that shift to the appropriate node of the cluster during failover, and are the addresses their respective names resolve to.

Charoniv
Starting Member

21 Posts

Posted - 2012-07-10 : 11:04:16

That's in addition to the machine?
We have
svr1
svr2
cluster1
sqlsrvi1\inst1
sqlsrvi2\inst2

So this needs 5 ip addresses in all?
We had to get the first 3 allocated - do we need to do the same for the instance ip addresses or are they dynamic?

robvolk
Most Valuable Yak

15732 Posts

Posted - 2012-07-10 : 11:20:52

Yes, each node has their own IP address as well. You can use DHCP for all of the addresses but the recommendation is to use static IP addresses.

You should also have an additional IP address on each node for cluster heartbeat, but this can be a 192.168 address. That would bring you up to 7.

Charoniv
Starting Member

21 Posts

Posted - 2012-07-10 : 12:17:51

Ok - we have 7 ip addresses now. Thanks

Anyting else we (I) will have forgotten (actually never knkown about).

How about MSDTC? Will we need that if we aren't executing ditributed transactions fro queries?
Think that would need a couple of disks too.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2012-07-10 : 12:40:14

You probably don't need it, but if you want it I recommend reading Allan's blog post:

http://www.sqlha.com/2012/06/29/how-to-properly-configure-dtc-for-clustered-instances-of-sql-server-with-windows-server-2008-r2/

You might want to read his related articles for "DTC" and "Distributed Transaction Coordinator" too.

Charoniv
Starting Member

21 Posts

Posted - 2012-07-10 : 13:18:53

Thanks (I think - not sure I want to go there).

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources