MySQL at Facebook

Posted on In QA

Facebook uses lots MySQL databases. Any information about how Facebook scales MySQL?

Some information on the Web:

MySQL at Facebook’s page https://www.facebook.com/MySQLatFacebook?filter=1

A post by Ryan Thiessen, Database Operations at Facebook on Quora: http://www.quora.com/Facebook-Engineering/How-does-Facebook-structure-MySQL-so-that-it-is-robust-and-scalable

And more:

http://mashable.com/2011/12/15/facebook-timeline-mysql/

http://gigaom.com/2011/12/06/facebook-shares-some-secrets-on-making-mysql-scale/

http://www.wired.com/wiredenterprise/2011/12/facebook-timeline-anatomy

“A lot of people are surprised that for this shiny new thing for
Facebook, we’re using MySQL,” Piantino says. “We treat [MySQL] as a
generic engine for data manipulation. We use it as a storage engine.
And it’s really efficient.”


In 2008, Piantino saw a presentation by an engineer from InnoDB — an
outfit that does storage engines for MySQL. He remembers thinking that
if he was ever trying to solve the problem of finding data on disk,
there “wasn’t a chance” he’d come up with a better way than the engine
InnoDB had built for MySQL.



http://gigaom.com/2011/07/21/is-stonebraker-right-why-sql-isnt-the-choice-du-jour-for-many-apps/

Leave a Reply

Your email address will not be published. Required fields are marked *