Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sql Server 2008 r2 active/active configuration Expand / Collapse
Author
Message
Posted Monday, March 18, 2013 1:49 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 19, 2013 10:20 PM
Points: 17, Visits: 71
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
Posted Monday, March 18, 2013 2:29 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 6:16 AM
Points: 39,897, Visits: 36,242
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
Posted Monday, March 18, 2013 2:41 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 19, 2013 10:20 PM
Points: 17, Visits: 71
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
Posted Tuesday, March 19, 2013 9:33 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:46 AM
Points: 6,378, Visits: 13,719
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"
Post #1432740
Posted Tuesday, March 19, 2013 10:09 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 19, 2013 10:20 PM
Points: 17, Visits: 71
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 »

Add to briefcase

Permissions Expand / Collapse