SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 IP addresses for cluster		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Charoniv
Starting Member

21 Posts
Posted - 07/10/2012 :  09:26:56  Show Profile  Reply with Quote
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

USA
15557 Posts
Posted - 07/10/2012 :  10:25:41  Show Profile  Visit robvolk's Homepage  Reply with Quote
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.
Go to Top of Page

Charoniv
Starting Member

21 Posts
Posted - 07/10/2012 :  11:04:16  Show Profile  Reply with Quote
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?
Go to Top of Page

robvolk
Most Valuable Yak

USA
15557 Posts
Posted - 07/10/2012 :  11:20:52  Show Profile  Visit robvolk's Homepage  Reply with Quote
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.
Go to Top of Page

Charoniv
Starting Member

21 Posts
Posted - 07/10/2012 :  12:17:51  Show Profile  Reply with Quote
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.
Go to Top of Page

robvolk
Most Valuable Yak

USA
15557 Posts
Posted - 07/10/2012 :  12:40:14  Show Profile  Visit robvolk's Homepage  Reply with Quote
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.
Go to Top of Page

Charoniv
Starting Member

21 Posts
Posted - 07/10/2012 :  13:18:53  Show Profile  Reply with Quote
Thanks (I think - not sure I want to go there).
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000