July 20, 2012 at 2:38 am
Hi Folks,
1. Can Multisite clustering work on single node per site? Like Node1 on Site A and Node2 on SiteB provided SAN replication.
2. Can current working IP address of virtual name go offline for some reason other than sql server goes offline.
say, Site A is hosting the Sql Service with 1.1.1.0 is the current working IP and client is now being connected to this IP. Is there possibility that 1.1.1.0 goes offline / not reachable to client by some other means, even though Sql Service is working online? If this happens, will failover happen to SiteB? ( say thats Site B with IP address 1.1.1.1).
July 20, 2012 at 5:26 am
These might help you out.
July 20, 2012 at 7:01 am
Thank you, I will have look surely.
July 20, 2012 at 10:21 am
dbasql79 (7/20/2012)
Hi Folks,1. Can Multisite clustering work on single node per site? Like Node1 on Site A and Node2 on SiteB provided SAN replication.
Yes it can.
dbasql79 (7/20/2012)
2. Can current working IP address of virtual name go offline for some reason other than sql server goes offline.say, Site A is hosting the Sql Service with 1.1.1.0 is the current working IP and client is now being connected to this IP. Is there possibility that 1.1.1.0 goes offline / not reachable to client by some other means, even though Sql Service is working online? If this happens, will failover happen to SiteB? ( say thats Site B with IP address 1.1.1.1).
While Windows 2008 will support multiple IP subnets for a clustered application, SQL server 2005\2008 do not. Typically you would use a VLAN address that is in an address range reachable on both sites.
Check the following links for more info
http://technet.microsoft.com/en-us/library/dd197575(v=ws.10).aspx
http://msdn.microsoft.com/en-us/library/ff878716.aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy