Sql Server 2008 r2 active/active configuration

Question

Sql Server 2008 r2 active/active configuration

phebsix

SSC Veteran

Points: 288
More actions
March 18, 2013 at 1:49 am

#272261

Hello guys,
Please can anybody point in right direction of implementing sql server failover clustering in active/active mode.
There are alot of information on the internet about active/passive mode, but quite scanty information about active/active.
Thanks

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

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Active /active (which really is a tern that shouldn't be used any longer) is just 2 active/passive SQL server failover instances on the same cluster.

More correctly called 'multi-instance cluster', it means you have a 2 node cluster with 2 SQL Server instances running on it (each serving their own databases), one instance runs on node 1, one runs on node 2. If either node fails, the instance running there fails over to the remaining node, resulting in 2 SQL instances running on the same node.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

phebsix SSC Veteran Points: 288 More actions · Answer 2

Thanks Gila,

Good clarification. So I don't need to make any further configuration on any of the cluster service like the MSDTC service? like it was done on this article http://blogs.technet.com/b/meamcs/archive/2012/04/12/creating-an-active-active-sql-cluster-using-hyper-v-part3-the-active-active-configuration.aspx

Thanks in advance

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

Creating a clustered DTC service to run on each node wont harm anything, do you have a lot of DTC activity in the cluster?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

phebsix SSC Veteran Points: 288 More actions · Answer 4

I don't have any specific requirement to use DTC features like replication, I was just pointing to the blog article that seem to make the configuration MSDTC pertinent for the achievement of a multi instance cluster.

So is that configuration really necessary?

Thank you