←back to thread

Why AO3 Was Down

(www.reddit.com)
151 points danso | 2 comments | 05 Jul 25 02:23 UTC | HN request time: 0.413s | source
Show context
charcircuit ◴[05 Jul 25 06:12 UTC] No.44470460[source]▶
>to fix it they have to migrate the entire database to use a different type for bookmark IDs... except of course this will take a while because there are two Billion Of Them Lol

You can shard them between 2 tables. Then migrate them to a single one later.

replies(1): >>44470724 #
ohdeargodno ◴[05 Jul 25 07:17 UTC] No.44470724[source]▶
There's no SLA for Harry Styles porn. Run the migration, lock the table for two days and redo the same in 13 years when you get to 4 billion bookmarks.
replies(3): >>44470769 #>>44470884 #>>44471531 #
1. camel-cdr ◴[05 Jul 25 07:49 UTC] No.44470884[source]▶
> There's no SLA for Harry Styles porn

But what about my good night's sleep? How can I go to bed without reading about my favorite blorbos?

replies(1): >>44471006 #
2. ohdeargodno ◴[05 Jul 25 08:15 UTC] No.44471006[source]▶
Real ones use bookmarks to find them ag- ah, shit.

Real ones back them up in a single .txt file