SQL Server for Linux

Version 2019, 2022

With ClusterControl, you can ensure a hybrid database technology model, not only implementing local and cloud-based database platforms but also mixing open source with SQL Server so that your .Net platforms and applications are integrated and controlled by ClusterControl’s single pane of glass.

Tech highlights

Distributions

  • SQL Server for Linux
  • Operating system provided repository

Replication types

  • Always On
  • Asynchronous-commit

Top features

  • Hybrid HA
  • Flexible architecture
  • Cloud backups

SQL Server for Linux + ClusterControl + AlwaysOn high availability

ClusterControl allows you to control all your databases. So, once you’ve deployed the SQL Server AlwaysOn cluster on Linux, you can add and remove nodes as well as rebuild the replica of a failed replica, all from one console.

Try ClusterControl with SQL Server for Linux for yourself!

Features list

OSS Licenseicon checkmark
Enterprise Licenseicon checkmark
Severalnines Supporticon checkmark
Relationalicon checkmark
NoSQL
Storage Engines
Time series
Backup & Restoreicon checkmark
— Fullicon checkmark
— Incremental
— Partial
— Restore: PITR
— Clone / Duplicate nodeicon checkmark
— Local storageicon checkmark
— Cloud storageicon checkmark
— Encryption
— Compressionicon checkmark
Cluster creationicon checkmark
— Asynchronous Replicationicon checkmark
— Synchronous Replication
— Add node / decommissionicon checkmark
SSL/TLS Connectivityicon checkmark
Load Balancer availability
Infrastructure manageabilityicon checkmark
Security summary
— User console accessicon checkmark
— Key Managementicon checkmark
— LDAP integrationicon checkmark
— Audit logicon checkmark
Performance analysis
— Query monitoringicon checkmark
— Operations monitoringicon checkmark
— Custom metrics/thresholdsicon checkmark
— Replication lag
Configuration Managementicon checkmark
Database-specific dashboard
Alarms & Error reportingicon checkmark

Top rated Docs

Nodes docs

Backups docs

Import a Database Cluster

Top rated Blogs

Failover Modes for SQL Server cluster on Linux

7 Best Practices for SQL Server Security

Types of Replication in SQL Server on Linux

FAQ

I’ve deployed SQL Server on Windows before but never on Linux. What do I need to know prior to using ClusterControl?

As with all our database deployments: Nothing. Welcome to simplified database installations that just quite honestly take the pain away.

Do you allow SQL Server deployments on Windows?

We’re studying the possibility, but for now, it’s only for Linux.

In addition to providing statistics on SQL Server and its performance, what about the underlying systems?

Of course, on the main dashboard, you can view both the system, cluster, and per-node SQL Server host dashboard.