Sql Server 2008 r2 active/active configuration

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » Sql Server 2008 r2 active/active...

Sql Server 2008 r2 active/active configuration

Rate Topic

Display Mode

Topic Options

Author

Message

phebsix

Posted Monday, March 18, 2013 1:49 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 10:11 AM
Points: 17, Visits: 70

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

Post #1432096

GilaMonster

Posted Monday, March 18, 2013 2:29 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 9:40 AM
Points: 38,086, Visits: 30,380

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 2008, MVP
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

Post #1432101

phebsix

Posted Monday, March 18, 2013 2:41 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 10:11 AM
Points: 17, Visits: 70

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

Post #1432106

Perry Whittle

Posted Tuesday, March 19, 2013 9:33 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 9:12 AM
Points: 5,242, Visits: 11,261

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

Post #1432740

phebsix

Posted Tuesday, March 19, 2013 10:09 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 10:11 AM
Points: 17, Visits: 70

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

Post #1432758

« Prev Topic | Next Topic »

Permissions