Deploy MySQL on Kubernetes

Here is part two of a series of lab tasks from KodeKloud for Kubernetes level 4. Master blog listing all parts can be seen here. Make sure to follow setup instructions for minikube on your PC.

Problem with Inline Solutions

A new MySQL server needs to be deployed on Kubernetes cluster. The Nautilus DevOps team was working on to gather the requirements. Recently they were able to finalize the requirements and shared them with the team members to start working on it. Below you can find the details:

1. Create a PersistentVolume mysql-pv, its capacity should be 250Mi, set other parameters as per your preference.

apiVersion: v1 
kind: PersistentVolume 
metadata:
  name: mysql-pv # Make sure matches with requirement
  labels:
    type: local
spec:
  storageClassName: standard       
  capacity:
    storage: 250Mi # important
  accessModes:
    - ReadWriteOnce 
  hostPath:                       
    path: "/mnt/data"
  persistentVolumeReclaimPolicy: Retain

2. Create a PersistentVolumeClaim to request this PersistentVolume storage. Name it as mysql-pv-claim and request a 250Mi of storage. Set other parameters as per your preference.

apiVersion: v1 
kind: PersistentVolumeClaim # Important, the type of object
metadata:                          
  name: mysql-pv-claim # Again, must match with spec
  labels:
    app: mysql-app 
spec:                              
  storageClassName: standard       
  accessModes:
    - ReadWriteOnce             
  resources:
    requests:
      storage: 250Mi # Spec!

3. Create a deployment named mysql-deployment, use any mysql image as per your preference. Mount the PersistentVolume at mount path /var/lib/mysql.

4. Create a NodePort type service named mysql and set nodePort to 30007.

5. Create a secret named mysql-root-pass having a key pair value, where key is password and its value is YUIidhb667, create another secret named mysql-user-pass having some key pair values, where frist key is username and its value is kodekloud_cap, second key is password and value is ksH85UJjhb, create one more secret named mysql-db-url, key name is database and value is kodekloud_db2

6. Define some Environment variables within the container:

   a) name: MYSQL_ROOT_PASSWORD, should pick value from secretKeyRef name: mysql-root-pass and key: password

   b) name: MYSQL_DATABASE, should pick value from secretKeyRef name: mysql-db-url and key: database

   c) name: MYSQL_USER, should pick value from secretKeyRef name: mysql-user-pass key: username

   d) name: MYSQL_PASSWORD, should pick value from secretKeyRef name: mysql-user-pass and key: password

kubectl create deployment mysql-deployment \
  --dry-run=client --image=mysql:5.6 \
  -o yaml > deployment.yaml

Edit deployment.yaml to include all requirements in sections listed above. Final YAML specification can be found here.

Make sure to create secrets as listed in #5 above before applying deployment.

$ kubectl create secret generic mysql-root-pass \
    --from-literal=password=YUIidhb667
$ kubectl create secret generic mysql-user-pass \
    --from-literal=username=kodekloud_cap \
    --from-literal=password=ksH85UJjhb
$ kubectl create secret generic mysql-db-url \
    --from-literal=database=kodekloud_db2

That's it. Now you just need to apply the deployment and verify.

$ kubectl apply -f deployment.yaml
$ kubectl get deploy
$ kubectl get pods

Note: The kubectl utility on jump_host has been configured to work with the kubernetes cluster.