Skip to main content

Deploying MySQL on Qubinets

Deploying an application like MySQL on Qubinets involves several steps. Qubinets provides a platform to manage and orchestrate Kubernetes clusters, making it simpler to deploy and manage applications in a cloud-native environment. Here is a detailed tutorial to guide you through the process:

Prerequisites​

  1. Qubinets Account: Ensure you have an account on Qubinets. Sign up if you don’t have one.
  2. Kubernetes Cluster: You need an existing Kubernetes cluster or you can create a new one using Qubinets.
  3. kubectl: Ensure kubectl is installed and configured to interact with your Kubernetes cluster.
  4. Helm: Install Helm, which simplifies the deployment of applications on Kubernetes.

Step 1: Create a Kubernetes Cluster on Qubinets​

  1. Login to Qubinets: Go to the Qubinets website and log in with your credentials.
  2. Create a Cluster:
    • Navigate to the "Clusters" section.
    • Click on "Create Cluster".
    • Choose the appropriate configuration for your cluster (e.g., cloud provider, node size, number of nodes, etc.).
    • Follow the prompts to create the cluster. This may take several minutes.

Step 2: Configure kubectl​

  1. Download Configuration File:
    • Once the cluster is created, download the kubeconfig file from the Qubinets dashboard.
    • Save the kubeconfig file to a secure location on your machine.
  2. Set KUBECONFIG Environment Variable: 
    export KUBECONFIG=/path/to/your/kubeconfig
  3. Verify kubectl Access: 
    kubectl get nodes
    • This should list the nodes in your cluster, indicating that kubectl is correctly configured.

Step 3: Install Helm​

  1. Download Helm: Follow the installation guide on the Helm website for your specific operating system.
  2. Initialize Helm: 
    helm repo add bitnami https://charts.bitnami.com/bitnami
    helm repo update

Step 4: Deploy MySQL using Helm​

  1. Search for MySQL Chart: 
    helm search repo mysql
  2. Install MySQL: 
    helm install my-mysql bitnami/mysql
    • Replace my-mysql with a name of your choice for the release.
    • This command deploys MySQL with default settings.

Step 5: Customize MySQL Deployment​

  1. Create a values.yaml File:
    • Customize MySQL settings by creating a values.yaml file.
    auth:
      rootPassword: mypassword
      database: mydatabase
      username: myuser
      password: mypassword
    primary:
      persistence:
        enabled: true
        size: 10Gi
        storageClass: standard
  2. Deploy with Custom Values: 
    helm install my-mysql -f values.yaml bitnami/mysql

Step 6: Verify the Deployment​

  1. Check Pods: 
    kubectl get pods
    • Ensure that the MySQL pod is running.
  2. Check Services: 
    kubectl get svc
    • Verify that the MySQL service is created and accessible.

Step 7: Access MySQL​

  1. Port Forwarding:
    • Forward a local port to the MySQL service.
    kubectl port-forward svc/my-mysql 3306:3306
    • This forwards port 3306 on your local machine to the MySQL service.
  2. Connect to MySQL:
    • Use a MySQL client to connect to the database.
    mysql -h 127.0.0.1 -P 3306 -u myuser -p mydatabase
    • Enter the password when prompted.

Step 8: Manage and Scale MySQL​

  1. Scale the Deployment:
    • Increase or decrease the number of replicas.
    kubectl scale statefulset my-mysql --replicas=3
  2. Upgrade the Deployment:
    • Apply new configuration changes using Helm.
    helm upgrade my-mysql -f values.yaml bitnami/mysql

Step 9: Backup and Restore​

  1. Backup:
    • Use mysqldump to create a backup.
    mysqldump -h 127.0.0.1 -P 3306 -u myuser -p mydatabase > backup.sql
  2. Restore:
    • Use mysql to restore from a backup.
    mysql -h 127.0.0.1 -P 3306 -u myuser -p mydatabase < backup.sql

Step 10: Monitor MySQL​

  1. Prometheus and Grafana:
    • Deploy Prometheus and Grafana to monitor MySQL.
    • Install Prometheus:
    helm install prometheus bitnami/prometheus
    • Install Grafana:
    helm install grafana bitnami/grafana
    • Configure dashboards to monitor MySQL metrics.

Conclusion​

Deploying MySQL on Qubinets using Kubernetes and Helm simplifies the process of managing a robust and scalable database environment. By following these steps, you can efficiently deploy, manage, and monitor MySQL on your Kubernetes cluster.

Remember to regularly update your Helm charts and Kubernetes configurations to ensure security and performance optimizations. Happy deploying!