Massive Schema Changes in Facebook
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.
Production Engineer, MySQL Infrastructure, Facebook
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.
Software Engineer, Facebook
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.