←back to thread

Why AO3 Was Down

(www.reddit.com)
151 points danso | 1 comments | 05 Jul 25 02:23 UTC | HN request time: 0.26s | 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. 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.