Skip to main content

Deploying PostgreSQL on Qubinets

Deploying an application like PostgreSQL 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 stable https://charts.helm.sh/stable
    helm repo update

Step 4: Deploy PostgreSQL using Helm​

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

Step 5: Customize PostgreSQL Deployment​

  1. Create a values.yaml File:
    • Customize PostgreSQL settings by creating a values.yaml file.
    postgresqlUsername: myuser
    postgresqlPassword: mypassword
    postgresqlDatabase: mydatabase
    persistence:
      enabled: true
      size: 10Gi
      storageClass: standard
  2. Deploy with Custom Values: 
    helm install my-postgresql -f values.yaml stable/postgresql

Step 6: Verify the Deployment​

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

Step 7: Access PostgreSQL​

  1. Port Forwarding:
    • Forward a local port to the PostgreSQL service.
    kubectl port-forward svc/my-postgresql 5432:5432
    • This forwards port 5432 on your local machine to the PostgreSQL service.
  2. Connect to PostgreSQL:
    • Use a PostgreSQL client to connect to the database.
    psql -h localhost -U myuser -d mydatabase
    • Enter the password when prompted.

Step 8: Manage and Scale PostgreSQL​

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

Step 9: Backup and Restore​

  1. Backup:
    • Use pg_dump to create a backup.
    pg_dump -h localhost -U myuser -d mydatabase -f backup.sql
  2. Restore:
    • Use psql to restore from a backup.
    psql -h localhost -U myuser -d mydatabase -f backup.sql

Step 10: Monitor PostgreSQL​

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

Conclusion​

Deploying PostgreSQL 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 PostgreSQL on your Kubernetes cluster.

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