kind: ConfigMap
apiVersion: v1
metadata:
  name: mysql-define-config
  namespace: mid
  annotations: {}
data:
  my.cnf: |-
    [mysqld]
    #skip-grant-tables
    lower_case_table_names = 1
    lock_wait_timeout = 3600
    open_files_limit    = 65535
    back_log = 1024
    max_connections = 512
    max_connect_errors = 1000000
    table_open_cache = 1024
    table_definition_cache = 1024
    thread_stack = 512K
    sort_buffer_size = 4M
    join_buffer_size = 4M
    read_buffer_size = 8M
    read_rnd_buffer_size = 4M
    bulk_insert_buffer_size = 64M
    thread_cache_size = 768
    interactive_timeout = 600
    wait_timeout = 600
    tmp_table_size = 32M
    max_heap_table_size = 32M
---
kind: StatefulSet
apiVersion: apps/v1
metadata:
  name: mysql-define
  namespace: mid
  labels:
    app: mysql-define
spec:
  replicas: 1
  selector:
    matchLabels:
      app: mysql-define
  template:
    metadata:
      labels:
        app: mysql-define
    spec:
      containers:
        - name: mysql-define
          #image: 'mysql:5.7.38'
          image: harbor.uenpay.com/base/mysql:5.7.38
          ports:
            - name: tcp-mysql
              containerPort: 3306
              protocol: TCP
          env:
            - name: TZ
              value: Asia/Shanghai
            - name: MYSQL_ROOT_PASSWORD
              value: Blala008!
            - name: MYSQL_DATABASE
              value: xxl-job
          resources:
            limits:
              cpu: '2'
              memory: 4096Mi
            requests:
              cpu: 500m
              memory: 1024Mi
          volumeMounts:
            - name: data
              mountPath: /var/lib/mysql
  volumeClaimTemplates:
    - metadata:
        name: data
        annotations:
          volume.beta.kubernetes.io/storage-class: "cephfs-sc"
      spec:
        accessModes: [ "ReadWriteOnce" ]
        resources:
          requests:
            storage: 30Gi
---
kind: Service
apiVersion: v1
metadata:
  name: mysql-define-nodeport
  namespace: mid
  labels:
    app: mysql-define-nodeport
spec:
  selector:
    app: mysql-define
  type: NodePort
  ports:
    - name: tcp-nodeport
      protocol: TCP
      port: 3306
      targetPort: 3306
      nodePort: 30306