hard20 pts · first answer countsdatabase-migrationsdeployment-strategies

Renaming a column with zero downtime

You run rolling deployments, so old and new app versions run side by side for a while. You need to rename users.fullname to users.display_name. Which approach avoids errors?

A.Expand and contract: add display_name, deploy code that writes both and reads the new column, backfill data, switch all reads, then drop fullname in a later release.B.Run ALTER TABLE ... RENAME COLUMN in the same release as the code change.C.Rename the column first, then deploy the new code as fast as possible.D.Take the database offline for a short maintenance window; zero downtime is not possible.

Discussion 0

Join free to post in the discussion.

Renaming a column with zero downtime

Discussion 0

Related questions