Topologies
A topology is the deployment shape of your SQL Server database. The MSSQL Provider offers two, each of which maps to a different MSSQL Operator resource.
| Topology | Maps to | Replicas | Use case |
|---|---|---|---|
| Standalone | MSSQLInstance | 1 | Development, single-server workloads |
| Availability Group | MSSQLAvailabilityGroup | 2+ (3 recommended) | Production high availability with automatic failover |
Choose the topology with spec.topology.type on the Instance:
spec:
topology:
type: standalone # or: availabilityGroup
Some topologies accept extra settings under spec.topology.parameters — see the
individual topology pages for details.
Choosing a topology
- Pick standalone for development, test, and workloads that can tolerate the restart window of a single pod.
- Pick availabilityGroup for production databases that need high availability, automatic failover, and optional readable secondaries.