SQL Server on Linux: High availability and security

With SQL Server on Linux, Microsoft brings SQL Server’s core relational database engine to the growing enterprise Linux ecosystem. Both High Availability and Disaster Recovery (HADR) and security are aspects of SQL Server that are critically important for enterprises. This article highlights the HADR and security solutions for SQL Server on Linux that are available today, as well as the roadmap for what’s coming soon.

HADR landscape

SQL Server offers solutions for various HADR scenarios and it comes with a set of features and capabilities that can help organizations achieve a wide range of availability SLAs goals. From Simple HADR solutions like VM failover with durable storage, to shared disk failover clustering and log shipping (Standard DR) or Always On Availability Groups for mission-critical workloads, these solutions offer different Recovery Point Objective (RPO*), Recovery Time Objective (RTO**), failover and workload load balancing capabilities, enabling customers to choose the optimal solution depending on their business needs:

SQL Server Linux HADR Solutions


*RPO – the maximum time frame your organization is willing to lose data for, in the event of an outage
*RTO – the maximum downtime that your organization can endure in the event of an outage

For SQL Server running on Linux, our goal is to preserve the capabilities framed in the diagram above. We are starting to enable support for some of these solutions starting with the SQL Server v.Next Community Technology Preview (CTP) 1 release.

In Windows, SQL Server relies upon Windows Server Failover Clustering to provide the infrastructure features supporting the HADR scenarios. Similarly, on Linux platforms, SQL Server is natively integrated with popular clustering solutions like Pacemaker, so it can benefit from the health monitoring, failure detection or failover coordination of the clustering layer. Please visit our reference documentation on business continuity for SQL Server on Linux for more details about supported platforms and clustering solutions and end-to-end functional samples.

Security solutions

According to the National Institute of Standards and Technology (NIST) public security board, SQL Server has the lowest number of reported security vulnerabilities across the major database vendors (NIST, February 2016). With SQL Server 2016, security was further enhanced by additional security features such as Always Encrypted, Row-Level Security and Dynamic Data Masking.

SQL Server on Linux will support the same advanced, security functionality that enterprises depend on to protect,  control, and monitor access to their data. These capabilities are all built- in:

SQL Server on Linux Security

This layered approach to data security, in addition to Microsoft’s overall commitment to advancing security and privacy protection, enables enterprises to secure their data and achieve regulatory compliance more easily than ever before.

You can find out more about these enterprise-grade security capabilities as well as HADR solutions planned for SQL Server on Linux by watching the video above. The clip also includes a demo on how to register a SQL Server instance to be part of a Linux cluster setup using Pacemaker, as well as a demo on how to migrate an encrypted database from Windows to an instance of SQL Server running on Linux.

Get started

You can get started with many of these capabilities today:

Learn more

Stay tuned for additional SQL Server Blog posts in the coming weeks, including connectors, and developer tools on Linux!