Hello everyone, Hope someone can offer some advice \ confirmation here. Looking at setting up a cluster solution between 2 geographic sites. site 1 looking to have 2 machines running SQL 2008 Standard. Main site for prod databases. - Would that have to be active \ passive ? Second site SQL 2008 standard. - Assume that would have to be passive as well , as this is the geographic DR site. My questions are , - Does SQL 2008 standard support this 3 node model ? - Have I got the config correct for the Cluster ? - Any major gotcha's to be aware of in the planning phase ? - What is minimum I am looking at for the SAN config , so I can go back to network team to confirm my requirements are in place ? Many thanks everyone.
+1 to WilliamD, but I will provide some specific answers: > Main site for prod databases. - Would that have to be active passive ? Yes, it would. However, Active-Passive refers to a cluster group. I.e. only one side of the cluster group can be active at any one time. There is nothing stopping you from running two cluster groups, each of which are naturally active on different cluster nodes. When people talk about Active-Active with SQL Server, that's typically what they mean. However, for this to work you need separate SQL Server instances. > Does SQL 2008 standard support this 3 node model ? SQL Server doesn't really care. It cares about O/S support and the fact that shared storage is available. It is possible to have three nodes in a cluster, but, as WilliamD says, this might not be your best option for Geographic DR. > Have I got the config correct for the Cluster ? That's not really answerable. You would need to provide a lot more information about what your requirements were. > Any major gotcha's to be aware of in the planning phase ? Licensing. Be very careful when you look at it, because the licensing for SQL Server is complicated. I mean, it's nowhere near as bad as Oracle (which, frankly, makes you want to stick sharp pencils up your nose), but you do need to read the documentation on licensing carefully, and make sure that you are referring to the up-to-date document. > What is minimum I am looking at for the SAN config, so I can go back to network team to confirm my requirements are in place ? That depends entirely on your requirements. A 1MB database will do fine on any SAN, with a 10TB database - you need to look at it more carefully. A good place to start is [Brent Ozar's blog]. :
Think about your underlying clustering technology too - are you tied to Microsoft Clustering or can you look at running Veritas Clusters? There are, as always, pros and cons to both. For example, the MS clustering will keep the nodes in sync (ie service packs etc), but only for the software it knows of as being "cluster-aware"; VCS cluster will allow you to cluster *any* service, but you'll have more work to do keeping the software levels on the nodes in sync.. EDIT: "other clustering technologies exist." *ahem*