k8s 如何部署Mysql(史上最权威教程)?

Kuboard K8s 部署Mysql5.7-8.x版本

部署Mysql5.7

在 Kuboard 界面进入名称空间 （自己的命令空间），点击 创建工作负载 按钮，并填写表单，如下图所示：

字段名称	填写内容
工作负载类型	有状态副本集（StatefulSet）
工作负载分层	持久层
工作负载名称	nacos-mysql
副本数量	1

基本信息

容器信息

字段名称	填写内容
名称	mysql
容器镜像	swr.cn-east-2.myhuaweicloud.com/blade/nacos-mysql:5.7
环境变量1	MYSQL_DATABASE=nacos_dev
环境变量2	MYSQL_USER=nacos
环境变量3	MYSQL_PASSWORD=nacos
环境变量4	MYSQL_ROOT_PASSWORD=123456
资源请求/限制	内存资源请求200Mi 内存资源限制4000Mi
容器端口	3306

• 容器启动检查探针
  
  

• 存储挂载

高级设置

服务/应用路由

最后点击保存。

命令行配置文件如下

 ---
apiVersion: apps/v1
kind: StatefulSet
metadata:
  annotations:
    k8s.kuboard.cn/workload: nacos-mysql
  labels:
    k8s.kuboard.cn/layer: db
    k8s.kuboard.cn/name: nacos-mysql
  name: nacos-mysql
  namespace: sca-dev
  resourceVersion: '541578'
spec:
  podManagementPolicy: Parallel
  replicas: 1
  revisionHistoryLimit: 10
  selector:
    matchLabels:
      k8s.kuboard.cn/layer: db
      k8s.kuboard.cn/name: nacos-mysql
  serviceName: nacos-mysql
  template:
    metadata:
      creationTimestamp: null
      labels:
        k8s.kuboard.cn/layer: db
        k8s.kuboard.cn/name: nacos-mysql
    spec:
      containers:
        - env:
            - name: MYSQL_DATABASE
              value: nacos_dev
            - name: MYSQL_USER
              value: nacos
            - name: MYSQL_PASSWORD
              value: nacos
            - name: MYSQL_ROOT_PASSWORD
              value: 123qwe##
          image: 'swr.cn-east-2.myhuaweicloud.com/blade/nacos-mysql:5.7'
          imagePullPolicy: IfNotPresent
          livenessProbe:
            exec:
              command:
                - mysqladmin
                - ping
            failureThreshold: 3
            initialDelaySeconds: 30
            periodSeconds: 10
            successThreshold: 1
            timeoutSeconds: 1
          name: mysql
          ports:
            - containerPort: 3306
              name: mysql
              protocol: TCP
          readinessProbe:
            exec:
              command:
                - mysql
                - '-h'
                - 127.0.0.1
                - '-e'
                - select 1
            failureThreshold: 3
            initialDelaySeconds: 30
            periodSeconds: 10
            successThreshold: 2
            timeoutSeconds: 1
          resources:
            limits:
              memory: 1000Mi
            requests:
              memory: 100Mi
          startupProbe:
            exec:
              command:
                - mysql
                - '-h'
                - 127.0.0.1
                - '-e'
                - select 1
            failureThreshold: 20
            initialDelaySeconds: 30
            periodSeconds: 10
            successThreshold: 1
            timeoutSeconds: 1
          terminationMessagePath: /dev/termination-log
          terminationMessagePolicy: File
          volumeMounts:
            - mountPath: /var/lib/mysql
              name: nacos-db
      dnsPolicy: ClusterFirst
      restartPolicy: Always
      schedulerName: default-scheduler
      securityContext: {}
      terminationGracePeriodSeconds: 30
      volumes:
        - name: nacos-db
          nfs:
            path: /mnt/nacosdb
            server: 10.0.2.210
  updateStrategy:
    rollingUpdate:
      partition: 0
    type: RollingUpdate

---
apiVersion: v1
kind: Service
metadata:
  annotations:
    k8s.kuboard.cn/workload: nacos-mysql
  labels:
    k8s.kuboard.cn/layer: db
    k8s.kuboard.cn/name: nacos-mysql
  name: nacos-mysql
  namespace: sca-dev
  resourceVersion: '1487805'
spec:
  clusterIP: 10.233.61.142
  clusterIPs:
    - 10.233.61.142
  externalTrafficPolicy: Cluster
  internalTrafficPolicy: Cluster
  ipFamilies:
    - IPv4
  ipFamilyPolicy: SingleStack
  ports:
    - name: zfjr8h
      nodePort: 31190
      port: 3306
      protocol: TCP
      targetPort: 3306
  selector:
    k8s.kuboard.cn/layer: db
    k8s.kuboard.cn/name: nacos-mysql
  sessionAffinity: None
  type: NodePort

示例运行结果