📘 DevOps Exam App – Dockerized Full Stack Project

A Dockerized Full Stack DevOps Exam App built using:

• 🐍 Flask (Backend)
• 🖥 HTML + JavaScript (Frontend)
• 🐬 MySQL 5.7 (Database)
• 🐳 Docker + Docker Compose

🚀 Setup Instructions

✅ 1. Install Docker and Docker Compose

sudo apt update
sudo apt install -y docker.io docker-compose

Enable and start Docker:

sudo systemctl enable docker
sudo systemctl start docker

Verify installation:

docker --version
docker-compose --version

---

📥 2. Clone the Repository

git clone https://github.com/VedTambe/Devops-Exam-App.git
cd Devops-Exam-App

---

🔐 3. Create .env File

Create a file named .env at the root of the project and add:

PORT=5000
DB_HOST=exam-mysql
DB_USER=exam_user
DB_PASSWORD=exam_pass
DB_NAME=devops_exam

---

🐬 4. MySQL Auto Setup

The file db/init.sql will:

• Create a database devops_exam
• Create a table results
• Create user exam_user with password exam_pass
• Grant all privileges

⚠️ No need to do this manually — handled by Docker Compose.

---

🐳 5. Build & Run the App

docker-compose up --build

This will:

• Start MySQL container on port 3306
• Start Flask app on port 5000
• Load environment variables from .env

---

🌐 6. Access the Application

Open browser and visit:

http://<your-ec2-public-ip>:5000/

---

🧪 7. Optional: Access MySQL

docker exec -it mysql_db /bin/bash
mysql -u root -p

Then run:

SHOW DATABASES;
USE devops_exam;
SHOW TABLES;
SELECT * FROM results;

---

⛔ 8. Stop the Application

docker-compose down

---

💡 Tips

If you update the init.sql, run:

docker volume rm devops-exam-app_db_data
docker-compose up --build

---

🙌 Author

Built with ❤️ by Vedant Tambe