Listening over multiple IP''s
-
I'm implementing a couple of new Itaniums in a cluster. Right now the network is limited to 100Mbs, we also have another network segment running 1000Mps.
I'd like to hook up one set of NIC's to the 100Mps connection and the other to the 1000Mps connection. My question is (especially as these are going to be clustered machines), will SQL listen to and respond on both connections, or will it, given that the 1000Mps connection will not be routable, return traffic that comes in on that NIC back through that NIC or would it attempt to send it through the 100Mps? And would this cause a performance issue?
-
It will listen on both connections and route accordingly. I don't think you want to bridge the connections and route traffic between them.
I used to have 3 networks connected (3 NICs) on one of our boxes. 1 for the web server traffic, 1 for DBA/developer traffic from the office and 1 dedicated to backup traffic. No issues and they were 100Mbps for some, 10Mbps for others.
-
Have you done this within a cluster?
I'd like to team the connections, 2 to Gb, 2 to 100Mbs, 1 private cluster
-
... and i thought OUR system had redundancy!?
Yes, this will work fine ... SQL will just see the team as a single NIC (as does anything!) and the communication will work as Steve said!
Now ... what you REALLY wanna do next is do what we did with our web-servers ... where we have Network Load Balanced Teams across 3 servers ... now THATS fun!!
Cheers
Mark
-
Less to do with redundancy and more to do with trying to get the best performance. The backbone to the data center here is 100Mb, but we have a private Gb network also. I'm going to have the 100Mb available for connection from external processes, however I plan to use the Gb for all internal connections (including the web servers).
Never seen network load balanced teams across 3 servers other than through a switch and virtual ip, how are you going to accomplish that?
-
it's already done ... and is quite easy really! each webserver (x3) has a front end NIC team and they're then just load-balanced with the Windows Network Load Balancing (with several Virtual IPs, actually!). Works perfectly fine ... just a few too many MACH addresses around!?
-
Ah, ok, never used the windows load balancer (always been fortunate enough to be somewhere with network guys who handle that at the switch level).
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply