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

October 3-5, 2016

Amsterdam, Netherlands

Massive Schema Changes in Facebook

Massive Schema Changes in Facebook

 4 October 5:20 PM - 6:10 PM @ Matterhorn 2
Experience level: 
Advanced
Duration: 
50 minutes conference
Tracks:
MySQL
Topics:
MySQL
Python
Devops

Description

At Facebook, table schema changes are happening every second on our MySQL instances. To support the huge number of developers and instances we have, and to make the schema rollout process as seamless and stable as possible, we've built an automated system called AOSC (Automated Online Schema Change) to manage all of the relevant orchestration. Underneath it, we have a refined version of our previous open-source tool, called OSC (Online Schema Change), to take care of these changes for a single instance. This talk will be split into half: each part will cover one of the two systems mentioned above.

Speakers

Junyi Lu's picture

Junyi Lu

Production Engineer, MySQL Infrastructure, Facebook

Biography:

Junyi Lu is currently working at Facebook as a production engineer for the MySQL infrastructure. Responsible for developing automations which will manage tons of MySQL instances. Prior to this, he worked as a MySQL DBA at dianping.com, which is one of the biggest online-to-offline platforms in China.

Jesse Salomon's picture

Jesse Salomon

Software Engineer, Facebook

Biography:

Jesse is a Software Engineer at Facebook's Headquarters in Menlo Park, and primarily works with the MySQL Infrastructure team. He joined Facebook after graduating with a Computer Science degree from the California Institute of Technology.

Share this talk


Slides