My DevOps Project: Building a Two-Tier Flask App with MySQL

 After a long journey in DevOps, I’m excited to share my latest project! I’ll be using a GitHub repository to build a two-tier Flask application connected to a MySQL database. Here’s a step-by-step guide on how I set it up.

Project Overview:

In this project, I create a Flask app that takes input from environment variables and stores it in a MySQL database.

GitHub Repository:
Two-Tier Flask App

Step-by-Step Instructions

1. Clone the Repository

git clone https://github.com/LondheShubham153/two-tier-flask-app

2. Build the Docker Image

Navigate to the cloned directory and build the Docker image:

docker build -t two-tier-app:latest .

3. Create a Custom Network

List the existing Docker networks:

docker network ls

Create a custom network named twotier:

docker network create twotier

4. Set Up MySQL

a. Create a Docker Volume:

docker volume ls
docker volume create mysql-data

b. Run the MySQL Container:

docker run -d --name mysql-demo -v mysql-data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=root mysql:5.7

c. Access the MySQL Container:

docker exec -it mysql-demo bash

d. Log in to MySQL and Create a Database:

mysql -u root -p
# Enter the password: root
CREATE DATABASE devops;
exit
exit

e. Run MySQL with the Custom Network:

docker run -d -v mysql-data:/var/lib/mysql --network twotier --name mysql -e MYSQL_DATABASE=devops -e MYSQL_ROOT_PASSWORD=root mysql:5.7

Explanation:

  • -v mysql-data:/var/lib/mysql: Binds the mysql-data volume to the container's MySQL data directory.
  • --network twotier: Connects the container to the twotier network.
  • --name mysql: Names the container mysql.
  • -e MYSQL_DATABASE=devops -e MYSQL_ROOT_PASSWORD=root: Sets the database name and root password using environment variables.

5. Run the Flask App

Run the Flask Container:

docker run -d --network twotier --name two-tier-app -e MYSQL_HOST=mysql -e MYSQL_USER=root -e MYSQL_PASSWORD=root -e MYSQL_DB=devops -p 5000:5000 two-tier-app:latest

Explanation:

  • --network twotier: Connects the Flask container to the twotier network.
  • Environment variables (MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DB) pass necessary information for the Flask app to connect to the MySQL database.
  • -p 5000:5000: Exposes port 5000 to access the Flask app.

Here is the YouTube Link: https://youtube.com/@raeesq.?si=v_QK6Q2XXMf9mKep

Conclusion

This project demonstrates how to create a two-tier architecture using Docker, connecting a Flask app with a MySQL database. I hope you find this project helpful and inspiring for your own DevOps journey!

Comments

Post a Comment

Popular posts from this blog

📘 Understanding Prometheus in a Simple Way-Part 3 (For DevOps Beginners)

Image
 In our previous blogs, we have already covered: How to launch an EC2 instance (Link: https://medium.com/@raeesyaqubqazi/prometheus-and-grafana-project-part-1-by-raees-yaqoob-qazi-12eb5c431350 ) How to run our Notes App inside a Docker container (Link: https://medium.com/@raeesyaqubqazi/prometheus-and-grafana-project-part-1-by-raees-yaqoob-qazi-12eb5c431350 ) How to install cAdvisor to collect container-level metrics (Link: https://medium.com/@raeesyaqubqazi/monitoring-containers-with-cadvisor-part-2-of-my-previous-blog-series-cec2452b1ba5 ) Today, we will move one step ahead and learn Prometheus , which will collect the metrics generated by cAdvisor. 🔍 What Is Prometheus? Before understanding Prometheus, let’s talk about how data is stored in databases . ✔️ Relational Databases (MySQL, PostgreSQL) Data is stored in rows and columns  — like an Excel sheet. ✔️ Prometheus (TSDB — Time Series Database) Prometheus does NOT store data in tables.  It stores data in Time Series fo...
Read more

Grafana Setup & Dashboard Creation (Part-5)— Explained by Raees Yaqoob Qazi

Image
 Today, I’m going to talk about Grafana . Grafana is a powerful tool used to create dashboards and visualize data . As DevOps engineers, monitoring is very important, and Grafana makes it easy to understand system performance. Part-1:  https://brillertechnologies.blogspot.com/2025/11/prometheus-and-grafana-projectpart-1-by.html Part 2:  https://brillertechnologies.blogspot.com/2025/11/monitoring-containers-with-cadvisorpart.html Part 3:  https://brillertechnologies.blogspot.com/2025/12/understanding-prometheus-in-simple-way.html Part 4: https://brillertechnologies.blogspot.com/2025/12/understanding-prometheusmonitoring-made.html 1. Running Grafana Using Docker Compose First, I use Docker Compose to run Grafana. Open your docker-compose.yml file: vim docker-compose. yml Add the Grafana service: grafana: image: grafana/grafana-enterprise container_name: grafana restart: unless-stopped ports: - "3000:3000" Save and exit with:   :wq Then run: d...
Read more

My First Python Program: A Simple Calculator

Image
 Today, I am going to create a simple calculator using Python . This might be your first code ever , and honestly, this is also my first Python code . So don’t worry — we are learning together. Let’s start step by step. Step 1: Open VS Code First, open Visual Studio Code (VS Code) . Step 2: Create a Folder and a File Create a new folder (you can name it anything). Inside the folder, create a new file. In my case, I named the file first.py . 👉  .py is the file extension for Python , just like: .cpp for C++ .java for Java Step 3: Write the Python Code Now, write the following code in first.py : num1 = float ( input ( "Enter num 1: " ) ) # Taking first number from the user num2 = float ( input ( "Enter num 2: " ) ) # Taking second number from the user opr = input ( "Enter operator: " ) # User selects the operator (+, -, *) if opr = = "+" : # If operator is + output = num1 + num2 if opr = = "-" : # If operator is - ...
Read more