4 ms·
This is not correct. Facebook has a large number of distinct MySQL tiers, which serve different purposes and have wildly different workloads. None of them are t
by evanelias 3y ago
This is not correct. Facebook has a large number of distinct MySQL tiers, which serve different purposes and have wildly different workloads. None of them are traditional "key-value lookup" workloads, not even the core user database (entities/associations); this k/v claim is often repeated here, but has never been an accurate representation of the architecture. The TAO graph access pattern absolutely requires range scans over indexes, which is not compatible with a k/v access pattern.
source: I'm a former member of one of Facebook's MySQL teams, and among other things I worked heavily on the managed database-as-a-service tier. This was like an internal-only RDS, used by thousands of engineers for many different purposes, most of which involved SQL.
- hnbad 3y agoI can only go by what FB people have told me in person and that was "we use MySQL pretty much just as a k/v store". I think all the people I talked to worked on the frontend rather than MySQL directly though, so if you worked with MySQL directly that seems more authoritative.
- hu3 3y agoThank you for sharing your experience and expertise. I'm a big fan of MySQL's scaling properties and some of the tooling (Vitess). Do you see any emergent general purpose RDBMS achieving similar popularity of MySQL and/or PostgreSQL in the near future? I heard good things about Clickhouse but it's a different tool (column based) from my understanding.
- evanelias 3y agoI am not a good judge of popularity, given that I still post a lot about MySQL on HN in the year 2024 :) In all seriousness though, as a bootstrapped founder I'm not usually able to devote time to tinkering with emergent databases, sorry! From what I've heard, Clickhouse is excellent, but it is OLAP focused rather than OLTP.
- hu3 3y agoAhh I see now, you've founded https://github.com/skeema/skeema https://github.com/skeema/skeema which is great! Keep it up!
- ksec 3y ago>given that I still post a lot about MySQL on HN in the year 2024 :) Not nearly enough So please do that more often :) Seriously I dont want HN to be one sided about RMDBS and I constantly submit a lot of MySQL related content and release notes. And there is still a whole world using MySQL for a lot of different reasons. Especially now Oracle has finally updated MySQL release schedule.
- ksec 3y ago>The TAO graph access pattern Do they still use TAO? Just wondering if they will ever open source TAO.