Versions Compared

Old Version 14

changes.mady.by.user Andreas Dangel

Saved on

compared with

New Version 15

changes.mady.by.user Andreas Dangel

Saved on

Key

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

...

Panel


Summary

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 instead of SQL. This allows to perform a non-locking database upgrade.

Current Version

1.3.01

Author

Andreas Dangel (adangel [at] users.sourceforge.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


...

October 19, 2014

1.0.0

  • compatible with liquibase 3.2.x
November 6, 20141.1.0
  • compatible with liquibase 3.3.0
July 26, 20151.1.1
  • Fixed #1: Tables with foreign keys
April 2, 20161.2.0
  • Fixed #2: Adding indexes via pt-online-schema-change
  • Fixed #3: Altering column data types via pt-online-schema-change
  • Added configuration property "liquibase.percona.skipChanges"
  • Upgraded liquibase to 3.4.2
September 13, 20161.2.1
  • PR #4: Allow passing additional command line options to pt-online-schema-change
  • PR #5: Support afterColum attribute
December 18, 20161.3.0
  • Upgraded liquibase to 3.5.3
  • Support for MySQL Connector 6.0.x in addition to 5.1.x.
  • Fixed #7: Foreign key constraints of AddColumn is ignored
  • Fixed #8: Support addForeignKeyConstraintChange, addUniqueConstraintChange
  • Fixed #9: Support for enabling pt-online-schema-changes on a per-change basis
  • Fixed #10: Build fails with java7: UnsupportedClassVersion when running DatabaseConnectionUtilTest.testGetPasswordMySQL_6
July 21, 20171.3.1
  • Fixed
#12: Cannot run migrations with the percona extension on a Spring Boot app with embedded Tomcat


Attachments

Readme

Supported Databases

...

  • Liquibase 3.2.0 (liquibase-percona 1.0.0)
  • Liquibase 3.3.0 (liquibase-percona 1.1.1)
  • Liquibase 3.3.5 and 3.4.2 (liquibase-percona 1.2.1)
  • Liquibase 3.3.5, 3.4.2, and 3.5.3 (liquibase-percona 1.3.01)

Supported Changes and examples

...

After extracting the zip file of liquibase, place liquibase-percona-1.3.01.jar file in the sub directory lib. The shell script liquibase / liquibase.bat will automatically pick this up and the extension is available.

...

<dependency>
    <groupId>com.github.adangel.liquibase.ext</groupId>
    <artifactId>liquibase-percona</artifactId>
    <version>1.3.0<1</version>
</dependency>

Using snapshots

...

And just use the latest SNAPSHOT version for liquibase-percona dependency, e.g. 1.34.10-SNAPSHOT:

<dependency>
    <groupId>com.github.adangel.liquibase.ext</groupId>
    <artifactId>liquibase-percona</artifactId>
    <version>1.34.10-SNAPSHOT</version>
</dependency>

...