Cluster name with multiple IP addresses?

Can 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
It 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@.yahoo.com> wrote in message
news:%23Y%23s8Mv0HHA.5380@.TK2MSFTNGP04.phx.gbl...
> Can 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
>
|||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@.gmail.com> wrote in message
news:OQYwDPx0HHA.1184@.TK2MSFTNGP04.phx.gbl...
> It 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@.yahoo.com> wrote in message
> news:%23Y%23s8Mv0HHA.5380@.TK2MSFTNGP04.phx.gbl...
>
|||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@.yahoo.com> wrote in message
news:Ooh45iT2HHA.2752@.TK2MSFTNGP06.phx.gbl...
> 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@.gmail.com> wrote in message
> news:OQYwDPx0HHA.1184@.TK2MSFTNGP04.phx.gbl...
>