←back to thread

Why AO3 Was Down

(www.reddit.com)
151 points danso | 5 comments | 05 Jul 25 02:23 UTC | HN request time: 0.206s | 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 #
1. 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 #
2. kijin ◴[05 Jul 25 07:28 UTC] No.44470769[source]▶
In 13 years, the Unix timestamp will probably be a much bigger problem.
3. 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 #
4. 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

5. rsynnott ◴[05 Jul 25 10:02 UTC] No.44471531[source]▶
I mean I’d assume they went for a 64bit integer. In a few million years, people who are into weird porn about whatever the temporally local equivalent of Harry Styles is (probably some sort of robot) will once again be mildly inconvenienced.