What is PostgreSQL?PostgreSQL is a powerful, open-source Relational Database Management System. Any organization or any individual does not control PostgreSQL. Its source code is available free of charge. PostgreSQL has earned a strong reputation for its reliability, data integrity, and correctness.
- Runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, macOS, Solaris, Tru64), and Windows.
- Being Fully ACID compliant, it has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages).
- Includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP.
- Supports the storage of binary large objects, including pictures, sounds, or video.
- It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.
Blue-Green Deployment DatabaseBlue-Green Deployment Strategy is a special strategy that reduces the risk and minimizes downtime. It uses two production environments, Blue and Green. Only one of these environments is alive at the moment, and deployment is done on the inactive one. For example, if Green is a live environment, deployment to the Blue (inactive) environment occurs, and a switchover occurs after verification, which renders the Blue environment as the live environment and the Green environment inactive. Let's go ahead to know how we make use of this strategy in deploying PostgreSQL on Kubernetes.
How use PostgreSQL on Kubernetes?
Following are the Prerequisites for PostgreSQL Deployment on Kubernetes.
Step 1 - Create a PostgreSQL Container Image with DockerCreate a file name “Dockerfile” for PostgreSQL. This image contains our custom config dockerfile, which will look like this:
This Postgres image has a base image of ubuntu xenial. After that, we create Super User and default databases. Exposing the 5432 port will help the external system to connect to the PostgreSQL server.
FROM ubuntu: latest MAINTAINER XenonStack RUN apt - key adv--keyserver hkp: //p80.pool.sks-keyservers.net:80 --recv-keys B97B0AFCAA1A47F044F244A07FCC7D46ACCC4CF8 RUN echo "deb http://apt.postgresql.org/pub/repos/apt/ xenial-pgdg main" > /etc/apt / sources.list.d / pgdg.list RUN apt - get update && apt - get install - y python - software - properties software - properties - common postgresql - 9.6 postgresql - client - 9.6 postgresql - contrib - 9.6 RUN / etc / init.d / postgresql start && \ psql--command "CREATE USER root WITH SUPERUSER PASSWORD 'xenonstack';" && \ createdb - O root xenonstack RUN echo "host all all 0.0.0.0/0 md5" >> /etc/postgresql / 9.6 / main / pg_hba.conf RUN echo "listen_addresses='*'" >> /etc/postgresql / 9.6 / main / postgresql.conf # Expose the PostgreSQL port EXPOSE 5432 # Add VOLUMEs to allow backup of databases VOLUME["/var/lib/postgresql"] # Set the default command to run when starting the container CMD["/usr/lib/postgresql/9.6/bin/postgres", "-D", "/var/lib/postgresql", "-c", "config_file=/etc/postgresql/9.6/main/postgresql.conf"]
Step 2 - Build PostgreSQL Docker Image
$ docker build - t dr.xenonstack.com: 5050 / postgres: v9 .6
Step 3 - Create a Storage Volume (Using GlusterFS)Using the below-mentioned command creates a volume in GlusterFS for PostgreSQL and start it. As we don’t want to lose our PostgreSQL Database data just because a Gluster server dies in the cluster, so we put replica 2 or more for higher availability of data.
$ gluster volume create postgres - disk replica 2 transport tcp k8 - master: /mnt/brick 1 / postgres - disk k8 - 1: /mnt/brick 1 / postgres - disk $ gluster volume start postgres - disk $ gluster volume info postgres - disk
Step 4 - Deploy PostgreSQL with Docker on KubernetesDeploying PostgreSQL on Kubernetes has the following prerequisites:
- Docker Image: We have created a Docker Image for Postgres in Step 2
- Persistent Shared Storage Volume: We have created a Persistent Shared Storage Volume in Step 3
- Deployment & Service Files: Next, we will create Deployment & Service Files
We need to Define the Environment Variables for PostgreSQL: 1. POSTGRES_USER (Super Username for PostgreSQL) 2. POSTGRES_PASSWORD (SuperUser password for PostgreSQL) 3. PGDATA (Data Directory for PostgreSQL Database) Now we need to create a file named “service.yml” for PostgreSQL. This deployment file will look like this:
apiVersion: extensions / v1beta1 kind: Deployment metadata: name: postgres namespace: production spec: replicas: 1 template: metadata: labels: k8s - app: postgres spec: containers: -name: postgres image: dr.xenonstack.com: 5050 / postgres: v9 .6 imagePullPolicy: "IfNotPresent" ports: -containerPort: 5432 env: -name: POSTGRES_USER value: postgres - name: POSTGRES_PASSWORD value: superpostgres - name: PGDATA value: /var/lib / postgresql / data / pgdata volumeMounts: -mountPath: /var/lib / postgresql / data name: postgredb volumes: -name: postgredb glusterfs: endpoints: glusterfs - cluster path: postgres - disk readOnly: false
Now let's deploy PostgreSQL using the following commands:
apiVersion: v1 kind: Service metadata: labels: k8s - app: postgres name: postgres namespace: production spec: type: NodePort ports: -port: 5432 selector: k8s - app: postgres
$ kubectl create - f deployment.yml $ kubectl create - f service.yml
You have now successfully Deployed PostgreSQL on Kubernetes.
Summarizing PostgreSQL DeploymentPostgreSQL on Kubernetes helped to utilize resources even better than virtual machines and provide isolation from other apps deployed on the same machine.
Interested in reading about Deploying Kotlin Application on Docker and Kubernetes?
At XenonStack, we have specialized professionals who can help you start with Microservices Architecture, NoSQL, and SQL Database like PostgreSQL On Docker & Kubernetes. Reach Us for Development, Deployment, and Consulting for MicroServices, Kubernetes, and Docker Technology Solutions.
- Read about Kubernetes Architecture and its Components | A Quick Guide
- Get in Touch with us for Kubernetes Consulting Services and Solutions