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-mysqllabels:k8s.kuboard.cn/layer: dbk8s.kuboard.cn/name: nacos-mysqlname: nacos-mysqlnamespace: sca-devresourceVersion: '541578'
spec:podManagementPolicy: Parallelreplicas: 1revisionHistoryLimit: 10selector:matchLabels:k8s.kuboard.cn/layer: dbk8s.kuboard.cn/name: nacos-mysqlserviceName: nacos-mysqltemplate:metadata:creationTimestamp: nulllabels:k8s.kuboard.cn/layer: dbk8s.kuboard.cn/name: nacos-mysqlspec:containers:- env:- name: MYSQL_DATABASEvalue: nacos_dev- name: MYSQL_USERvalue: nacos- name: MYSQL_PASSWORDvalue: nacos- name: MYSQL_ROOT_PASSWORDvalue: 123qwe##image: 'swr.cn-east-2.myhuaweicloud.com/blade/nacos-mysql:5.7'imagePullPolicy: IfNotPresentlivenessProbe:exec:command:- mysqladmin- pingfailureThreshold: 3initialDelaySeconds: 30periodSeconds: 10successThreshold: 1timeoutSeconds: 1name: mysqlports:- containerPort: 3306name: mysqlprotocol: TCPreadinessProbe:exec:command:- mysql- '-h'- 127.0.0.1- '-e'- select 1failureThreshold: 3initialDelaySeconds: 30periodSeconds: 10successThreshold: 2timeoutSeconds: 1resources:limits:memory: 1000Mirequests:memory: 100MistartupProbe:exec:command:- mysql- '-h'- 127.0.0.1- '-e'- select 1failureThreshold: 20initialDelaySeconds: 30periodSeconds: 10successThreshold: 1timeoutSeconds: 1terminationMessagePath: /dev/termination-logterminationMessagePolicy: FilevolumeMounts:- mountPath: /var/lib/mysqlname: nacos-dbdnsPolicy: ClusterFirstrestartPolicy: AlwaysschedulerName: default-schedulersecurityContext: {}terminationGracePeriodSeconds: 30volumes:- name: nacos-dbnfs:path: /mnt/nacosdbserver: 10.0.2.210updateStrategy:rollingUpdate:partition: 0type: RollingUpdate---
apiVersion: v1
kind: Service
metadata:annotations:k8s.kuboard.cn/workload: nacos-mysqllabels:k8s.kuboard.cn/layer: dbk8s.kuboard.cn/name: nacos-mysqlname: nacos-mysqlnamespace: sca-devresourceVersion: '1487805'
spec:clusterIP: 10.233.61.142clusterIPs:- 10.233.61.142externalTrafficPolicy: ClusterinternalTrafficPolicy: ClusteripFamilies:- IPv4ipFamilyPolicy: SingleStackports:- name: zfjr8hnodePort: 31190port: 3306protocol: TCPtargetPort: 3306selector:k8s.kuboard.cn/layer: dbk8s.kuboard.cn/name: nacos-mysqlsessionAffinity: Nonetype: NodePort

示例运行结果