Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

One System to Fit Them All: Shared MySQL Hosting at Facebook

One System to Fit Them All: Shared MySQL Hosting at Facebook

 25 April - 11:30 AM - 12:20 PM @ Ballroom F
Experience level: 
50 minutes conference
Tools and Techniques


MySQL is by far the most common choice among Facebook engineering teams when they are looking for a persistent data store for their product or application. Not all of this data goes into the "Facebook Graph" as not everything developed inside Facebook applies to a user or something they are sharing. This creates a lot more unique use cases of MySQL inside Facebook than one team can operationally optimize for. Today several mission critical services depend on these unique databases including video encoding, many of the data processing pipelines and our long-term archival storage systems. XDB is the internal "database as a service" system for Facebook, and in this talk we will explore what it takes to support all these use cases in one fully automated infrastructure to the production scale and quality we require. We will discuss the extra automation capabilities and features that XDB provides and our vision for its upcoming capabilities. We will also share some of the war stories that taught us what unique problems we needed to solve.


Andrew Regner's picture

Andrew Regner

MySQL Infrastructure Production Engineer, Facebook


Andrew is a Linux generalist that loves to work on large scale distributed systems. He works on Facebook's MySQL Infrastructure team and is focused on operational efficiency of both humans and servers. This is done by building new software robots that take over more and more of his co-worker's jobs from them, and mediating the arguments that these young and sometimes overly opinionated robots get into.

Share this talk