apiVersion: apps/v1
kind: Deployment
metadata:
  name: mysql-apacp
  namespace: cloud
  labels:
    name: mysql-apacp
  annotations:
    deployment.kubernetes.io/revision: "5"
spec:
  progressDeadlineSeconds: 600
  replicas: 1
  revisionHistoryLimit: 7
  selector:
    matchLabels:
      app: mysql-apacp
  strategy:
    rollingUpdate:
      maxSurge: 1
      maxUnavailable: 0
    type: RollingUpdate
  template:
    metadata:
      annotations: {}
      labels:
        app: mysql-apacp
    spec:
      nodeSelector:
        apacp: "1"
      containers:
      - env:
        - name: TZ
          value: Asia/Shanghai
        - name: MYSQL_ROOT_PASSWORD
          value: aispeech
        image: mysql:5.7.29
        imagePullPolicy: IfNotPresent
        args:
        - --default-authentication-plugin=mysql_native_password
        - --character-set-server=utf8mb4
        - --collation-server=utf8mb4_general_ci
        - --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
        name: mysql-apacp
        ports:
        - containerPort: 3306
        volumeMounts:
        - name: mysqldata
          mountPath: /var/lib/mysql
      terminationGracePeriodSeconds: 60
      volumes:
      - name: mysqldata
        hostPath:
          path: "/data/mnt/nas_storage/mysql-aispeech"
---
apiVersion: v1
kind: Service
metadata:
  name: mysql-apacp
  namespace: cloud
spec:
  type: NodePort
  ports:
  - protocol: TCP
    port: 3306
    targetPort: 3306
  selector:
    app: mysql-apacp