Re: Cluster name with multiple IP addresses?
- From: "Geoff N. Hiten" <SQLCraftsman@xxxxxxxxx>
- Date: Wed, 8 Aug 2007 07:58:50 -0400
OK, you are not trying to stack multiple IP addresses on a single NIC, you are using a unique IP address for each NIC. That isn't a problem.
The problem comes from having the same DNS alias (network name) respond on two different subnets. That is a networking issue, not a clustering issue. I would use connection-specific domain suffixes to differentiate the networks. Also, I would use DNS SRV records to abstract the names. I.E. MySQLCluster points to the IP and port of the normal public NIC. MySQLClusterBackup points to the IP and port on the backup LAN.
I have used this setup in the past and it works just fine.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Structured Chaos" <jeffery_tyree@xxxxxxxxx> wrote in message news:Ooh45iT2HHA.2752@xxxxxxxxxxxxxxxxxxxxxxx
Thanks for the quick info. Apparently it is a little more difficult than that, heheh
I did not see any dialog/screen that allowed for the addition of new network - only to modify node membership.
I have a ticket opened with MS. They have escalated it stating that they don't even know if SQL will support this configuration and are attempting to duplicate it in their labs. The MS SQL Data Engine Team manager stated they may even have to look at the code...
Should you happen to have any detailed steps on making this work, I'd appreciate it and apparently MS would too! LOL
"Geoff N. Hiten" <SQLCraftsman@xxxxxxxxx> wrote in message news:OQYwDPx0HHA.1184@xxxxxxxxxxxxxxxxxxxxxxxIt is not an uncommon request, nor is it too difficult. Once you have the NICs and networks defined in the cluser configuration, you run the SQL setup wizard to add the networks to SQL Server. To use them effectively, look into connection-specific suffixes. That way you can force traffic to a particular network.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Structured Chaos" <jeffery_tyree@xxxxxxxxx> wrote in message news:%23Y%23s8Mv0HHA.5380@xxxxxxxxxxxxxxxxxxxxxxxCan multiple IP addresses be assigned to a cluster and/or virtual name?
I have a 2-node Active/Passive cluster on a switched (not routed) network.
Each node has 3 NICs, each on its own subnet;
a) public/client access - 192.168.10.0
b) private/cluster traffic - 10.0.0.0
c) data backup network - 192.168.20.0
The cluster name "SQLCLST" and the virtual machine name "SQLSVR" have been defined with IP addresses on the public/client network.
My backup software is cluster aware but because the traffic is separated via switched network, I need the cluster and/or virtual machine name to respond to IP addresses on two different subnets. Is this possible? Did this make sense? ;)
TIA
.
- References:
- Re: Cluster name with multiple IP addresses?
- From: Structured Chaos
- Re: Cluster name with multiple IP addresses?
- Prev by Date: do clustered servers have to be in same domain
- Next by Date: Re: do clustered servers have to be in same domain
- Previous by thread: Re: Cluster name with multiple IP addresses?
- Next by thread: do clustered servers have to be in same domain
- Index(es):
Relevant Pages
|
