Rename a column live

  • Order
  • Store 12

Difficulty 2 of 5

Rename a live column while old and new application versions overlap. Put the migration steps in a safe order. Assume the initial backfill can be repeated to catch changes before the read switch.

Play level

Put these steps in order

  • Verify data, then switch all readers
  • Add the new nullable column
  • Stop old writes and remove the old column
  • Write both columns and finish the catch-up pass
  • Backfill existing rows with a repeatable job
Tables join, documents copyTap or press Space to switch between tables and documents

Goals and limits

p99 latency
under 200 ms
Monthly cost
under 100 USD/mo
Traffic
100 req/s

Concepts

How players did

Player results load from the server.

All levels