Versions Compared

Old Version 10

changes.mady.by.user Andreas Dangel

Saved on

compared with

New Version 11

changes.mady.by.user Andreas Dangel

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview

Panel

Summary

Uses Extension to support the tool pt-online-schema-change from Percona Toolkit. This extension replaces a couple of the default changes to use pt-online-schema-change in order to add or drop columns instead of SQL. This allows to perform a non-locking database upgrade.

Current Version

1.2.0

Author

Andreas Dangel (adangel [at] users.sf.net)

Issue Tracking

https://github.com/adangel/liquibase-percona/issues

Source Repository

https://github.com/adangel/liquibase-percona.git

Maven Coordinates

com.github.adangel.liquibase.ext:liquibase-percona

Supported Database

MySQL

...

MySQL is the only supported database. The extension checks whether it is being run against a MySQL database. If not, it falls back to the default AddColumn/DropColumn change of changes provided by liquibase-core.

Liquibase version(s) tested against

...

The following changes are supported:

AddColumn

Since: liquibase-percona 1.0.0

...

pt-online-schema-change --alter="ADD COLUMN address VARCHAR(255)" ...

CreateIndex

Since: liquibase-percona 1.2.0

...

pt-online-schema-change --alter="ADD UNIQUE INDEX emailIdx (email)" ...

DropColumn

Since: liquibase-percona 1.0.0

...

pt-online-schema-change --alter="DROP COLUMN age" ...

DropIndex

Since: liquibase-percona 1.2.0

...

pt-online-schema-change --alter="DROP INDEX emailIdx" ...

ModifyDataType

Since: liquibase-percona 1.2.0

...

Simply run mvn clean verify. You'll find the jar-file in the target/ subdirectory.

Integration testing

In order to execute the integration tests, run mvn clean verify -Prun-its.

...