Deploy MySQL on Kubernetes Kodekloud

 

Question: 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.

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.

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_tim, second key is password and value is LQfKeWWxWD, create one more secret named mysql-db-url, key name is database and value is kodekloud_db7

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 key: username

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

Solution:

At first create the mentioned secrets

kubectl create secret generic mysql-root-pass --from-literal=password=YUIidhb667

kubectl create secret generic mysql-user-pass --from-literal=username=kodekloud_tim --from-literal=password=LQfKeWWxWD

kubectl create secret generic mysql-db-url --from-literal=database=kodekloud_db7

  

Then create a mysql.yaml with persistant volume, claim, service, and deployment

vi mysql.yaml

---

apiVersion: v1

kind: PersistentVolume

metadata:

name: mysql-pv

spec:

capacity:

storage: 250Mi

accessModes:

- ReadWriteOnce

hostPath:

path: "/var/lib/mysql"

---

apiVersion: v1

kind: PersistentVolumeClaim

metadata:

name: mysql-pv-claim

spec:

accessModes:

- ReadWriteOnce

resources:

requests:

storage: 250Mi

---

apiVersion: v1

kind: Service

metadata:

name: mysql

spec:

type: NodePort

selector:

app: mysql

ports:

- port: 3306

targetPort: 3306

nodePort: 30007

---

apiVersion: apps/v1

kind: Deployment

metadata:

name: mysql-deployment

labels:

app: mysql

spec:

replicas: 1

selector:

matchLabels:

app: mysql

template:

metadata:

labels:

app: mysql

spec:

volumes:

- name: mysql-pv

persistentVolumeClaim:

claimName: mysql-pv-claim

containers:

- name: mysql

image: mysql:latest

env:

- name: MYSQL_ROOT_PASSWORD

valueFrom:

secretKeyRef:

name: mysql-root-pass

key: password

- name: MYSQL_DATABASE

valueFrom:

secretKeyRef:

name: mysql-db-url

key: database

- name: MYSQL_USER

valueFrom:

secretKeyRef:

name: mysql-user-pass

key: username

- name: MYSQL_PASSWORD

valueFrom:

secretKeyRef:

name: mysql-user-pass

key: password

volumeMounts:

- name: mysql-pv

mountPath: /var/lib/mysql

ports:

- containerPort: 3306

name: mysql

Then apply

kubectl apply -f mysql.yaml

Download Coding Interview Book and Get More Tutorials for Coding and Interview Solution: Click Here

Download System Design Interview Book and Get More Tutorials and Interview Solution: Click Here

Do you need more Guidance or Help? Then Book 1:1 Quick Call with Me: Click Here

Share on Google Plus

About Ashadullah Shawon

I am Ashadullah Shawon. I am a Software Engineer. I studied Computer Science and Engineering (CSE) at RUET. I Like To Share Knowledge. Learn More: Click Here