Demo: renaming a column under live traffic
On This Lesson 3 topics
This lesson is planned. The outline below lists the topics it will cover. The full lesson has not been published yet.
In this lesson
rename customer.name to full_name with zero failed requests.
Draft outline details
Step by step
- Start a load test hitting customer endpoints; baseline error count is zero.
- Release 1: Flyway adds
full_name(nullable); app writes both columns, readsname. - Run the batched backfill; verify with a count of rows where the columns differ.
- Release 2: app reads
full_nameand still writes both. - Planned mistake: run
ALTER TABLE ... RENAME COLUMNdirectly; the load test shows errors from old instances. Show it, restore, and continue with the safe path. - Release 3: stop writing
name; later Release 4 drops it. The load test reports zero failures.
Prepares MID-020-LAB1.
Check your understanding
At which release can the old column finally be dropped?
Show answer
After no running version reads or writes it.
Practice
Apply this lesson with the module's lab, exercises and quiz.
Marking a lesson complete is optional and you can undo it any time. Your progress stays in this browser.