August 5, 2011 at 4:14 am
In all the guides, etc it only talks about an Active/Passive setup and not an Active/Active setup.
In an Active/Passive setup I know you do this:
Node1
1) New SQL Server Faileover Cluster Installation
Node2
2) Add node to a SQL Server Faileover Cluster
but in an Active/Active setup is it as logical as this?
Node1
1) New SQL Server Faileover Cluster Installation
4) Add node to a SQL Server Faileover Cluster
Node2
2) Add node to a SQL Server Faileover Cluster
3) New SQL Server Faileover Cluster Installation
Another question I had was I've created 2 MSDTC resource groups and plan on attaching them to each node as per the "Mapping an Instance of SQL Server 2008 to an Instance of MSDTC" section of this document by Microsoft. Anything wrong with this approach?
August 5, 2011 at 5:43 am
It isn't really a true Active/Active as one instance isn't aware of the other. Its more like dual Active/Passive. But it is as logical as you stated
Node1
1) New SQL Server Faileover Cluster Installation (Instance1)
4) Add node to a SQL Server Faileover Cluster (Instance2)
Node2
2) Add node to a SQL Server Faileover Cluster (Instance1)
3) New SQL Server Faileover Cluster Installation (Instance2)
August 5, 2011 at 5:49 am
Thanks, good to hear that it is as I thought.
Did you see my MSTDC question in the original post? Any comment there?
August 5, 2011 at 6:02 am
It sounds right to me, but I'd wait to hear another opinion. I have only done it twice
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply