Introducing gh-ost: triggerless, painless, trusted online schema migrations
gh-ost is a new tool by GitHub which changes the paradigm of MySQL online schema changes, designed to overcome today's limitations and difficulties in online migrations. gh-ost is: - Triggerless: no triggers placed; - Pausable: can suspend master writes altogether - Lightweight: makes a low impact on the master database - Controllable: one can interact with an executing gh-ost process, get info and reconfigure parameters - Testable: gh-ost allows for testable, safe, non obtrusive migrations in production - Designed to allow for multiple concurrent migrations In this session we will: - Introduce gh-ost, explain the reasoning for developing a new tool - Describe the underlying logic - Compare with existing online schema change tools - Show off extra perks that make gh-ost operations so friendly - Discuss the roadmap and present with surprising implications gh-ost is open sourced under the MIT license
Senior Infrastructure Engineer, GitHub
Shlomi is an engineer and a database geek. He is an active MySQL community member, authors gh-ost, orchestrator, common_schema and other open source tools, and blogs at http://openark.org. Shlomi is recipient of Oracle ACE, Oracle Technologist of the Year, and MySQL Community Member of the Year awards.
Sr. Database Infrastructure Engineer - MySQL, GitHub
Tom has been working with MySQL since 2003. He started working with MySQL as a PHP developer. He briefly moved over to systems administration where he was responsible for Apache and MySQL servers. His desire to learn more about databases moved him into a role as a DBA and he's happily filled that role at several companies. He is currently working at GitHub helping automate and expand their existing architecture. He's previously worked for Box, Twitter, & Booking.com.