Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

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

Sponsor Percona Live Open Source Database Conference

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

 25 April - 2:20 PM - 3:10 PM @ Ballroom D
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Operations
Topics:
MySQL
Devops
Tools and Techniques

Description

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

Speakers

Jonah Berquist's picture

Jonah Berquist

Database Infrastructure, GitHub

Biography:

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