SQL Server vNext version Community Technology Preview 1.3 now available on both Windows and Linux. There added several feature enhancements to High Availability and Disaster Recovery (HADR), including the ability to run Always On Availability Groups on Linux.
Key CTP 1.3 enhancement: Always On Availability Groups on Linux
A key design principle has been to provide customers with the same HA and DR solutions on all platforms supported by SQL Server. On Windows, Always On depends on Windows Server Failover Clustering (WSFC). On Linux, you can now create Always On Availability Groups, which integrate with Linux-based cluster resource managers to enable automatic monitoring, failure detection and automatic failover during unplanned outages.
In addition, Availability Groups can now work across Windows and Linux as part of the same Distributed Availability Group. This configuration can accomplish cross-platform migrations without downtime.
SQL Server v.Next CTP 1.3 also includes these additional feature enhancements:
- Full text search is now available for all supported Linux distributions.
- Resumable online index rebuilds enables users to recover more easily from interruption of index builds, or split an index build across maintenance windows.
- Temporal Tables Retention Policy support enables customers to more easily manage the amount of historical data retained by temporal tables.
- Indirect checkpoint performance improvements. Indirect checkpoint is the recommended configuration for large databases and for SQL Server 2016, and now it will be even more performant in SQL Server v.Next.
- Minimum Replica Commit Availability Groups setting enables users to set the minimum number of replicas that are required to commit a transaction before committing on the primary.
- For SQL Server v.Next technical preview running on Windows Server, encoding hints in SQL Server Analysis Services is an advanced feature to help optimize refresh times with no impact on query performance.