Home > Storage > PowerFlex > White Papers > Dell APEX Block Storage for AWS: Microsoft SQL Server 2022 on Linux with Multi-AZ Resiliency > Microsoft SQL Server 2022 on Linux with Multi-AZ resiliency
Microsoft SQL Server 2022 on Linux includes the same scalability features as its Windows equivalent, allowing enterprises to efficiently scale their database infrastructure to meet growing demands. Running SQL Server on Linux-based machines allows enterprises to harness the capabilities of both platforms, resulting in a robust and versatile database solution.
Pacemaker for high availability with SQL Server on Linux provides a strong and adaptable solution for ensuring continuous availability, scalability, and dependability of your database infrastructure. By combining the features of Pacemaker and SQL Server, you can create a durable HA environment that can handle your organization's important workloads.
A multi-subnet failover cluster is a highly available solution that enables SQL Server on Linux to failover over various subnets. This functionality provides improved availability and disaster recovery capabilities for Linux SQL Server deployments and is especially relevant when the APEX Block Storage cluster is configured across multiple-AZs, each one with its own subnet
In a multi-subnet failover cluster with APEX Block Storage multi-AZ configuration with Linux SQL Server nodes, if an active node fails or disconnects, the pacemaker will immediately transfer resources to passive nodes. Whereas Dell APEX Block Storage protects against data loss in case one of the AZs becomes unavailable by mapping fault sets between them.
A simpler configuration can be deployed for APEX Block Storage, such as using a single AZ instead of multiple, and for SQL Server, such as using non-clustered SQL Server configuration, but still harnessing the resilience of APEX Block Storage.
APEX Block Storage deployment in AWS is set as a two-layer design, in which compute, and storage instances are distinct. The two-layer design enables Amazon EC2 instances that are compute oriented for databases and application workloads to be configured and scaled separately from Amazon EC2 instances that are optimized for storage, providing customers with more flexibility.