News for hackers. Stuff that matters.
Re:Why Uber Engineering Switched from Postgres to MySQL by 0xmohit on Tuesday July 26, 2016 @12:37PM (#12166836)
Facebook maintains it's own fork [0] of MySQL. A couple of interesting talks are also available: MySQL at Facebook, Current and Future [1] and Massively Distributed Backup at Facebook Scale [2].

[0] https://github.com/facebook/mysql-5.6

[1] https://www.youtube.com/watch?v=jqwegP9xwVE

[2] https://www.youtube.com/watch?v=UBHcmP2TSvk

Re:Why Uber Engineering Switched from Postgres to MySQL by raverbashing on Tuesday July 26, 2016 @12:42PM (#12166893)
"its own fork"

And yes, MySQL has a lot of problems, but it seems to be better for "seat of the pants" usage (that is, when you don't need too many SQL capabilities and wants to use it mostly as a data store)

Re:Why Uber Engineering Switched from Postgres to MySQL by lazyant on Tuesday July 26, 2016 @12:55PM (#12167009)
from what I understand FB uses Mysql as permanent storage, not as relational database
Re:Why Uber Engineering Switched from Postgres to MySQL by yeukhon on Tuesday July 26, 2016 @02:00PM (#12167532)
I believe they use it for almost everything. They built all the graphs on top of MySQL data. I don't know what permanent storage is, but if you are referring to storing images and videos, I doubt. Highly doubt that. They may be storing pointers, but as a file system, I doubt. But I wouldn't know for sure, I don't work there. Oh, they do have Cassandra (well they built Cassandra)...
Re:Why Uber Engineering Switched from Postgres to MySQL by jhartmann on Tuesday July 26, 2016 @02:46PM (#12167889)
They use a system called haystack for binary large object storage. They very much don't use mysql for those.
Re:Why Uber Engineering Switched from Postgres to MySQL by yeukhon on Tuesday July 26, 2016 @02:50PM (#12167910)
That's my feeling they wouldn't use MySQL as a blob store.
Re:Why Uber Engineering Switched from Postgres to MySQL by midom on Tuesday July 26, 2016 @02:42PM (#12167862)
technically, it is a patch set, it gets frequently rebased against the upstream
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.
Re:Why Uber Engineering Switched from Postgres to MySQL by otterley on Tuesday July 26, 2016 @06:41PM (#12169278)
And so does Yahoo, and Google, and...