March 18, 2013 at 1:49 am
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
March 18, 2013 at 2:29 am
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
March 18, 2013 at 2:41 am
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
March 19, 2013 at 9:33 am
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" 😉
March 19, 2013 at 10:09 am
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply