# Create Storage Class & PVC
kubectl apply -f kube-manifests/01-storage-class.yml
kubectl apply -f kube-manifests/02-persistent-volume-claim.yml
# List Storage Classes
kubectl get sc
# List PVC
kubectl get pvc
# List PV
kubectl get pv
We are going to create a usermgmt database schema during the mysql pod creation time which we will leverage when we deploy User Management Microservice.
At any point of time we are going to have only one mysql pod in this design so ClusterIP: None will use the Pod IP Address instead of creating or allocating a separate IP for MySQL Cluster IP service.
Step-03: Create MySQL Database with all above manifests¶
# Create MySQL Database
kubectl apply -f kube-manifests/
# List Storage Classes
kubectl get sc
# List PVC
kubectl get pvc
# List PV
kubectl get pv
# List pods
kubectl get pods
# List pods based on label name
kubectl get pods -l app=mysql
# Connect to MYSQL Database
kubectl run -it --rm --image=mysql:5.6 --restart=Never mysql-client -- mysql -h mysql -pdbpassword11
# Verify usermgmt schema got created which we provided in ConfigMap
mysql> show schemas;
Step-06: Delete PV exclusively - It exists due to retain policy¶
# List PV
kubect get pv
# Delete PV exclusively
kubectl get pv
kubectl delete pv <PV-NAME>
# Delete Azure Disks
Go to All Services -> Disks -> Select and Delete the Disk
