29 Maret 2012 15:33
Im wanting to create a sql cluster with shared storage and a mirror within an availability group. Im finding the terminology used within HADRON a bit confusing, many of the articles refer to separate installs for each node within an availability group.
Is this really the way to set this up in Hadron or is there a way to use an old style cluster and still have it part of hadron?
29 Maret 2012 16:31
HADRON is now SQL 2012 AlwaysOn Feature.
You have to create a Windows Cluster with Windows 2008 or 2008 R2 (You can create cluster with no shared storage). After Windows cluster is installed, you have to install SQL 2012 and enable the HADR / AlwaysOn feature. Then you will be able to create an Availability Group and add databases to it.
You can see this video which explain more about AlwaysOn
Remember that Database mirroring is still available
29 Maret 2012 17:09Moderator
Technically, SQL 2012 AlwaysOn includes both Failover Clustered Instances (FCI) and Availability Groups (formerly HADRON). Both technologies use Windows Server Failover Clustering as the distributed failure detection and management system. FCI uses shared storage while Availability Groups uses local storage on each node with SQL handling the data synchronization.
Geoff N. Hiten Principal Consultant Microsoft SQL Server MVP
- Disarankan sebagai Jawaban oleh VR38DETTMicrosoft Community Contributor 30 Maret 2012 2:27
03 April 2012 5:17
Yes, you can create a 2-node shared storage cluster just like you did in the old days and also have a 3rd node that is the target of AlwaysOn Availability Group. I set it up once and I am planning on doing it again and writting a blog article on it as it is not very intuitve. It has been a while, but from what I recall, you have to build your SQL shared storage cluster as you previously did in the old days. Then, install a standalone instance of SQL on a different server. You have to add that server to the cluster by using "Add Node" and then create your Availabilty Group between the clustered instance of SQL and the Standalone instance of SQL.
Sorry I couldn't be more specific, if I have a chance I'll re-visit the configuration this week and write a step-by-step article.
David A. Bermingham, MVP, Senior Technical Evangelist, SIOS Technology Corp
- Ditandai sebagai Jawaban oleh Blakmk 04 April 2012 10:52
04 April 2012 15:07Thanks for the help guys, will check it out.
15 Mei 2012 15:32I managed to put together a blog post for this in case anyone else has the same confusion http://www.sqlinstallation.com/sql-server-2012-cluster-step-step-installation-guide/