Versions Compared

Key

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

...

Panel

Summary

Uses pt-online-schema-change in order to add or drop columns.

Current Version

1.1.01

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

...

News

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

 

Attachments

Readme

Supported Databases

...

  • Liquibase 3.2.0 (liquibase-percona 1.0.0)
  • Liquibase 3.3.0 (liquibase-percona 1.1.01)

Example

This changeset

Code Block
languagexml
<changeSet id="2" author="Alice">
    <addColumn tableName="person">
        <column name="address" type="varchar(255)"/>
    </addColumn>
</changeSet>

...

pt-online-schema-change --alter="ADD COLUMN address VARCHAR(255)" --alter-foreign-keys-method=auto --host=127.0.0.1 --port=3306 --user=root --password=** --execute D=testdb,t=person

...

Using / Installing the extension

Download

The jar files can be downloaded manually from maven:
http://repo1.maven.org/maven2/com/github/adangel/liquibase/ext/liquibase-percona/

Command line liquibase

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

...

<project>
    <dependencies>
        <dependency>
            <groupId>com.github.adangel.liquibase.ext</groupId>
            <artifactId>liquibase-percona</artifactId>
            <!-- use 1.0.0 or 1.1.01 -->
            <version>1.1.0<1</version>
            <scope>runtime</scope>
        </dependency>
    </dependencies>
</project>

...

This means, you are trying to use version 1.1.0 1 of the extension with liquibase 3.2.x. This is an unsupported combination. For Liquibase 3.2.x, you'll need to use liquibase-percona 1.0.0

...