*          soft    nproc     unlimited

root       soft    nproc     unlimited

# End of file

*    soft    core

*    hard    core

*    soft    nofile

*    hard    nofile        

[root@harbor mysql5.7.20]# cat  senyint.cnf

[mysqld]

server-id =

port =

user = mysql

autocommit =

character_set_server=utf8mb4

skip_name_resolve =

max_connections =

max_connect_errors =

transaction_isolation = READ-COMMITTED

join_buffer_size = 128M

tmp_table_size = 64M

tmpdir = /tmp

max_allowed_packet = 64M

interactive_timeout =

wait_timeout =

read_buffer_size = 16M

read_rnd_buffer_size = 8M

sort_buffer_size = 8M

explicit_defaults_for_timestamp=true

[root@harbor mysql5.7.20]# cat Dockerfile

FROM docker.io/mysql:5.7.

MAINTAINER fengjian <fengjian@senyint.com>

ENV TZ "Asia/Shanghai"

ENV TERM xterm

ENV MALLOC_ARENA_MAX=

ADD localtime  /etc/

ADD -nproc.conf /etc/security/limits.d/

ADD limits.conf /etc/security/

ADD senyint.cnf /etc/mysql/mysql.conf.d/

ADD senyint.cnf /etc/mysql/conf.d/

#RUN rm /var/lib/mysql/lost+found -rf

[root@master1 mysql]# cat mysql-secret.yaml

apiVersion: v1

kind: Secret

metadata:

  name: mysql-secrets

  namespace: prodpay

#type: Opaque

data:

  root-password: QWJjZCwxMj222M0

[root@master1 mysql]# cat mysql_pvc.yaml

kind: PersistentVolumeClaim

apiVersion: v1

metadata:

  namespace: prodpay

  name: mysql-pvc

spec:

  storageClassName: ceph-rbd-dalianpay

  accessModes:

    - ReadWriteOnce

  resources:

    requests:

      storage: 100Gi

[root@master1 mysql]# cat mysql.yaml

apiVersion: apps/v1beta2

kind: Deployment

metadata:

  name: mysql

  namespace: prodpay

spec:

  selector:

    matchLabels:

      app: mysql

  replicas:

  template:

    metadata:

      labels:

        app: mysql

    spec:

      containers:

      - image: 192.168.200.10/source/mysql:5.7.

        imagePullPolicy: Always

        name: mysql

        #command: ["rm","-rf","/var/lib/mysql/lost+found"]

        ports:

        - containerPort:

        resources:

          requests:

            cpu:

            memory: 4Gi

          limits:

            cpu:

            memory: 8Gi

        env:

          - name: MYSQL_ROOT_PASSWORD

            valueFrom:

              secretKeyRef:

                name: mysql-secrets

                key: root-password

        volumeMounts:

        - mountPath: /var/lib/mysql

          subPath: mysql   #如果不加subpath，那么就会报[ERROR] --initialize specified but the data directory has files in it. Aborting.目录不为空，使用subpath基础表信息会记录在/var/lib/mysql/mysql下

          name: data

      volumes:

      - name: data

        persistentVolumeClaim:

          claimName: mysql-pvc

---

apiVersion: v1

kind: Service

metadata:

  name: mysql

  namespace: prodpay

spec:

  ports:

  - name: mqsql

    port:

    targetPort:

  selector:

    app: mysq