News for hackers. Stuff that matters.

A comment on Pinterest's simple tech stack to scale to 11M monthly users. Parent comment

Re:Pinterest's simple tech stack to scale to 11M monthly users by koliber on Saturday December 23, 2023 @10:28AM (#38744876)
Do they have only one huge table in the db that contains all of their entities? From the key structure that seems reasonable: shard id, type, object id.

If that is the case, is a relational db still the right place to keep such data? It seems that if the goal is to store this kind of data in one or a few huge sharded tables, a different tool could be optimizing to do the job better.

It seems that I’m missing something…

[ Parent | on HN ]
Re:Pinterest's simple tech stack to scale to 11M monthly users by rwultsch on Saturday December 23, 2023 @10:48AM (#38745066)
A pin was a 1.2 KB json blob. There were other tables but pins was the big one. Why MySQL? It did not destroy data like the alternatives.

how storage became efficient https://medium.com/pinterest-engineering/evolving-mysql-comp... https://medium.com/pinterest-engineering/evolving-mysql-comp...

[ Parent | on HN ]