Percona Live: Open Source Database Performance Conference - Amsterdam 2016 Logo

October 3-5, 2016

Amsterdam, Netherlands

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

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

 4 October 3:10 PM - 4:00 PM @ Matterhorn 2
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Operations and Management
MySQL
Topics:
MySQL
Tools and Techniques
Sharding

Description

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.

Speakers

Andrew Regner's picture

Andrew Regner

MySQL Infrastructure Production Engineer, Facebook

Biography:

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


Slides