数据库migration方案

2018-11-06 本文已影响0人木木_bfe8

构建工具 maven + flyway

maven配置

maven properties

<properties>
    <flyway.version>5.2.3</flyway.version>
     <!-- Properties are prefixed with flyway. config db user and password  -->
    <flyway.user>admin</flyway.user>
    <flyway.password>123456</flyway.password>
</properties>

依赖

    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.12</version>
    </dependency>

    <!-- https://mvnrepository.com/artifact/org.flywaydb/flyway-core -->
    <dependency>
        <groupId>org.flywaydb</groupId>
        <artifactId>flyway-core</artifactId>
        <version>${flyway.version}</version>
    </dependency>

插件

      <plugin>
            <groupId>org.flywaydb</groupId>
            <artifactId>flyway-maven-plugin</artifactId>
            <version>${flyway.version}</version>
            <configuration>
                <driver>com.mysql.cj.jdbc.Driver</driver>
                <!--<url>jdbc:mysql://rm-2ze60619v9lm8497dfo.mysql.rds.aliyuncs.com:3306/cwag_flyway</url>-->
                <url>jdbc:mysql://192.168.31.186:3306/cwag_flyway?useUnicode=true&amp;characterEncoding=utf-8&amp;useSSL=false&amp;serverTimezone=GMT%2B8</url>
                <table>flyway_schema_history</table>
            </configuration>
        </plugin>