November 7, 2012 at 9:57 pm
Hi All,
With SQL 2012, one can setup multi-site (multi-subnet) failover clusters. I wonder if you can have one active node running in Site A, and another active node running in Site B?
For example, if I have a 4-node cluster across 2 sites A and B, 4 nodes in Site A and 2 nodes in Site B. Can I have 1 active node in Site A and 1 active node in Site B at the same time?
Any hint is much appreciated
November 8, 2012 at 5:15 am
rupengzhao (11/7/2012)
4 nodes in Site A and 2 nodes in Site B. Can I have 1 active node in Site A and 1 active node in Site B at the same time?Any hint is much appreciated
Dont you 2 nodes in site a and 2 nodes in site b or are you implementing a 6 node cluster
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 8, 2012 at 2:55 pm
Sorry Perry, that was a typo, I meant to say 4-node cluster across 2 sites A and B, 2 nodes in Site A and 2 nodes in Site B.
November 9, 2012 at 5:24 am
rupengzhao (11/7/2012)
Hi All,With SQL 2012, one can setup multi-site (multi-subnet) failover clusters.
This is also possible with Windows and SQL Server 2008
rupengzhao (11/7/2012)
I wonder if you can have one active node running in Site A, and another active node running in Site B?For example, if I have a 4-node cluster across 2 sites A and B, 4 nodes in Site A and 2 nodes in Site B. Can I have 1 active node in Site A and 1 active node in Site B at the same time?
Any hint is much appreciated
Yes you can but you need to make sure that connectivity is good though. If a clustered instance of SQL is up on site b and is accessed by users on site a, the network could be the bottleneck.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 11, 2012 at 3:06 pm
Thanks Perry for the advice.
November 11, 2012 at 4:54 pm
Perry Whittle (11/9/2012)
rupengzhao (11/7/2012)
Hi All,With SQL 2012, one can setup multi-site (multi-subnet) failover clusters.
This is also possible with Windows and SQL Server 2008
I've been researching this as well for my shop, but everything I'm seeing indicates that SQL Server 2008 & 2008 R2 do not support multi-subnet clustering; you would need both sites to be on the same subnet. Multi-subnet capability is apparently new to 2012 (and confined to Enterprise Edition).
A couple of the sources I had bookmarked:
http://www.sqlsoldier.com/wp/sqlserver/multsubnetfailoverclusters
November 12, 2012 at 6:12 am
charmon79 (11/11/2012)
Perry Whittle (11/9/2012)
rupengzhao (11/7/2012)
Hi All,With SQL 2012, one can setup multi-site (multi-subnet) failover clusters.
This is also possible with Windows and SQL Server 2008
I've been researching this as well for my shop, but everything I'm seeing indicates that SQL Server 2008 & 2008 R2 do not support multi-subnet clustering; you would need both sites to be on the same subnet. Multi-subnet capability is apparently new to 2012 (and confined to Enterprise Edition).
A couple of the sources I had bookmarked:
http://www.sqlsoldier.com/wp/sqlserver/multsubnetfailoverclusters
You merely need to implement a VLAN to extend to both sites
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply