🔧 Day 25 – Manual Stack Setup with Vagrant: Intro & Database Layer

Kicking off a new DevOps mini-series! Learn how to manually set up a full stack Java project using multi-stage Vagrant VMs. Today, we cover the Vagrant environment, plugin setup, and the full MySQL database configuration.

Welcome to Day 25 of my DevOps Journey in Public! 🚀

This week, I’m starting a mini-series on how I manually set up a Java-based project stack using Vagrant multi-VMs — and then how I plan to automate it with provisioning.

---

🧱 Stack Overview

We’ll be building and connecting the following services across multiple Vagrant-managed virtual machines:

• MySQL → SQL database

• Memcached → Caching service

• RabbitMQ → Broker/Queue

• Tomcat → Application server

• Nginx → Web server

---

🛠️ Prerequisites for This Setup

Before getting started, I made sure to install:

• Oracle VirtualBox

• Vagrant

• Git Bash or a Linux terminal

• Vagrant plugins:

    vagrant plugin install vagrant-hostmanager
    vagrant plugin install vagrant-vbguest
  

---

🗂️ Project Structure

vprofile-project/
├── vagrant/
│   └── Manual_provisioning/
│       ├── Vagrantfile

I cloned the repo and moved into the Manual_provisioning/ directory:

git clone -b main https://github.com/hkhcoder/vprofile-project.git
cd vprofile-project/vagrant/Manual_provisioning
vagrant up

If the VMs failed halfway, I just re-ran vagrant up again.

---

🐬 Step 1: MySQL (MariaDB) Setup

🔐 SSH into the DB VM

vagrant ssh db01
sudo -i

🧾 Install MariaDB

yum install mariadb-server -y
systemctl start mariadb
systemctl enable mariadb

🔒 Secure Installation

mysql_secure_installation
# Root password: admin123

🗄️ Create DB and User

mysql -u root -padmin123
> CREATE DATABASE accounts;
> GRANT ALL PRIVILEGES ON accounts.* TO 'admin'@'%' IDENTIFIED BY 'admin123';
> FLUSH PRIVILEGES;
> exit

📦 Import DB Dump

git clone -b main https://github.com/hkhcoder/vprofile-project.git
cd vprofile-project
mysql -u root -padmin123 accounts < src/main/resources/db_backup.sql

🔥 Firewall Configuration

systemctl start firewalld
systemctl enable firewalld
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload

---

📌 Wrapping Up Day 25

✅ We’ve:

• Set up the project environment

• Installed required plugins

• Brought up our VMs

• Installed and configured MariaDB with a test DB and user

Next up? Memcached and RabbitMQ setup in Day 26. See you there! 👋

➡️ Follow along the series and give feedback! #LearnInPublic #DevOps #Vagrant