Overview
The Solanica MSSQL Operator is a Kubernetes operator for running Microsoft
Installation
The MSSQL Operator is distributed as a Helm chart from the Solanica OCI
Custom Resources
The operator exposes five custom resources under the API group
CR Reference
The operator exposes two deployment CRDs that share a common spec:
Connecting
This guide covers how to retrieve credentials and connect to a SQL Server cluster managed by the operator, whether from outside the cluster, from within Kubernetes, or via a LoadBalancer.
SA Password
The operator reads the SA password from the Secret named in
Availability Groups
The operator configures a SQL Server Always-On Availability Group (AG) across all
Backups & Restores
The operator backs up and restores SQL Server databases to S3-compatible object
Pausing & Resuming
spec.paused lets you stop a MSSQLInstance or MSSQLAvailabilityGroup
Storage
Single PVC (default)
TLS
TLS client connection encryption is enabled by default for all MSSQLInstance and MSSQLAvailabilityGroup resources.
Monitoring
The MSSQL operator provides built-in Prometheus monitoring for SQL Server instances
Scheduling
Scheduling is the process Kubernetes uses to decide which node a pod runs on.
Version, Edition & Topology Changes
The operator supports in-place changes that preserve data on the existing
Release Notes
Version history for the MSSQL Operator, newest first. Versions follow the chart