---
apiVersion: apps/v1
kind: Deployment
metadata:
  labels:
    app: mariadb
  name: mariadb
spec:
  replicas: 1
  selector:
    matchLabels:
      app: mariadb
  strategy:
    type: Recreate
  template:
    metadata:
      annotations:
        traefik.enable: "false"
      labels:
        app: mariadb
    spec:
      containers:
        - env:
            - name: MYSQL_PASSWORD
              valueFrom:
                configMapKeyRef:
                  key: MYSQL_PASSWORD
                  name: mariadb-secrets-env
            - name: MYSQL_ROOT_PASSWORD
              valueFrom:
                configMapKeyRef:
                  key: MYSQL_ROOT_PASSWORD
                  name: mariadb-secrets-env
            - name: MYSQL_USER
              valueFrom:
                configMapKeyRef:
                  key: MYSQL_USER
                  name: mariadb-secrets-env
          image: linuxserver/mariadb:latest
          name: mariadb
          ports:
            - containerPort: 3306
              protocol: TCP
          volumeMounts:
            - mountPath: /config
              name: mariadb-data-volume
            - mountPath: /config/conf
              name: mariadb-config-volume
      volumes:
        - name: mariadb-config-volume
          persistentVolumeClaim:
            claimName: mariadb-config-pvc
        - name: mariadb-data-volume
          persistentVolumeClaim:
            claimName: mariadb-data-pvc
      restartPolicy: Always
---      
apiVersion: v1
kind: Service
metadata:
  annotations:
    traefik.enable: "false"
  name: mariadb-svc
spec:
  ports:
    - name: "3306"
      port: 3306
      targetPort: 3306
      nodePort: 31306
  type: NodePort 
  selector:
    app: mariadb
---    
apiVersion: v1
kind: PersistentVolume
metadata:
  name: mariadb-data-pv
spec:
  capacity:
    storage: 100Gi
  accessModes:
    - ReadWriteOnce
  persistentVolumeReclaimPolicy: Retain
  storageClassName: ""
  nfs:
    path: /mnt/raid/00_meta/02_services/mariadb
    server: 192.168.1.146
---
apiVersion: v1
kind: PersistentVolumeClaim
metadata:
  name: mariadb-data-pvc 
spec:
  accessModes:
    - ReadWriteOnce
  resources:
    requests:
      storage: 100Gi
  volumeName: mariadb-data-pv 
  storageClassName: ""
---
apiVersion: v1
kind: PersistentVolume
metadata:
  name: mariadb-config-pv
spec:
  capacity:
    storage: 100Gi
  accessModes:
    - ReadWriteOnce
  persistentVolumeReclaimPolicy: Retain
  storageClassName: ""
  nfs:
    path: /mnt/raid/00_meta/05_service_config/mariadb/conf
    server: 192.168.1.146
---
apiVersion: v1
kind: PersistentVolumeClaim
metadata:
  name: mariadb-config-pvc 
spec:
  accessModes:
    - ReadWriteOnce
  resources:
    requests:
      storage: 100Gi
  volumeName: mariadb-config-pv 
  storageClassName: ""