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 2012 and AG's Expand / Collapse
Author
Message
Posted Friday, June 14, 2013 9:40 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 9, 2013 8:19 AM
Points: 179, Visits: 751
Recent post from Brent Ozar. Is what he is saying correct.

In SQL 2012, if your primary drops offline or the cluster loses quorum, the readable replica databases drop offline. (This is hilarious because it’s right when you really want to be able to query the secondaries.) No way to control it – it’s totally automatic. In SQL 14, the secondaries remain online and readable when the primaries aren’t available.

Also are secondaries always just readable copies and therefore can not be used in a DR plan.
Post #1463653
Posted Friday, June 14, 2013 9:49 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, September 25, 2014 2:41 AM
Points: 689, Visits: 2,786
Bobby Glover (6/14/2013)
Recent post from Brent Ozar. Is what he is saying correct.

In SQL 2012, if your primary drops offline or the cluster loses quorum, the readable replica databases drop offline. (This is hilarious because it’s right when you really want to be able to query the secondaries.) No way to control it – it’s totally automatic. In SQL 14, the secondaries remain online and readable when the primaries aren’t available.

Also are secondaries always just readable copies and therefore can not be used in a DR plan.


To my knowledge yes if the cluster looses quorum the yes it will drop offline depending on your setup, a way around this is to give a quorum vote to a file on a network location this will enable a majority vote.

Secondaries can be readable copies (they don't have to be) but they certainly can be used in a DR plan, if you use synchronous commit then if the primary goes offline then the secondary will automatically fail over and become the primary, if you use asynchronous commit then the fail over has to be done manually.


==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
Post #1463658
Posted Friday, June 14, 2013 12:48 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 9, 2013 8:19 AM
Points: 179, Visits: 751
Thanks, does this apply to when the Primary db falls offline too.
Lets say san administrator removed the disks that held the mdf and Ldf files. This would also force the sec, offline.

If this is the case that is very poor.
Post #1463738
Posted Monday, June 17, 2013 2:08 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 9, 2013 8:19 AM
Points: 179, Visits: 751
Ok, if my secondaries go offline. Can I bring them online
manually and turn one into the Primary.
Post #1464021
Posted Tuesday, June 18, 2013 6:37 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, September 26, 2014 6:02 AM
Points: 919, Visits: 1,434
Bobby Glover (6/14/2013)
Thanks, does this apply to when the Primary db falls offline too.
Lets say san administrator removed the disks that held the mdf and Ldf files. This would also force the sec, offline.

If this is the case that is very poor.


If set to "automatic failover", synchronous commit, it should fail over to the secondary provided a quorum exists. You should consider created a file share witness for a two node cluster in order to retain a quorum.

If you don't have a quorum, then it will go "offline" which is how a physical cluster also works. A physical cluster goes "offline" when the quorum is lost.

Here are some MS articles regarding file share witness and HA.

http://blogs.technet.com/b/askpfeplat/archive/2012/06/27/clustering-what-exactly-is-a-file-share-witness-and-when-should-i-use-one.aspx

http://technet.microsoft.com/en-us/library/cc770620(v=ws.10).aspx

Steve



Post #1464620
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse