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 2010 AlwaysOn Availability Group Expand / Collapse
Author
Message
Posted Thursday, April 18, 2013 12:48 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 19, 2013 10:20 PM
Points: 17, Visits: 71
Hello Guys,

I am about to implement sql server 2012 AwalysOn Availability group and my question is around storage.

Does AlwaysOn availability group work with Shareddisk or only disk that are local to the computer(node)?


Thank you
Post #1443620
Posted Thursday, April 18, 2013 1:52 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: Today @ 9:36 AM
Points: 711, Visits: 2,211
Hi,

You could use them with a shared disk but I don't know that I'd do that (you'd have to store two or more copies of the database on the shared storage). I'd configure a windows failover cluster where there's shared storage.

Where there is no shared storage then I'd evaluate Always On.

Thanks,


Simon




MCSE: Data Platform
MCSE: Business Intelligence
Follow me on Twitter: @WazzTheBadger
LinkedIn Profile: Simon Osborne
Post #1443644
Posted Thursday, April 18, 2013 2:16 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 19, 2013 10:20 PM
Points: 17, Visits: 71
Hi,

Thank you for the prompt reply. So you reckon that using Shared disk for AlwaysOn availability groups would be a challenge?

The design here is to have an active secondaries that will accept only read only queries. In the case of shared storage can a specific disk be presented to only a node only and the other in WSFC won't have access to it?


Kind Regards,

Shola
Post #1443655
Posted Thursday, April 18, 2013 2:21 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: Today @ 9:36 AM
Points: 711, Visits: 2,211
phebsix (4/18/2013)
So you reckon that using Shared disk for AlwaysOn availability groups would be a challenge?


No, just not worth doing in my opinion. If the storage is shared why double your storage requirement so that you can use Always On. Also if you're looking to have a readable secondary to offload reporting from the primary database surely you'd want that on seperate storage? Otherwise you'll more than likely have the same bottlenecks as before.

The design here is to have an active secondaries that will accept only read only queries.


Great!, exactly what always on can be used for.

In the case of shared storage can a specific disk be presented to only a node only and the other in WSFC won't have access to it?


Yes that is possible. What do you mean by shared storage? Are we talking about a SAN here? or a shared disk array?




MCSE: Data Platform
MCSE: Business Intelligence
Follow me on Twitter: @WazzTheBadger
LinkedIn Profile: Simon Osborne
Post #1443659
Posted Thursday, April 18, 2013 3:35 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 19, 2013 10:20 PM
Points: 17, Visits: 71
Hi Thanks for the great clarification with regards shared storage I am talking about SAN disks.

Thanks once again
Post #1443701
Posted Thursday, April 18, 2013 3:40 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: Today @ 9:36 AM
Points: 711, Visits: 2,211
In that case yes, the SAN admin should be able to create volumes that are restricted to particular servers. But... I'd still favour clustering here over Always On.



MCSE: Data Platform
MCSE: Business Intelligence
Follow me on Twitter: @WazzTheBadger
LinkedIn Profile: Simon Osborne
Post #1443702
Posted Thursday, April 18, 2013 3:47 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 19, 2013 10:20 PM
Points: 17, Visits: 71
Ok mate thank you so much for this, truly helpful.

Post #1443708
Posted Thursday, April 18, 2013 6:56 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:46 AM
Points: 6,751, Visits: 14,395
The whole point of AlwaysOn is that you don't have shared storage. There's nothing to say that the disks cant be SAN based but they're not shared across the windows cluster.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1443820
Posted Thursday, April 18, 2013 7:53 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 9:09 AM
Points: 4,471, Visits: 6,400
Given the really basic nature of the questions you are asking I feel you should REALLY get someone experienced and knowledgeable to help you determine what your HA/DR/read-only scale-out needs are and then help you configure the proper solution for those needs. What you are dealing with isn't something you just ask a few questions about on a forum and then slap into production and hope things work out OK. I have seen some really unfortunate things happen (including companies going out of business) due to messing things like this up.

Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #1443876
Posted Thursday, April 18, 2013 8:45 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:46 AM
Points: 6,751, Visits: 14,395
TheSQLGuru (4/18/2013)
Given the really basic nature of the questions you are asking I feel you should REALLY get someone experienced and knowledgeable to help you determine what your HA/DR/read-only scale-out needs are and then help you configure the proper solution for those needs. What you are dealing with isn't something you just ask a few questions about on a forum and then slap into production and hope things work out OK. I have seen some really unfortunate things happen (including companies going out of business) due to messing things like this up.

I couldn't agree more Kevin


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1443916
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse