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

在Kubernetes上部署MySQL可以通过以下步骤进行：

1. 创建一个Dockerfile来构建包含MySQL的Docker镜像。
2. 创建一个Kubernetes ConfigMap来保存MySQL配置文件。
3. 创建一个Kubernetes Deployment来部署MySQL Pod。
4. 创建一个Kubernetes Service来暴露MySQL服务。

以下是一个简单的例子：

Dockerfile:

FROM mysql:5.7
COPY my.cnf /etc/mysql/conf.d/

my.cnf (你需要根据实际情况配置):

[mysqld]
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
datadir         = /var/lib/mysql
# Only allow connections from localhost
bind-address    = 0.0.0.0

ConfigMap (mysql-config.yaml):

apiVersion: v1
kind: ConfigMap
metadata:
  name: mysql-config
data:
  my.cnf: |
    [mysqld]
    pid-file = /var/run/mysqld/mysqld.pid
    socket = /var/run/mysqld/mysqld.sock
    datadir = /var/lib/mysql
    # Only allow connections from localhost
    bind-address = 0.0.0.0

Deployment (mysql-deployment.yaml):

apiVersion: apps/v1
kind: Deployment
metadata:
  name: mysql
spec:
  replicas: 1
  selector:
    matchLabels:
      app: mysql
  template:
    metadata:
      labels:
        app: mysql
    spec:
      containers:
      - name: mysql
        image: mysql:5.7
        env:
        - name: MYSQL_ROOT_PASSWORD
          value: "yourpassword"
        ports:
        - containerPort: 3306
          name: mysql
        volumeMounts:
        - name: mysql-config-volume
          mountPath: /etc/mysql/conf.d
        - name: mysql-storage
          mountPath: /var/lib/mysql
      volumes:
      - name: mysql-config-volume
        configMap:
          name: mysql-config
          items:
          - key: my.cnf
            path: my.cnf
      - name: mysql-storage
        persistentVolumeClaim:
          claimName: mysql-pv-claim

Service (mysql-service.yaml):

apiVersion: v1
kind: Service
metadata:
  name: mysql
spec:
  ports:
  - port: 3306
  selector:
    app: mysql
  clusterIP: None

PersistentVolumeClaim (mysql-pv-claim.yaml):

apiVersion: v1
kind: PersistentVolumeClaim
metadata:
  name: mysql-pv-claim
spec:
  accessModes:
    - ReadWriteOnce
  resources:
    requests:
      storage: 10Gi

在Kubernetes集群中部署时，你需要先创建PersistentVolumeClaim来申请存储，然后依次应用ConfigMap、Deployment和Service资源。这样就可以在Kubernetes上部署一个可用的MySQL服务了。记得替换Dockerfile中的配置和Deployment中的环境变量（如MySQL root密码）以及PersistentVolumeClaim中的存储大小。