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

October 3-5, 2016

Amsterdam, Netherlands

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

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

 5 October 11:20 AM - 12:10 PM @ Matterhorn 2
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
MySQL
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

Shlomi Noach's picture

Shlomi Noach

Senior Infrastructure Engineer, GitHub

Biography:

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.

Tom Krouper's picture

Tom Krouper

Sr. Database Infrastructure Engineer - MySQL, GitHub

Biography:

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.

Share this talk


Slides