[Verse 1] Started with MySQL but we need to grow PostgreSQL's calling, time to make the flow Schema translation's where we begin the fight Auto increment becomes sequences tonight Character sets and collation rules will change Type mappings need a careful rearrange [Chorus] Migrate, transform, keep it running clean Zero downtime is the platform dream Shadow databases and dual writes in sync ETL patterns help us cross the bridge we think Schema, data, zero-down, report Migration engineering, our platform support [Verse 2] Dirty data lurks in every table row ETL patterns help us make it flow Referential integrity must survive the move One relation at a time, we'll find our groove Foreign keys and constraints need special care Transform the data, keep relationships there [Chorus] Migrate, transform, keep it running clean Zero downtime is the platform dream Shadow databases and dual writes in sync ETL patterns help us cross the bridge we think Schema, data, zero-down, report Migration engineering, our platform support [Bridge] Feature flags control the cutover dance Shadow database gives us second chance When the traffic flows to PostgreSQL side Looker's ready with the business guide Explores and dimensions, measures that shine LookML semantic models, data by design [Verse 3] Pgloader makes the heavy lifting light AWS DMS handles day and night Custom scripts for edge cases we create Validation strategies seal our data fate From platform engineering to reporting layers We build the tools that every team shares [Chorus] Migrate, transform, keep it running clean Zero downtime is the platform dream Shadow databases and dual writes in sync ETL patterns help us cross the bridge we think Schema, data, zero-down, report Migration engineering, our platform support [Outro] Production ready, battle tested and true Database migration is what platform engineers do From MySQL to PostgreSQL we've made our way Looker tells the story of our data every day
← Scala & JVM Ecosystem | SDK Design & Developer Experience →