MySQL Migration to Google Cloud SQL

I led the migration of MySQL from a traditional LAMP stack onto Google Cloud SQL, redesigning the network architecture around it so both the AccuDash service system and the Furniture Academy platform run on GCP with strong performance and a healthy cost balance.

Outgrowing the LAMP Stack

Running MySQL on a traditional LAMP stack meant managing the database, the box under it, and the network around it by hand. Moving to Cloud SQL promised managed performance and resilience — but only if the surrounding network was redesigned to use it well and keep costs in check.

Physical server rack in a datacenter

What I Delivered

Database server hardware

LAMP → Cloud SQL

Migrated MySQL off the traditional LAMP stack onto managed Google Cloud SQL.

Network equipment and cabling setup

Network architecture redesign

Reworked the network around Cloud SQL for performance and proper isolation.

Clouds above a data center

Both platforms on GCP

Landed AccuDash and the Furniture Academy platform together on Google Cloud.

Piggy bank and calculator representing cost avoided

Cost-effective by design

Tuned the design to a strong net cost balance against pre-migration GCP spend.

Platforms on GCP
0
Core Deliverables
0
Skills & Tools
0
Technician with a laptop working on a server rack

The Impact

MySQL now runs on managed Google Cloud SQL behind a redesigned network, with both AccuDash and the Furniture Academy platform hosted on GCP — better database performance and resilience at a cost that pencils out.

Let Google Run the Database

Self-managed databases quietly tax every other project. Moving MySQL to Cloud SQL — and redesigning the network to match — handed the undifferentiated heavy lifting to Google and kept the bill honest, freeing attention for the work that actually moves the business.

Have a project like this?

Your database shouldn’t be the thing you worry about at 2am. Let’s move it to managed cloud.

More Projects

Coding workstation with a laptop
Web Development & Platforms

JDSileo.com Redesign & Platform Revamp

A ground-up revamp of my own platform: 123 case studies elevated into one design system, 170 branded archives, and a one-page site with a scored intake and live Teams booking — built AI-assisted with Claude Code (Opus & Fable).

Read More »