Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Migrating a Massive Legacy Database

Migrating a Massive Legacy Database

Lessons learned at SeatGeek when migrating a massive legacy MySQL database to Postgres

Avatar for José Lorenzo Rodríguez

José Lorenzo Rodríguez

July 27, 2020
Tweet

More Decks by José Lorenzo Rodríguez

Other Decks in Programming

Transcript

  1. AGENDA ▸ Moving offices ▸ The ecology of large systems

    ▸ On keeping track of what you know ▸ Profiting from the unexpected ▸ The perceived value of tests ▸ Aligning goals at the company level ▸ Profiting from the unexpected pt. 2 ▸ Rehearsals ▸ Announcing your intentions
  2. CENTRALIZED FACTS FROM A SINGLE DHALL REPRESENTATION WE… ▸ Created

    usage diagrams ▸ Sent automated pull requests to other teams ▸ Calculated progress reports ▸ Tracked tables that were migrated to other databases already ▸ Created terraform configuration for DMS
  3. ‣ Ordering issues ‣ Queries using GROUP BY ‣ Queries

    relying on case insensitivity ‣ Type mismatches WASTE ?