ghost-db.yaml

#@ load("@ytt:base64", "base64")
#@ load("@ytt:data", "data")
---
apiVersion: v1
kind: Secret
metadata:
  name: ghost-db
  namespace: ghost
data:
  password: #@ base64.encode(data.values.ghostdb.password.strip())
---
apiVersion: apps/v1
kind: StatefulSet
metadata:
  name: ghost-db
  namespace: ghost
spec:
  replicas: 1
  serviceName: ghost-db
  selector:
    matchLabels:
      app: ghost-db
  template:
    metadata:
      labels:
        app: ghost-db
    spec:
      containers:
      - name: mysql
        image: mysql:8.0
        ports:
        - name: mysql
          protocol: TCP
          containerPort: 3306
        env:
        - name: MYSQL_ROOT_PASSWORD
          valueFrom: 
            secretKeyRef: 
              name: ghost-db
              key: password
        volumeMounts:
        - name: data
          mountPath: /var/lib/mysql
  volumeClaimTemplates:
  - metadata:
      name: data
    spec:
      accessModes:
      - ReadWriteOnce
      resources:
        requests:
          storage: 10Gi
---
apiVersion: v1
kind: Service
metadata:
  name: ghost-db
  namespace: ghost
  labels:
    app: ghost-db
spec:
  type: ClusterIP
  selector:
    app: ghost-db
  ports:
  - protocol: TCP
    port: 3306
    targetPort: 3306