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.

SQL Server

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 Licensecheck
Enterprise Licensecheck
Severalnines Supportcheck
Relationalcheck
NoSQL
Storage Engines
Time series
Backup & Restorecheck
— Fullcheck
— Incremental
— Partial
— Restore: PITR
— Clone / Duplicate nodecheck
— Local storagecheck
— Cloud storagecheck
— Encryption
— Compressioncheck
Cluster creationcheck
— Asynchronous Replicationcheck
— Synchronous Replication
— Add node / decommissioncheck
SSL/TLS Connectivitycheck
Load Balancer availability
Infrastructure manageabilitycheck
Security summary
— User console accesscheck
— Key Managementcheck
— LDAP integrationcheck
— Audit logcheck
Performance analysis
— Query monitoringcheck
— Operations monitoringcheck
— Custom metrics/thresholdscheck
— Replication lag
Configuration Managementcheck
Database-specific dashboard
Alarms & Error reportingcheck

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

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.

6 easy steps to get started with ClusterControl