SQL Server Availability Group on Kubernetes (DxSqlAg) Guides
The DxSqlAg custom resource is the Kubernetes source of truth for a single SQL Server Availability Group (AG) managed by DxOperator and DxEnterprise. Creating one DxSqlAg tells the operator to create — and continuously reconcile — the AG and its required Kubernetes resources.
At a glance, a DxSqlAg:
- Defines one AG (one custom resource per AG).
- Spins up DxEnterprise + SQL Server pods using Kubernetes primitives (e.g., StatefulSets and Services).
- Adds replicas into an AG through DxEnterprise and keeps the cluster running.
- Applies declarative changes: when you edit the spec, the operator reconciles the running cluster to match.
- Optionally manages services through service templates.
This section contains guides for declaring, deploying, and operating a SQL Server Availability Group on Kubernetes using the DxSqlAg custom resource.
🗃️ Create
3 items
📄️ Use SSMS and DxAdmin to View the Cluster
How to connect to and view SQL Server and DxEnterprise using SSMS and DxAdmin, respectively
📄️ Create a SQL Server AG Listener
You can create a SQL Server Availability Group listener by modifying the DxSqlAg custom resource
📄️ Join a DxSqlAg Cluster to an Existing DxEnterprise Cluster
Join a DxSqlAg to an existing DxEnterprise cluster running almost anywhere
📄️ Configure Per-pod Services using Service Templates
The DxSqlAg custom resource uses service templates to create per-pod services that scale automatically with replicas
📄️ Configure topology spreading of DxSqlAg pods
Configure topology spreading of DxSqlAg pods
📄️ Configure SQL Server's Listening Port
Learn how to configure a SQL Server AG in Kubernetes (DxSqlAg) to listen on a specific TCP port