Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

gh-ost: triggerless, painless, trusted online schema migrations

gh-ost: triggerless, painless, trusted online schema migrations

 25 April - 2:20 PM - 3:10 PM @ Ballroom D
Experience level: 
50 minutes conference
Tools and Techniques


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


Jonah Berquist's picture

Jonah Berquist

Database Infrastructure, GitHub


Jonah is the Engineer Manager of the Database Infrastructure team at GitHub. He has worked in a diverse set of environments. His previous job was as a Senior DBA at Twitter and he had humble beginnings working as a remote DBA for a variety of customers at Blue Gecko. He enjoys looking at graphs and writing scripts to do his job for him.

Share this talk