kind: StatefulSet
apiVersion: apps/v1
metadata:
  name: mysql-confluence
  namespace: kube-public
  labels:
    name: mysql-confluence
spec:
  replicas: 1
  selector:
    matchLabels:
      name: mysql-confluence
  template:
    metadata:
      creationTimestamp: null
      labels:
        name: mysql-confluence
    spec:
      containers:
        - name: mysql-confluence
          image: 'registry.cn-hangzhou.aliyuncs.com/zhengyu1992/nacos-mysql:5.7'
          args: [
            "--default-authentication-plugin=mysql_native_password",
            "--character-set-server=utf8",
            "--collation-server=utf8bin",
            "--explicit_defaults_for_timestamp=true",
            "--lower_case_table_names=1",
            "--skip-ssl",
            "--max_allowed_packet=128M",
            "--innodb_log_file_size=256M",
            "--transaction-isolation=READ-COMMITTED"
          ]
          ports:
            - containerPort: 3306
              protocol: TCP
          env:
            - name: TZ
              value: Asia/Shanghai
            - name: MYSQL_ROOT_PASSWORD
              value: pass4Confluence
            - name: MYSQL_DATABASE
              value: confluence
            - name: MYSQL_USER
              value: confluence
            - name: MYSQL_PASSWORD
              value: Blala007!
          resources:
            limits:
              cpu: 1
              memory: 2Gi
            requests:
              cpu: 200m
              memory: 500Mi
          volumeMounts:
            - name: data
              mountPath: /var/lib/mysql
          imagePullPolicy: IfNotPresent
      restartPolicy: Always
      terminationGracePeriodSeconds: 30
  volumeClaimTemplates:
    - kind: PersistentVolumeClaim
      apiVersion: v1
      metadata:
        name: data
        annotations:
          volume.beta.kubernetes.io/storage-class: "cephfs-sc"
      spec:
        accessModes:
          - ReadWriteOnce
        resources:
          requests:
            storage: 20Gi
        volumeMode: Filesystem
  serviceName: mysql-confluence
---
kind: Service
apiVersion: v1
metadata:
  name: mysql-confluence
  namespace: kube-public
  labels:
    name: mysql-confluence
spec:
  ports:
    - protocol: TCP
      port: 3306
      targetPort: 3306
  selector:
    name: mysql-confluence