MySQL Deployment¶

Introduction¶

MySQL is one of the most popular relational database management systems and is among the best RDBMS (Relational Database Management System) applications for web applications.

Prerequisites¶

A Kubernetes cluster has been deployed; if not, refer to Kubernetes Deployment
nfs-subdir-external-provisioner has been deployed; if not, refer to Kubernetes Storage

Basic Information and Compatibility¶

Name	Description
MySQL Version	8.0
Supported Cluster Version	1.18+
Offline Installation Support	Yes
Supported Architecture	amd64/arm64

Default Configuration Information for Deployment¶


Default Address	mysql.middleware
Default Port	3306
Default Account	root/rootPassw0rd

Installation¶

Note

Create an administrator account (it must be an administrator account; this account will be used for initializing various application DBs during subsequent installation. If remote connection is required, enable it accordingly).

If the deployment fails, you can deploy MySQL using Docker.

The highlighted storageClassName should be set according to your actual situation.

Please ensure that you modify the MySQL administrator account.

Save mysql.yaml and deploy.

mysql.yaml (click to expand)

---
apiVersion: v1
kind: PersistentVolumeClaim
metadata:
  annotations:
    volume.beta.kubernetes.io/storage-provisioner: "kubernetes.io/nfs"
  #  volume.beta.kubernetes.io/storage-class: "managed-nfs-storage"
  name: mysql-data
  namespace: middleware
spec:
  accessModes:
  - ReadWriteOnce
  volumeMode: Filesystem
  resources:
    requests:
      storage: 10Gi
  storageClassName:  standard-nfs-storage ## Specify an existing StorageClass


---
apiVersion: v1
kind: ConfigMap
metadata:
  name: mysql-config
  namespace: middleware
  labels:
    app: mysql
data:
  mysqld.cnf: |-
        [mysqld]
        pid-file        = /var/run/mysqld/mysqld.pid
        socket          = /var/run/mysqld/mysqld.sock
        datadir         = /var/lib/mysql
        symbolic-links=0
        max_connections=5000



---
apiVersion: apps/v1
kind: Deployment
metadata:
  labels:
    app: mysql
  name: mysql
  namespace: middleware
spec:
  progressDeadlineSeconds: 600
  replicas: 1
  revisionHistoryLimit: 2
  selector:
    matchLabels:
      app: mysql
  strategy:
    rollingUpdate:
      maxSurge: 25%
      maxUnavailable: 25%
    type: RollingUpdate
  template:
    metadata:
      labels:
        app: mysql
    spec:
      containers:
      - env:
        - name: MYSQL_ROOT_PASSWORD
          value: rootPassw0rd
        - name: MYSQL_DATABASE
          value: FT2.0
        - name: MYSQL_USER
          value: admin
        - name: MYSQL_PASSWORD
          value: admin@123
        image: pubrepo.guance.com/googleimages/mysql:8.0
        imagePullPolicy: IfNotPresent
        name: mysql
        resources:
           limits:
             cpu: '4'
             memory: 4Gi
           requests:
             cpu: 100m
             memory: 512Mi                   
        ports:
        - containerPort: 3306
          name: dbport
          protocol: TCP
        terminationMessagePath: /dev/termination-log
        terminationMessagePolicy: File
        volumeMounts:
        - mountPath: /var/lib/mysql
          name: db
          subPath: data
        - mountPath: /etc/mysql/conf.d/mysqld.cnf
          name: config
          subPath: mysqld.cnf
      dnsPolicy: ClusterFirst
      restartPolicy: Always
      schedulerName: default-scheduler
      securityContext: {}

      terminationGracePeriodSeconds: 30
      volumes:
      - name: db
        persistentVolumeClaim:
          claimName: mysql-data
      - name: config
        configMap:
          name: mysql-config
---
apiVersion: v1
kind: Service
metadata:
  name: mysql
  namespace: middleware
spec:
  ports:
  - name: mysqlport
    nodePort: 32306
    port: 3306
    protocol: TCP
    targetPort: dbport
  selector:
    app: mysql
  sessionAffinity: None
  type: NodePort

Execute the commands to install:

kubectl create namespace middleware
kubectl apply -f mysql.yaml

Verify Deployment¶

Check the pod status

kubectl get pods -n middleware | grep mysql

How to Uninstall¶

kubectl delete -f mysql.yaml