Migrate a Local-Government Records System from MySQL to PostgreSQL
Overview
What this challenge is about.
Audit the MySQL schema (around 60 tables) for incompatibilities (case-folding identifiers, ENUM types, TIMESTAMP semantics, character sets). Plan a migration using pgloader for the bulk load and a custom dual-write shim during the cutover window. Test on a refresh of prod (anonymized). Validate row-count, checksum-by-table, and 12 spot-check queries. Deliver a 10-page migration plan, the pgloader configuration, the dual-write shim code, and a validation report.
The Brief
What you'll do, and what you'll demonstrate.
Plan, execute on staging, and validate a MySQL 5.7 to PostgreSQL 16 migration of a 2.4M-record system within a 4-hour cutover window.
Earning criteria — what you'll demonstrate
- Identify MySQL-to-PostgreSQL incompatibilities before they hit the migration
- Plan a dual-write cutover that minimizes service interruption
- Validate a multi-million-row migration with reproducible checks
- Document a migration plan well enough that ops can execute it
Program Fit
Where this fits in your program.
Sharpens the same skills your degree expects you to demonstrate.
Skills
Skills you'll demonstrate.
Each one shows up on your verified credential.
Careers
Roles this prepares you for.
Real titles. Real skill bridges. Pick the one closest to your trajectory.
Career mappings coming soon.