Google Cloud Platform Project

Abhiroop Bas
3 min readAug 26, 2020
Kubernetes cluster and load balancer to a Wordpress site managed by a SQL server from two different projects

Project description:

Using GCP platform to create a load balancer with the help of a Kubernetes cluster and SQL server for a php site for two projects connected by VPC peering

Project Objective:

1. Create multiple projects namely developer and production

2. Create VPC network for both the projects

3. Create a link between both the VPC networks using VPC Peering

4. Create a Kubernetes Cluster in developer project and launch any web application with the Load balancer

5. Create a SQL server in the production project and create a database

6. Connect the SQL database to the web application launched in the Kubernetes cluster

Load balancer
SQL

Services and technologies used:

· Google Cloud Platform Console

· Compute Engine

· Virtual Private Cloud

· Firewall

· Google Cloud Engine

· Google Kubernetes Engine

· Structured Query Language

· Load balancer

Google Cloud Platform

· Identity and Access Management

Kubernetes

Process:

STEP 1: Create two projects say, “devproject” and “prodproject”

STEP 2: Create a new instance

The instance in devproject is set up as a CentOS 7 in asia-southeast-1 region (Singapore).

The instance in prodproject is set up as a CentOS 7 in us-east-1 region (South Carolina).

Instances

STEP 3: Create firewall rule

Allow Ingress for all IP ranges (0.0.0.0/0) for the tcp: 80 port

STEP 4: Setup VPC sub network

The sub network for the devproject instance be set up in us-east-1 and that for prodproject instance in asia-southeast-1 region

STEP 5: VPC peering

Apply for VPC peering from both the projects to each other to enable the systems to be connected.

VPC peering

STEP 6: Use GKE to setup a Kubernetes cluster

Add a node to the devproject and create a Kubernetes cluster in 3 zones.

Kubernetes cluster

STEP 7: Load balancer

Use kubectl.exe from the command prompt connected to the devproject to do horizontal scaling of pods and use deployment to setup a load balancer

STEP 8: SQL database

Setup a SQL database in the prodproject using the Storage services of GCP and add a database to it. Add user to it to enable update into the database.

SQL database

STEP 9: Wordpress image setup

Setup the Wordpress image using kubectl.exe and attach the load balancer to it.

STEP 10: IAM services

Use defined set of roles or customized roles to give access to the prodproject as other users through Google account

Conclusions:

The Google Cloud Platform can be used to manage and cater to clients from all across the world without having physical offices in all the destinations.

Sign up to discover human stories that deepen your understanding of the world.

Free

Distraction-free reading. No ads.

Organize your knowledge with lists and highlights.

Tell your story. Find your audience.

Membership

Read member-only stories

Support writers you read most

Earn money for your writing

Listen to audio narrations

Read offline with the Medium app

Abhiroop Bas
Abhiroop Bas

No responses yet

Write a response