Re:Reddit's photo albums broke due to Integer overflow of Si...
by duskwuff on Tuesday December 13, 2022 @06:47PM
(#33977986)
Twitter didn't always use Snowflake -- that was introduced in November 2010. There was another, much simpler algorithm used before that which generated much smaller IDs (e.g. under 3e10).
[ Parent
| on HN ]
Re:Reddit's photo albums broke due to Integer overflow of Si...
by liquidgecka on Tuesday December 13, 2022 @06:51PM
(#33978012)
Yea.. "auto increment" in mysql. it SUCKED in so many ways, primary of which was that it required a single mysql database to be the primary for all tweet writes. Every tweet just incremented a counter by 1. As we scaled up that server got overloaded rapidly and became a huge single point of failure. Snowflake was introduced to solve several problems at once. =)