Advanced System Design Fundamentals
0% completed
Dual-Write and Backfill
A food delivery app stores each customer's phone number exactly as the customer typed it. Couriers now need to text customers, and the text service accepts only E.164, the international standard format for phone numbers. For this reason, a new column must hold each number in that format.
phone (as typed) | phone_e164 (new) |
|---|---|
| (555) 010-2477 | +15550102477 |
| 555.010.2477 | +15550102477 |
| empty | empty |
The customers table has about 40 million rows and takes about 300 writes a second. These numbers are made-up examples
.....
.....
.....
Like the course? Get enrolled and start learning!
Reading Progress
0%