k8s 创建单节点 mysql 并持久化存储

配置示例

  1. 创建 pvc
1
2
3
4
5
6
7
8
9
10
11
12
apiVersion: v1
kind: PersistentVolumeClaim
metadata:
  name: mysql-data
  namespace: dev
spec:
  accessModes:
    - ReadWriteMany
  storageClassName: csi-cephfs-sc-retain
  resources:
    requests:
      storage: 50Gi
  1. mysql 的一些资源配置
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
apiVersion: v1
kind: ConfigMap
metadata:
  name: mysql-config
  namespace: dev
data:
  rootPwd: "d72a3dpe"
  config.cnf: ""

---
# deployment.yaml
apiVersion: apps/v1
kind: Deployment
metadata:
  name: mysql
  namespace: dev
spec:
  replicas: 1
  selector:
    matchLabels:
      app: mysql
  template:
    metadata:
      labels:
        app: mysql
    spec:
      containers:
        - name: mysql
          image: mysql:8.1.0
          imagePullPolicy: IfNotPresent
          args:
            - --character-set-server=utf8mb4
            - --collation-server=utf8mb4_unicode_ci
          ports:
            - containerPort: 3306
            - containerPort: 33060
          env:
            - name: MYSQL_ROOT_PASSWORD
              valueFrom:
                configMapKeyRef:
                  name: mysql-config
                  key: rootPwd
          volumeMounts:
            - name: config-dir
              mountPath: /etc/mysql/conf.d
              readOnly: true
            - name: data-dir
              mountPath: /var/lib/mysql
      volumes:
        - name: config-dir
          configMap:
            name: mysql-config
            items:
              # name 是对应 secret 中的 key, path 是挂载 secret 后的子文件路径
              - key: config.cnf
                path: config.cnf
        - name: data-dir
          persistentVolumeClaim:
            claimName: mysql-data
---
apiVersion: v1
kind: Service
metadata:
  name: mysql
  namespace: dev
spec:
  selector:
    app: mysql
  ports:
    - name: mysql
      protocol: TCP
      port: 3306
      targetPort: 3306
  type: NodePort