Deploy UserManagement Web Application with MySQL Database¶

Link to all the Kubernetes Manifests¶

Step-01: Introduction¶

• We are going to deploy a User Management Web Application which will connect to MySQL Database schema webappdb during startup.
• Then we can test the following APIs
• Create Users
• List Users
• Delete User

Azure Kubernetes Service with Azure DevOps and Terraform¶

Step-02: Create following Kubernetes manifests¶

Create User Management Web Application k8s Deployment manifest¶

• Environment Variables

• Problem Observation:
• If we deploy all manifests at a time, by the time mysql is ready our User Management Web Application pod will be throwing error due to unavailability of Database.
• To avoid such situations, we can apply initContainers concept to our User management Web Application Deployment manifest.
• We will see that in our next section but for now lets continue to test the application

Create User Management Web Application Load Balancer Service manifest¶

• LoadBalancer Service

Step-03: Create UserManagement Web Application Deployment & Service¶

# Create Deployment & LoadBalancer Service
kubectl apply -f kube-manifests/

# List Pods
kubectl get pods

# Verify logs of Usermgmt Web Application Pod
kubectl logs -f <pod-name> 
# If we have only 1 pod, below commnad works well for getting the logs
kubectl logs -f $(kubectl get po  | egrep -o 'usermgmt-webapp-[A-Za-z0-9-]+')

# Verify sc, pvc, pv
kubectl get sc,pvc,pv

• Access Application

  # List Services
  kubectl get svc
  
  # Access Application
  http://<External-IP-from-get-service-output>
  Username: admin101
  Password: password101
  

Step-04: Test User Management Web Application using Browser¶

• Usecase-1: Login, List Users and Logout
• Username: admin101
• Password: password101
• Usecase-2: Login, Create New User and Logout and login with new user
• Username: admin101
• Password: password101
• Create New User
  • User Details: admin102, password102, fname102, lname102, admin102@gmail.com, ssn102
• Login with newly user and list users
  • Username: admin102
  • Password: password102

Step-05: Verify Users in MySQL Database¶

# 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;
mysql> use usermgmt;
mysql> show tables;
mysql> select * from user;

Step-06: Clean-Up¶

• Delete all k8s objects created as part of this section

  # Delete All
  kubectl delete -f kube-manifests/
  
  # List Pods
  kubectl get pods
  
  # Verify sc, pvc, pv
  kubectl get sc,pvc,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
  

Best Selling Azure Kubernetes Service Course on Udemy¶

Best Selling AWS EKS Kubernetes Course on Udemy¶

HashiCorp Certified Terraform Associate - 50 Practical Demos¶