mssql数据库搭建

Mssql 是微软的数据库，它的安装和使用都比较简单，但是在安装的时候需要注意一些问题，否则会出现一些问题。

Kubernetes 部署

kind: PersistentVolumeClaim
apiVersion: v1
metadata:
  name: mssql
  namespace: stable-db
spec:
  accessModes:
    - ReadWriteOnce
  resources:
    requests:
      storage: 50Gi
  storageClassName: standard-rwo
---
kind: StatefulSet
apiVersion: apps/v1
metadata:
  name: mssql
  namespace: stable-db
  labels:
    app: mssql
spec:
  replicas: 1
  selector:
    matchLabels:
      app: mssql
  template:
    metadata:
      labels:
        app: mssql
    spec:
      volumes:
        - name: mssql
          persistentVolumeClaim:
            claimName: mssql
      containers:
        - name: mssql
          image: mcr.microsoft.com/mssql/server:2017-latest-ubuntu
          ports:
            - name: tcp-0
              containerPort: 1433
              protocol: TCP
          env:
            - name: ACCEPT_EULA
              value: 'Y'
            - name: MSSQL_SA_PASSWORD
              value: <password>
            - name: MSSQL_PID
              value: Standard
          resources:
            limits:
              cpu: "1"
              memory: 2Gi
            requests:
              cpu: "1"
              memory: 2Gi
          livenessProbe:
            exec:
              command:
                - /bin/bash
                - -c
                - /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P Gotapd8! -Q "select 1"
            initialDelaySeconds: 30
            periodSeconds: 10
            timeoutSeconds: 5
          readinessProbe:
            exec:
              command:
                - /bin/bash
                - -c
                - /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P Gotapd8! -Q "select 1"
            initialDelaySeconds: 30
            periodSeconds: 10
            timeoutSeconds: 5
          startupProbe:
            exec:
              command:
                - /bin/bash
                - -c
                - /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P Gotapd8! -Q "select 1"
            initialDelaySeconds: 30
            periodSeconds: 10
            timeoutSeconds: 5
          terminationMessagePath: /dev/termination-log
          terminationMessagePolicy: File
          imagePullPolicy: IfNotPresent
          volumeMounts:
            - name: mssql
              mountPath: /var/opt/mssql
      terminationGracePeriodSeconds: 30

docker-compose部署

version: '3'
services:
  mssql:
    image: mcr.microsoft.com/mssql/server:2017-latest-ubuntu
    container_name: mssql
    restart: always
    environment:
      - ACCEPT_EULA=Y
      - MSSQL_SA_PASSWORD=<password>
      - MSSQL_PID=Standard
    ports:
      - "1433:1433"
    volumes:
      - /data/mssql:/var/opt/mssql