100-Days-Of-DevOps-Challenge-KodeKloud

Deploy MySQL on Kubernetes

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

6. Define some Environment variables within the container:

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

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

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

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

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

Steps

1. Let’s create the k3s-mysql-deployment.yml and copy-paste the contents from this YAML file

2. Create a volume directory for persistent volume:

    mkdir -p /home/thor/pv
   

3. Create the deployment

    kubectl apply -f k3s-mysql-deployment.yml
   

4. Verify Results

    kubectl get deployments.apps
    kubectl describe deployments.apps mysql-deployment
    kubectl get pods
    kubectl get pv
    kubectl get pvc
    kubectl get svc
    kubectl get secrets
   

Passing passwords in plain text are not allowed, that’s why we have used stringData in secret.

Good to Know?

MySQL on Kubernetes

• Stateful Application: Requires persistent storage
• Data Persistence: Use PVCs for database files
• Configuration: Environment variables for database setup
• Security: Secrets for passwords and credentials

Database Security

• Root Password: Strong password for root user
• User Accounts: Create specific users for applications
• Network Security: Limit access with network policies
• Encryption: Enable encryption at rest and in transit

Persistent Storage

• Data Directory: Mount PVC at /var/lib/mysql
• Backup Strategy: Regular database backups
• Storage Class: Choose appropriate storage type
• Volume Expansion: Plan for storage growth

Production Considerations

• High Availability: MySQL replication or clustering
• Monitoring: Database performance and health metrics
• Backup: Automated backup and restore procedures
• Resource Limits: Appropriate CPU and memory allocation

This site is open source. Improve this page.