Skip to content

lefred/online-migration

Repository files navigation

Note: I've reset the merge from Gaëtan Denaisse as it brakes some of my usage. I'll review it more carrefully and merge later. I'll also make it compatible with last mysql-utilities

online-migration

This is a script to keep track of database schema. It helps to check and migrate to a new version of the schema and rollback if necessary.

It uses pt-online-schema-change as backend (http://www.percona.com/doc/percona-toolkit/2.2/pt-online-schema-change.html) and Oracle MySQL utilities (http://dev.mysql.com/doc/workbench/en/mysql-utilities.html).

Requirements:

  • pt-online-schema-change
  • mysql-utilities (1.3.3)
  • mysql-connector-python
  • mysql client
  • perl-DBI (dependency of pt-online-schema-change)
  • perl-DBD-MySQL (dependency of pt-online-schema-chane)

Puppet:

A new type (mysql_schema) and its provider as been added to the project

Extra:

Currently rollback the addition of foreign keys doesn't work because foreign keys are not copied with mysqldbcopy see http://bugs.mysql.com/bug.php?id=63783

A bug in pt-online-schema-change fails the example with the world database, see https://bugs.launchpad.net/percona-toolkit/+bug/1207186

Copyrights:

GPLv2 all rights reserved to Frédéric Descamps <lefred@lefred.be>

About

MySQL schema versioning and migration management utility

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published