June 14, 2013 at 9:40 am
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.
June 14, 2013 at 9:49 am
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
June 14, 2013 at 12:48 pm
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.
June 17, 2013 at 2:08 am
Ok, if my secondaries go offline. Can I bring them online
manually and turn one into the Primary.
June 18, 2013 at 6:37 am
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://technet.microsoft.com/en-us/library/cc770620(v=ws.10).aspx
Steve
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply