Multi Site Clustering

Question

Multi Site Clustering

SQL Show

SSCertifiable

Points: 6143
More actions
July 20, 2012 at 2:38 am

#259282

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).

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113507 More actions · Answer 1

These might help you out.

http://clusteringformeremortals.com/2009/09/15/step-by-step-configuring-a-2-node-multi-site-cluster-on-windows-server-2008-r2-%E2%80%93-part-1/

http://clusteringformeremortals.com/2009/09/18/step-by-step-configuring-a-2-node-multi-site-cluster-on-windows-server-2008-r2-%E2%80%93-part-2/

http://clusteringformeremortals.com/2009/10/07/step-by-step-configuring-a-2-node-multi-site-cluster-on-windows-server-2008-r2-%E2%80%93-part-3/

SQL Show SSCertifiable Points: 6143 More actions · Answer 2

SQL Show

SSCertifiable

Points: 6143

July 20, 2012 at 7:01 am

#1515496

Thank you, I will have look surely.

Perry Whittle SSC Guru Points: 234013 More actions · Answer 3

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" 😉