News for hackers. Stuff that matters.
Re:Why Uber Engineering Switched from Postgres to MySQL by pluma on Tuesday July 26, 2016 @05:34PM (#12168885)
Technically they use it as a dumb key-value storage.
Re:Why Uber Engineering Switched from Postgres to MySQL by philliphaydon on Wednesday July 27, 2016 @12:32AM (#12170540)
There was a great talk from a FB engineer who talked about using MySQL as a key-value store, then another engineer posted a blog about how they use MySQL and queries and joins etc, I asked about the video and he got super defensive and said it was wrong and the guy had no idea what hes talking about.

It really put me off ever wanting to even consider working at Facebook.

Digging around I can't find either the blog or video :(

Re:Why Uber Engineering Switched from Postgres to MySQL by pluma on Wednesday July 27, 2016 @11:36AM (#12173661)
I've talked to several Facebook devs who confirmed to me that FB primarily uses MySQL as a key-value store (e.g. this is why GraphQL makes so much sense for them). They were quick to point out however that of course they don't know everything FB does.

The problem with making absolute statements about what FB does is that it seems to be structured as a large number of mostly independent teams that are free to choose and develop whatever technology they need to solve their problems. There's actually a talk about scaling by a FB dev (don't have the link right now) that uses this as an example for what it means when they talk about "Facebook scale" (another example is that their monorepo outgrew git so they created their own extension to mercurial instead).

It's entirely possible that the main use of MySQL at FB is as a key-value store while at the same time there are small parts of applications using it with plain old queries and joins.

Re:Why Uber Engineering Switched from Postgres to MySQL by philliphaydon on Wednesday July 27, 2016 @11:16PM (#12178112)
Ahh yeah good point. FB's scale is very interesting, it's like we solved scalability then FB came along and was like, ah crap we need to resolve scalability. And different teams are solving their own problems different ways.