K8S 使用NFS存储 动态创建 PVC/PV 并通过 Statefulset 部署 MySQL
2023-09-14 09:16:40 时间
K8S 使用NFS存储 动态创建 PVC
1、创建
vim statefulset-mysql.yaml
# MySQL 配置
apiVersion: v1
kind: ConfigMap
metadata:
name: mysql-config
data:
MYSQL_ROOT_PASSWORD: '123456'
---
# MySQL 容器
apiVersion: apps/v1
kind: StatefulSet
metadata:
name: mysql
spec:
replicas: 1
serviceName: mysql-service
selector:
matchLabels:
app: mysql
template:
metadata:
labels:
app: mysql
spec:
containers:
- name: mysql
image: mysql:5.7
imagePullPolicy: IfNotPresent
ports:
- name: mysql
containerPort: 3306
protocol: TCP
envFrom:
- configMapRef:
name: mysql-config
resources:
requests:
cpu: 1
memory: 1Gi
limits:
cpu: 1
memory: 1Gi
volumeMounts:
- name: mysql-data
mountPath: /var/lib/mysql
volumeClaimTemplates:
- metadata:
name: mysql-data
spec:
accessModes: ["ReadWriteOnce"]
storageClassName: nfs-storage
resources:
requests:
storage: 1Gi
---
# 内部访问的无头服务
apiVersion: v1
kind: Service
metadata:
name: mysql-service
spec:
selector:
app: mysql
ports:
- name: mysql
port: 3306
clusterIP: None
---
# 外部访问的服务
apiVersion: v1
kind: Service
metadata:
name: mysql-external-service
spec:
selector:
app: mysql
ports:
- name: mysql
protocol: TCP
port: 3306
targetPort: 3306
nodePort: 30306
type: NodePort
相关文章
- Navicat Premium连接MySQL 1251错误和Mysql初始化root密码和允许远程访问
- spring学习笔记(19)mysql读写分离后端AOP控制实例
- 【MySQL】常见错误与常用命令的集锦
- mysql的innodb_flush_log_at_trx_commit参数深有体会
- 【MySQL】MetaData Lock 之一
- 【MySql】MySQL Replication Fatal Error 1236
- 【MySql】开机自动启动mysql服务
- linux - mysql 异常:MySQL Daemon failed to start.
- navcat导入mysql.sql出现:2006, 'MySQL server has gone away'
- MySQL按照汉字的拼音排序,mysql汉字排序
- 1.5 MySql建表
- Linux下apache+php+mysql搭建配置记录
- mysql启动时报错:Starting MySQL... ERROR! The server quit without updating PID file (/opt/mysql/data/mysql.pid) 的解决方法
- 阿里云vps上mysql挂掉的解决办法
- MYSQL随机抽取查询 MySQL Order By Rand()效率问题
- Mybatis与Spring整合连接MySQL
- Mysql:Error Code 1235,This version of MySQL doesn’t yet support ‘LIMIT & IN/ALL/ANY/SOME 错误解决
- MySQL内核月报 2015.01-MySQL · 捉虫动态· mysql client crash一例
- 数据库内核月报 - 2015 / 09-MySQL · 引擎特性 · InnoDB Adaptive hash index介绍
- MySQL中的char和varchar&mysql中varchar能存多少汉字、数字,以及varchar(100)和varchar(10)的区别
- MySQL多表查询
- MySQL数据库技术与应用:数据查询
- Groonga开源搜索引擎——列存储做聚合,没有内建分布式,分片和副本是随mysql或者postgreSQL作为存储引擎由MySQL自身来做分片和副本的
- 安全测试===Mysql 注入技巧学习 MySQL注入技巧(1)
- mysql_13 _ 为什么表数据删掉一半,表文件大小不变?
- MySQL(10)聚合查询、分组查询、分页查询
- Mysql之安全清理mysql-slow.log
- golang操作mysql数据库(Go-SQL-Driver/MySQL)
- MySQL常见面试题总结
- MySQL 分区表
- Mysql数据库的安装教程