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. He works at GitHub on the database infrastructure team.

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