mssql.yaml

---
apiVersion: v1
kind: Secret
metadata:
  name: mssql-5-secret
  labels:
    app.kubernetes.io/name: mssql-5
type: Opaque
data:
  sa_password: "VG91Z2hwYXNzMSE="
---
kind: ConfigMap
apiVersion: v1
metadata:
  name: mssql-5-config
data:
  mssql.conf: |
    [EULA]
    accepteula = Y
    accepteulaml = Y

    [coredump]
    captureminiandfull = true
    coredumptype = full

    [hadr]
    hadrenabled = 1

    [language]
    lcid = 1033

    [filelocation]
    defaultdatadir = /var/opt/mssql/userdata
    defaultlogdir = /var/opt/mssql/userlog
---
kind: PersistentVolumeClaim
apiVersion: v1
metadata:
  name: mssql-5-data
  annotations:
    volume.beta.kubernetes.io/storage-class: "longhorn-no-replicas"
spec:
  accessModes:
    - "ReadWriteOnce"
  resources:
    requests:
      storage: 30Gi
---
apiVersion: v1
kind: Service
metadata:
  name: mssql-5-service
  labels:
    app.kubernetes.io/name: mssql-5
spec:
  type: LoadBalancer
  ports:
    - port: 1433
      targetPort: 1433
      protocol: TCP
  selector:
    app.kubernetes.io/name: mssql-5
---
apiVersion: apps/v1
kind: Deployment
metadata:
  name: mssql-5
  labels:
    app.kubernetes.io/name: mssql-5
spec:
  replicas: 1
  selector:
    matchLabels:
      app.kubernetes.io/name: mssql-5
  template:
    metadata:
      labels:
        app.kubernetes.io/name: mssql-5
    spec:
      hostname: mssqllatest
      securityContext:
        fsGroup: 10001
      containers:
        - name: mssql-latest
          command:
            - /bin/bash
            - -c
            - cp /var/opt/config/mssql.conf /var/opt/mssql/mssql.conf && /opt/mssql/bin/sqlservr
          image: "mcr.microsoft.com/mssql/rhel/server:2019-latest"
          imagePullPolicy: IfNotPresent
          ports:
            - containerPort: 1433
          env:
            - name: MSSQL_PID
              value: "Developer"
            - name: ACCEPT_EULA
              value: "Y"
            - name: MSSQL_AGENT_ENABLED
              value: "true"
            - name: SA_PASSWORD
              valueFrom:
                secretKeyRef:
                  name: mssql-5-secret
                  key: sa_password
          volumeMounts:
            - name: mssqldb-5
              mountPath: /var/opt/mssql
            - name: mssql-5-config-volume
              mountPath: /var/opt/config
      volumes:
        - name: mssqldb-5
          persistentVolumeClaim:
            claimName: mssql-5-data
        - name: mssql-5-config-volume
          configMap:
            name: mssql-5-config