Date: February 5, 2018
Tags: AlwaysOn Availability Groups, alwayson availabilty groups limitations, DataKeeper, SIOS DataKeeper Cluster Edition, SQL Server 2012 Enterprise Edition
Overcome Alwayson Availabilty Groups limitations with SIOS Datakeeper
After hearing all of the great sessions at SQL PASS Summit on Availability Groups, are you thinking about biting the bullet to upgrade to SQL Server 2012 Enterprise Edition? Before you get your checkbook out, stop and ask yourself these questions and also, allow me to introduce SteelEye DataKeeper Cluster Edition.
Do I use/need
- to lower my SQL Server cost?
- replication or log shipping?
- to minimize the impact that replication has on the performance of my application?
- Lync Server, Dynamics CRM or other applications that use distributed transactions?
- to ensure that SQL Agent jobs such as database backups, optimizations, DTS and others continue to run regardless of the node in service?
- to ensure that SQL login accounts are kept in sync between cluster nodes?
- to minimize my administrative burden?
Alwayson Availabilty Groups Limitations
If you answered yes to any of these questions, you may want to reconsider your options when it comes to your SQL Server HA/DR deployment. While AlwaysOn Availability Groups certainly have their place, you may want to consider the overhead associate with them. Read my previous article. Also, you really need to consider what applications will be utilizing the SQL Server database as not all applications support AlwaysOn Availability Groups. This includes many of Microsoft’s applications such as Lync Server and others (check your application documentation).
Introducing SteelEye DataKeeper Cluster Edition
What I would propose instead is to consider building a traditional active/passive cluster which overcomes all of the Alwayson Availabilty Groups Limitations listed above. But instead of using shared storage, use the cluster integrated block level replication solution from SIOS Technology called SteelEye DataKeeper Cluster Edition. Using this replication solution, you are able to eliminate the SAN as a single point of failure as well as eliminate all of the limitations associated with AlwaysOn Availability Groups listed above. When you consider the possibility of using high speed local storage solutions such as @Fusionio in conjunction with DataKeeper, you can have a high speed, highly available SQL Server cluster with a minimal investment in hardware and software. And best of all, this solution works with SQL 2005/2008/2008R2/2012 Standard Edition as well as Enterprise Edition. The cost saving alone on SQL Server licensing can more than pay for the solution. More on costs saving in my next post.
How Should I Start?
You can buy a 2 server pre-package solution that includes HP, Dell or Supermicro servers, Fusion-io ioDrives. DataKeeper software to help you deploy you first high speed, highly available SQL cluster. For more information see the press release here.
Like how Datakeeper help overcome Alwayson Availabilty Groups limitations? Read here for more success stories
Reproduced with permission from Clusteringformeremortals.com