Comment

Comment by mighty_warrior

They maintained a replication process across both tables as they updated the read processes before updating the write process. Say for whatever reason their offline replication process broke for 2 hours. For those 2 hours of downtime that replication is broken, the system is reading from a table that is not in sync with the table that is receiving writes. At that point you are displaying incorrect subscription data to your customers.

Discussion

Live from the official Hacker News API

A modern reader for Hacker News · SvelteKit + Skeleton