k8s安装mysql

镜像：mysql:8.0.34

apiVersion: apps/v1
kind: Deployment
metadata:
  name: mysql
  labels:
    workload.user.cattle.io/workloadselector: apps.deployment-wfs-test-mysql
  namespace: wfs-test
  selector:
    matchLabels:
      workload.user.cattle.io/workloadselector: apps.deployment-wfs-test-mysql
    spec:
      containers:
        - env:
            - name: MYSQL_ROOT_PASSWORD
              valueFrom:
                secretKeyRef:
                  key: mysql-root-password
                  name: wfs-mysql-mysql-single
                  optional: false
            - name: MYSQL_PASSWORD
              valueFrom:
                secretKeyRef:
                  key: mysql-password
                  name: wfs-mysql-mysql-single
                  optional: false
            - name: MYSQL_USER
              value: xxxx
            - name: MYSQL_DATABASE
              value: xxxx
          image: harbor.goldwind.com/library/mysql:8.0.34
          imagePullPolicy: Always
          livenessProbe:
            exec:
              command:
                - sh
                - '-c'
                - exec mysqladmin status -uroot -p$MYSQL_ROOT_PASSWORD
            failureThreshold: 3
            initialDelaySeconds: 120
            periodSeconds: 10
            successThreshold: 1
            timeoutSeconds: 30
          name: mysql
          ports:
            - containerPort: 3306
              name: http3306
              protocol: TCP
              _listeningPort: xxxx
              _serviceType: NodePort
          readinessProbe:
            exec:
              command:
                - sh
                - '-c'
                - exec mysqladmin status -uroot -p$MYSQL_ROOT_PASSWORD
            failureThreshold: 3
            initialDelaySeconds: 60
            periodSeconds: 10
            successThreshold: 1
            timeoutSeconds: 30
          resources:
            limits:
              cpu: '2'
              memory: 6Gi
            requests:
              cpu: 500m
              memory: 1Gi
          terminationMessagePath: /dev/termination-log
          terminationMessagePolicy: File
          volumeMounts:
            - mountPath: /var/lib/mysql
              name: vol-dyrz2
            - mountPath: /etc/mysql/conf.d/my.cnf
              name: vol-ofgpb
              subPath: my.cnf
      dnsPolicy: ClusterFirst
      nodeName: kubernetes-dev-worker-1
      restartPolicy: Always
      schedulerName: default-scheduler
      serviceAccount: default
      serviceAccountName: default
      terminationGracePeriodSeconds: 30
      volumes:
        - configMap:
            defaultMode: 420
            name: xx-mysql-cnf
          name: vol-ofgpb
        - name: vol-dyrz2
          persistentVolumeClaim:
            claimName: mysql-data-pvc
          __newPvc:
            type: persistentvolumeclaim
            metadata:
              namespace: wfs-test
            spec:
              storageClassName: ''
              volumeName: ''
              resources:
                requests: {}
  progressDeadlineSeconds: 600
  replicas: 1
  revisionHistoryLimit: 10
  strategy:
    rollingUpdate:
      maxSurge: 25%
      maxUnavailable: 25%
    type: RollingUpdate

配置文件：

其中日志文件是上层目录需要是真实存在的

my.cnf
[mysqld]

basedir=/var/lib/mysql

port=3306

socket=/var/run/mysqld/mysqld.sock

pid-file=/var/run/mysqld/mysqld.pid

max_allowed_packet=1G

character-set-server=UTF8

collation-server=utf8_general_ci

default-time-zone=timezone

default-time_zone='+8:00'

general_log=1

general_log_file=/var/lib/mysql/mysqld.log

log_error=/var/lib/mysql/mysqld.err

slow_query_log=1

long_query_time=10.0

slow_query_log_file=/var/lib/mysql/mysqld-slow.log

[client]

port=3306

socket=/var/run/mysqld/mysqld.sock

default-character-set=UTF8

[manager]

port=3306

socket=/var/run/mysqld/mysqld.sock

pid-file=/var/run/mysqld/mysqld.pid