DevOps · Infrastructure · 2026 — Present
Multi-Entity MySQL Backup Automation
DevOps & Infrastructure Engineer
A centralized backup pipeline for nine production web systems — each running on its own VPS — with dedicated Bash scripts per entity that pull daily incremental MySQL dumps into a single Ubuntu storage host for traceability, reliability, and fast restore.
Stack
BashMySQLUbuntuVPSCronShellSystem map
System captures
Problem
Nine production web systems on nine VPS relied on ad-hoc MySQL dumps — restores were slow, inconsistent, and hard to audit.
Solution
Automated per-entity Bash backup scripts with daily incremental dumps centralized on Ubuntu, date-traceable archives, and restore playbooks.
Highlights
- 9 VPS entities → 9 websites, 9 independent .sh backup scripts
- Daily incremental MySQL backups (per-entity retention)
- Centralized archive on one Ubuntu backup server
- Structured paths so every dump is traceable by entity & date
- Cron-driven automation — hands-off daily runs
- Restore playbooks designed for quick single-entity recovery
Outcomes
- Predictable daily backup rhythm across all entities
- One place to locate dumps by entity and date
- Faster single-entity recovery with documented playbooks
Impact
Replaced ad-hoc manual dumps with a predictable, auditable backup rhythm across all entities — one place to know where data lives and how to bring any system back online.