What are zero-downtime database migration patterns that I should learn before starting my first software engineering job?
Download run
Fan-out diagram
The searches the AI actually ran for this prompt.
SEED QUERY
What are zero-downtime database migration patterns that I should learn before starting my first software engineering job?
1 real search · 1 real-search pass
zero downtime database migrations expand contract online schema changes PostgreSQL concurrent index creation MySQL online DDL gh-ost pt-online-schema-change best practicesGoogle ↗
OBSERVEDInstruction
Badge and edge weight = share of passes that produced the query. Hover a query for its intent and routing format.
Query classes
Google's semantic query class for every sub-query: what kind of answer each search is after, simulated vs real.
ChatGPT real searches (1)
Classes come from the query-classifier (a local Laya model). 1 of 1 calls are low-confidence (under 50%) — hover a query in the table to see its confidence.
Searches and sources
ChatGPT1 real searches · gpt-6
zero downtime database migrations expand contract online schema changes PostgreSQL concurrent index creation MySQL online DDL gh-ost pt-online-schema-change best practices Google ↗
- How to make database schema changes without downtime in MySQL · red-gate.com
- Zero-Downtime Schema Evolution Patterns · zero-downtime-schema.com
- Zero-Downtime Database Migration: A Practical Guide · erzon.com
- GitHub repository · github.com
- Documentation · docs.percona.com
- GitHub repository · github.com
- Documentation · documentation.red-gate.com
- Online Schema Change Tools: gh-ost, pt-osc, pg_repack · zero-downtime-schema.com
- Parallel Change · martinfowler.com
- Engineering articles · github.blog
- CREATE INDEX documentation · postgresql.org
- GitHub repository · github.com
Queries
1 queries · click a column to sort