Custom Resources
The operator exposes five custom resources under the API group
mssql.solanica.io/v1alpha1. Two describe deployments, three drive
backup and restore.
Deployment resources
| Kind | Purpose |
|---|---|
MSSQLInstance | One or more independent, standalone SQL Server instances (no replication). |
MSSQLAvailabilityGroup | An Always-On Availability Group across replicas (size >= 2) with automatic failover. |
Both share a common spec (image, edition, storage, TLS, exposure, resources,
scheduling). MSSQLAvailabilityGroup adds an availabilityGroup section and
requires at least two replicas. See the CR Reference for
every field.
apiVersion: mssql.solanica.io/v1alpha1
kind: MSSQLInstance
metadata:
name: my-mssql
spec:
size: 1
acceptEULA: true
saPasswordSecret: my-mssql-secret
storage:
size: 8Gi
Backup & restore resources
| Kind | Purpose |
|---|---|
MSSQLBackup | A one-shot backup (full / differential / log) to S3-compatible storage. |
MSSQLBackupSchedule | A recurring backup policy (cron) with retention and point-in-time-recovery cadence. |
MSSQLRestore | A one-shot restore from a backup chain, including point-in-time recovery. |
Backup destinations are declared on the deployment resource under
spec.backup.targets; the backup/schedule/restore resources then reference them.
See Backups & Restores for the full workflow.
How they relate
Where to next
- CR Reference — full spec for every field.
- Availability Groups — HA configuration.
- Backups & Restores — S3 backup and PITR.