How To Migrate MySQL Database Using Flyway - MySQL Database Created Via createDatabaseIfNotExist
Note: For production, don't rely on hibernate.ddl-auto (or counterparts) to export schema DDL to the database. Simply remove (disable) hibernate.ddl-auto or set it to validate. Rely on Flyway or Liquibase.
Description: This application is an example of migrating a MySQL database via Flyway when the database exists (it is created before migration via MySQL specific parameter, createDatabaseIfNotExist=true).
Key points:
- for Maven, in
pom.xml, add the Flyway dependency - remove (disable)
spring.jpa.hibernate.ddl-autoor set it tovalidate - in
application.properties, set the JDBC URL as follows:jdbc:mysql://localhost:3306/bookstoredb?createDatabaseIfNotExist=true - each SQL file containing the schema update add it in
classpath:db/migration - each SQL file name it as
V1.1__Description.sql,V1.2__Description.sql, ...
| If you need a deep dive into the performance recipes exposed in this repository then I am sure that you will love my book "Spring Boot Persistence Best Practices" | If you need a hand of tips and illustrations of 100+ Java persistence performance issues then "Java Persistence Performance Illustrated Guide" is for you. |
|
|
|
