ip address for SQLServer cluster

Question

Post reply

ip address for SQLServer cluster

WYL

Old Hand

Points: 323
More actions
November 21, 2011 at 5:11 pm

#260458

Hi:
I am building a SQLServer 2008 R2 cluster, with
- 2 nodes
>> nodeA: 10.10.10.10
>> nodeB: 10.10.10.11
- window cluster
>> WDCLUS: 10.10.10.20
- Active/Passive
- Single instance (default instance)
I would like to know, do I need a dedicated virtual ip and network name for my single instance? Or I both SQLServer instance and window cluster can share the same name, virtual ip?
i.e Can my instance called WDCLUS (default instance of the window cluster), with ip address 10.10.10.20 or I have to provide SQLServer with different network name/virtual ip, like DBCLUS, 10.10.10.21, and separated from the window cluster WDCLUS?
Just in case that I can do it both ways, then what's the difference between the two?
Thanks much!

Viewing 10 posts - 1 through 10 (of 10 total)

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

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 1

Devendrakumar

SSC-Forever

Points: 42493

November 22, 2011 at 12:26 am

#1411223

same IP should be fine.

WYL Old Hand Points: 323 More actions · Answer 2

Thanks for the reply.

Found a couple notes on the web, most of them recommend different ip addresses for Window cluster and SQL Cluster.

e.g.

http://www.scribd.com/doc/28250844/SQL-Server-Clustering-Guide

http://www.sqlmag.com/content1/topic/set-up-a-sql-server-2008-cluster/catpath/configuration/page/2

Any pros and cons between using 2 seperated ip vs same ip?

Thanks much.

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 3

WYL (11/22/2011)
Thanks for the reply.
Found a couple notes on the web, most of them recommend different ip addresses for Window cluster and SQL Cluster.
e.g.
http://www.scribd.com/doc/28250844/SQL-Server-Clustering-Guide
http://www.sqlmag.com/content1/topic/set-up-a-sql-server-2008-cluster/catpath/configuration/page/2
Any pros and cons between using 2 seperated ip vs same ip?
Thanks much.

Yes but not for Single instance (default instance).

Perry Whittle SSC Guru Points: 234064 More actions · Answer 4

WYL (11/21/2011)
Hi:
I am building a SQLServer 2008 R2 cluster, with
- 2 nodes
>> nodeA: 10.10.10.10
>> nodeB: 10.10.10.11
- window cluster
>> WDCLUS: 10.10.10.20
- Active/Passive
- Single instance (default instance)
I would like to know, do I need a dedicated virtual ip and network name for my single instance? Or I both SQLServer instance and window cluster can share the same name, virtual ip?
i.e Can my instance called WDCLUS (default instance of the window cluster), with ip address 10.10.10.20 or I have to provide SQLServer with different network name/virtual ip, like DBCLUS, 10.10.10.21, and separated from the window cluster WDCLUS?
Just in case that I can do it both ways, then what's the difference between the two?
Thanks much!

same IP is not fine!

use the 10.10.10.21 IP for the instances virtual IP and DBCLUS for the instances virtual network name. Keep these unique from the Windows cluster group resources 10.10.10.20 and WDCLUS

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

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

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 5

same IP is not fine!
use the 10.10.10.21 IP for the instances virtual IP and DBCLUS for the instances virtual network name. Keep these unique from the Windows cluster group resources 10.10.10.20 and WDCLUS

Can you justify it (for Default Instance) please?

Perry Whittle SSC Guru Points: 234064 More actions · Answer 6

justify what???

each instance whether default or named require unique IP and virtual network name. The cluster group IP and network name are for explicitly that, the cluster group.

This link details the following

MSDN
Therefore, the name you provide for the instance of SQL Server, including the default instance, must be unique across all nodes in the failover cluster.

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

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

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 7

Sorry to bother you Perry. I am just trying to understand for one default instance why do I need two IPs?

For example, try naming the hosts SQL01A and SQL01B. Then name the Windows cluster SQL01. This naming convention tells you that the SQL01A and SQL01B are the nodes and that SQL01 is the base of the cluster. Then name the SQL Server cluster SQL01V01. This name tells you that SQL01V01 is the first server on the Windows cluster. If you need to install a second instance, you'd name it SQL01V02, and so on, with each instance being a separate server in the SQL01 cluster.

The example says IF I need two (or more) Instances than this naming (and supposing IPs) is required. If we don’t have 2 instances we can still follow the same pattern I agree on it. I am just curious to know ‘Is it a compulsion?’

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 8

Perry Whittle (11/24/2011)
[font="Arial"][/font]justify what???
each instance whether default or named require unique IP and virtual network name. The cluster group IP and network name are for explicitly that, the cluster group.
This link details the following
MSDN
Therefore, the name you provide for the instance of SQL Server, including the default instance, must be unique across all nodes in the failover cluster.

I posted my doubt and meanwhile you also updated your last post. I was looking for this precise information only. Thanks Perry.

Perry Whittle SSC Guru Points: 234064 More actions · Answer 9

😉

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

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