SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 Availability Groups and DR (2012)
 Build multi subnet active / active cluster
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sachinonnet
Starting Member

India
4 Posts

Posted - 06/19/2013 :  07:48:12  Show Profile  Reply with Quote

Hi,

my company had offices in 4 different geographical location and want to build Multi subnet cluster with active / active, to make database available for all location to update centrally. Our intention is to connect cluster database through local active instance to get performance.

1. I like to know is it possible to build active / active multi subnet cluster ?
2. If not what could be the best solution in sql to resolve this ? We Implemented replication but they create data conflict.

regards
sachin


Edited by - sachinonnet on 06/19/2013 08:02:31

tkizer
Almighty SQL Goddess

USA
37287 Posts

Posted - 06/19/2013 :  21:13:49  Show Profile  Visit tkizer's Homepage  Reply with Quote
Yes that's possible with AlwaysOn, provided you only require to write to one replica. We are implementing a multi-subnet cluster right now using AlwaysOn. Works great as long as your firewall holes are open and the cluster is configured properly.


Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

sachinonnet
Starting Member

India
4 Posts

Posted - 06/20/2013 :  00:17:51  Show Profile  Reply with Quote
Thanks Tara,

Great, I like to know more on storage configuration, are you using storage replication or how you configure storage?
I gone through below url

http://msdn.microsoft.com/en-IN/library/ff878716.aspx

Sachin

Edited by - sachinonnet on 06/20/2013 00:18:38
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37287 Posts

Posted - 06/24/2013 :  18:22:41  Show Profile  Visit tkizer's Homepage  Reply with Quote
We aren't using shared storage in our AlwaysOn clusters. The only shared resource is a Quorum disk on our 2-node clusters. On our 3-node clusters, we are using node majority so nothing is shared.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000