Date: July 28, 2023
Tags: High Availability
SQL Server High Availability
SANless High Availability On-Premises and in the Cloud
SIOS software enables high availability and disaster recovery for SQL Server operating in any combination of physical, virtual, cloud, or hybrid cloud without the cost and complexity of a SAN or other shared storage.
SIOS DataKeeper Cluster Edition for SQL Server High Availability
Microsoft Windows Server Failover Clustering (WSFC) is commonly used to provide high availability for SQL Server. It implements full coordination of redundant computing resources and automatically manages the recovery of SQL Server operations and data on a standby node in the event of server or application failure. But WSFC requires expensive SAN hardware or complex shared storage in the cloud.
Simply add SIOS DataKeeper Cluster Edition to WSFC to easily create a SANless cluster for SQL Server high availability and disaster recovery in the cloud, in virtualized environments such as VMware or Hyper-V, or on physical servers.
SIOS DataKeeper Cluster Edition software is a fully certified Microsoft Azure high availability solution.
Learn more about SIOS DataKeeper Cluster Edition
SQL Server High Availability and Disaster Recovery in Cloud and Hybrid Cloud
SIOS DataKeeper lets you run your business-critical applications in a flexible, scalable cloud environment, such as Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform without sacrificing performance, high availability or disaster protection. SIOS DataKeeper is available in the AWS Marketplace and Azure-certified high availability software for WSFC is offered in the Microsoft Azure Marketplace.
Scale Out File Server (SOFS) and Storage Spaces Direct (S2D), two technologies offered in Microsoft Windows for sharing disks, can’t be used in a cluster for sharing disks across cloud regions and availability zones, putting SQL Server at risk of downtime.
In contrast, SIOS DataKeeper Cluster Edition provides high availability cluster failover across cloud regions and availability zones – giving you significantly greater protection from a broad class of failures.
|SQL Server Always On Availability Groups||SIOS DataKeeper with SQL Server Always On Failover Clusters|
|Requires costly SQL Server Enterprise Edition||Save up to 70% on software licensing costs and provides enterprise-class clustering features by using SQL Server Standard Edition with SIOS DataKeeper.|
|Cloud limited IP addresses.||SIOS supports unlimited databases. No need to keep track or worry about failures.|
|Supports only 2 nodes in SQL 2014 & earlier. Supports only 3 nodes in SQL 2016 & earlier.||DataKeeper replicates all changes automatically keeping all nodes up to date.|
|Added complexity – all changes and updates to the system databases have to be made on all nodes manually||DataKeeper gives you the flexibility to create a multinode cluster without a limit to the number of failover nodes.|
|Microsoft has only tested 100 databases and 10 Availability Groups – “results may vary depending on hardware”||One load balancer per AG in Azure are all addressed by 1 IP address.|
Learn more about SIOS DataKeeper in the cloud
Compare SQL Server Cluster Options for High Availability
For SQL Server clustering, a common choice of availability is Microsoft Always On Availability Groups and Always On Failover Clusters. SIOS DataKeeper provides a number of key benefits to achieve higher availability and more comprehensive data protection.
SIOS LifeKeeper for SQL Server High Availability in Windows or Linux
SIOS Protection Suite for Windows provides integrated data replication, high availability clustering and disaster recovery solutions to provide high availability protection for the most demanding enterprise SQL Server deployments.
SIOS LifeKeeper for Linux provides enterprise-class, application-aware HA/DR protection for SQL Server in all major distributions of Linux, including Red Hat, SUSE, and Oracle Linux.
Learn more about SIOS Protection Suite for Linux