Awesome

shift <img src="/ui/public/logo.png" height="40">

shift is an application that makes it easy to run online schema migrations for MySQL databases <img src="/ui/screenshots/summary.png">

Who should use it?

shift was designed to solve the following problem - running schema migrations manually takes too much time. As such, it is most effective when schema migrations are taking up too much of your time (ex: for an operations or DBA team at a large organization), but really it can be used by anyone. As of writing this, shift has had no problem running hundreds of migrations a day or running migrations that take over a week to complete.

Features

safe, online schema changes (invokes the tried-and-true pt-online-schema-change)
- supports all "ALTER TABLE...", "CREATE TABLE...", or "DROP TABLE..." ddl
a ui where you can see the status of migrations and run them with the click of a button
self-service - out of the box, any user can file and run migrations, and an admin is only required to approve the ddl (this is all configurable though)
shard support - easily run a single migration on any number of shards

Components

shift consists of 3 components. Each component has its own readme with more details

ui: a rails app where you can file, track, and run database migrations
runner: a go agent that consumes jobs from an api exposed by the ui
pt-osc patch: a patch for pt-online-schema-change from the percona toolkit

Demo

Watch a demo video here

Installation

Read the installation guide here