SQLDBA-536161 (10/17/2011)
Hi Gurus,I'm having trouble understanding SQL Server active/active cluster model. I was asked by our management about the difference between active/passive active/active to run SharePoint 2010.
I know what is active/passive means. I’m trying to make sense out of active/active. So in active/active, you have 2 instances running on each node. Say
In a two node Windows 2008 cluster server,
Instance share2010 running on node1 as active and share2010 running on node2 as passive
Instance share2010_2 running on node2 as active and share2010_2 running on node1 as passive
Can someone please explain how application(SharePoint 2010) failover would work ?
And how data between 2 instances are sync ?
What is your goal here? Two different sharepoint sites, eg. sharepoint1.domain.com and sharepoint2.domain.com or are you just having sharepoint.domain.com?
If you are having just sharepoint.domain.com then you want active passive. If you are having sharepoint1.domain.com and sharepoint2.domain.com then you can either have active passive and have the databases on the same instance aslong as they names are different, e.g WSS_Content_SP1, WSS_Content_SP2, or you could go active active with two SQL instances, and the db's could be called the same, e.g WSS_Content.
The data would not sync between the two instances and the failover would be just like a normal fail over, where the resource group moves over to the second node and starts up, and its the same instance, same databases, then Sharepoint will continue to work, no change nessesary.