Backend · Mid-level · Theory

You need to rename a column in a large table, and the service deploys without downtime via rolling updates. How would you carry out this change?

~4 min by voice

How to approach it

This checks whether the candidate understands that during a rolling deploy the old and new code work against the same DB schema at the same time, and whether they can carry out an incompatible schema change via expand/contract without downtime or locking, and with the ability to roll back.

Have you seen this question in a real interview?

Answers0

Avg. score—

Strong—

Practiced0

Topics

ci cd database migrations deployment

Similar questions

A Django monolith can no longer keep up with growing traffic. How would you design how it runs in production: the application server, the worker model, the number of workers, and working with the database? Mid-level You have two thousand end-to-end tests, a full run takes three hours, and developers have stopped waiting for the results. How would you restructure testing in CI? Senior After a deploy, some users keep seeing the old version of the SPA or get a blank white screen. How would you configure caching so this doesn't happen? Mid-level What is CI/CD, and what steps does a pipeline for a backend service usually consist of? Junior You need to rename a column in a large table that a service is actively using under load, and do it with zero downtime. How would you run the migration and the deployment? Senior

Answer by voice

The interviewer will ask this question and listen. Think out loud and ask for a hint if you need one. When you're done, pause or tap “That's my answer”. In about a minute, your score and the points you covered show up here.

Best with headphones · ~4 min