Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Automatic MySQL schema management with Skeema

Automatic MySQL schema management with Skeema

 26 April - 1:00 PM - 1:50 PM @ Ballroom A
Experience level: 
Beginner
Duration: 
50 minutes conference
Tracks:
Operations
Developer
Topics:
MySQL
Devops
Tools and Techniques

Description

Skeema (http://skeema.net) is a new open source CLI tool for managing MySQL schemas and migrations. It allows you to easily track your schemas in a repo, supporting a pull-request-based workflow for schema change submission, review, and execution. This session will introduce Skeema, walking through its functionality and usage. Attendees will learn how to: * Get started by exporting schemas to a Git repo * Diff changes in the schema repo against live DBs to automatically generate DDL * Manage multiple environments (dev, staging, prod) and easily keep them in sync * Configure Skeema to use pt-online-schema-change for performing online ALTER TABLE * Build a frictionless, collaborative, and safe schema change workflow for your company Skeema is designed for use by software engineers as well as DBAs, so this session will be relevant for all types of MySQL users, of any experience level.

Speakers

Evan Elias's picture

Evan Elias

Director of Engineering, Tumblr

Biography:

Evan is a software engineer and database automation expert based in New York City. He was originally engineer #4 at Tumblr, where he recently returned to direct several backend engineering teams. Previously he was a member of Facebook's MySQL Infrastructure team, where he deployed GTID to the world's largest MySQL fleet, and led development of the company's internal DBaaS platform. He has been using MySQL since 2003, and is the creator of two open source tools: Jetpants, a shard orchestration toolkit; and Skeema, a schema management system.

Share this talk