How does the second instance in a SQL 2008 R2 cluster handle the virtual server and IP routing?
Ok - we are trying to clarify some questions we are having with our SQL cluster...
OS: Windows 2008 R2
SQL: 2008 R2 Ent
Virtual server name: net-moss
instance one: moss 192.168.1.2
instance wanted to add: dw 718.104.22.168
It is our assumption that each instance is assigned it's own IP and resource group. That part is fine with the first instance running on NODE 1. When you create the first instance it asks you for the virtual server name as it appears to the network as that IP addres of that instance.
What we want to do is add a second instance to run on NODE 2 but still be in the same virtual server. Basically going to an Active/Active situation( yes it's actually two active/passive instances).
1)Is this configuration possible and how is the routing done from DNS to virtual server through to the actual instance name itself since it has a different IP?
2) we are assuming that DNS will point to the instance we want.
3) IF we make DNS point the IP directly then what's the point of the Virtual Server appearing on the network? It woudln't be wise to use any virtual server name in a connection for the ability to move the instance to a new server whithout app recinfiguration. So if DNS points all the way to the instance what's the point of the instance name in the connection other than just more required info?
4) We are also assuming ecah instance can fail to the other server and allocated to the nodes independently.
Confused since the virtual server would point to only one instance IP???