“You can have parallel run jobs... you do the schema migration, and it's called blue-green swap, and you swap the tables once it's ready”

Sahil Walia · Software Engineering Radio - the podcast for professional software developers · Sahil Walia on Schema Changes and Data Migrations

Play from 15:04
15:04

Audio streams from the publisher’s own feed. Verbatim does not host or copy it.

What was described

run parallel jobs that write to a new table while the old table continues serving, then swap tables (blue-green swap) to apply schema changes without downtime

Said nearby on the same subject

“We get a group of people, hopefully in the same room and around tables… eight tables of like five people”
BS
Ben Shore
Lawyerist Podcast ·
How they work 8 tables, 5 people each Share this moment
“When you do alter table on a large table, it acquires an exclusive lock, and what happens is when you're doing that alter, it blocks all the region”
SW
Sahil Walia
Software Engineering Radio - the podcast for professional software developers ·
Hard number Share this moment
“You will write ahead logs in Postgres or binlog in MySQL… replay the changes into a new system when the new schema… essentially zero application code changes.”
SW
Sahil Walia
Software Engineering Radio - the podcast for professional software developers ·
Why it worked Share this moment
“You have to upscale your team… so you can earn your seat at that table… understand the data… orchestrate it on your own without needing IT”
BV
Brenno Valerio
The Agile Brand with Greg Kihlström® | What CMOs Need to Know About Marketing Technology, AI & CX ·
Why it worked Share this moment

Moments like this, every Monday

The strongest new moments on your topics, in the speakers' own words. Free for three topics.

No card. No password. One-click unsubscribe.

Track a competitor?

Pro watches up to 25 names or phrases and emails you the morning after they are said.

See Pro, $29 a month

Verbatim quotes a short extract and links to the episode; the episode belongs to its publisher. Remove a show.