VMware Cloud on AWS supports multiple availability options for SQL Server workloads, either platform or SQL Server specific.
Platform based options are the following:
- vSphere High Availability (HA) – turned on by default on all clusters in a SDDC on VMware Cloud on AWS.
- Multi-AZ deployment (Stretched Cluster) – provides resiliency for an AZ failure if selected
SQL Server options are:
- Always On Availability Groups (AGs) – provides resilency on the database level. Fully supported without restrictions for all types of AGs deployments and availability modes. Does not require a shared storage between VMs.
- Always On Failover Cluster Instances – provides resilency on the instance level, require shared storage. Supported for 2/4/8 nodes deployments with up to 64 clustered disk resources. Require setting the SCSI Bus Sharing for a vSCSI controller to Physical. More details can be found in this article and in the dedicated section in this document.
The platform-based and SQL Server native options can be combined to achieve the availability requirements of your SQL Server workloads