←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.259s | 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. kijin ◴[05 Jul 25 07:28 UTC] No.44470769[source]▶
In 13 years, the Unix timestamp will probably be a much bigger problem.