How To Auto-Create And Migrate Two Databases In MySQL Using Flyway

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 auto-creating and migrating two databases in MySQL using Flyway. In addition, each data source uses its own HikariCP connection pool. In case of MySQL, where a database is the same thing with schema, we create two databases, authorsdb and booksdb.

Key points:

• for Maven, in pom.xml, add the Flyway dependency
• remove (disable) spring.jpa.hibernate.ddl-auto or set it to validate
• in application.properties, configure the JDBC URL for booksdb as jdbc:mysql://localhost:3306/booksdb?createDatabaseIfNotExist=true and for authorsdb as jdbc:mysql://localhost:3306/authorsdb?createDatabaseIfNotExist=true
• in application.properties, set spring.flyway.enabled=false to disable default behavior
• programmatically create two DataSource, one for booksdb and one for authorsdb
• programmatically create two FlywayDataSource, one for booksdb and one for authorsdb
• programmatically create two EntityManagerFactory, one for booksdb and one for authorsdb
• for booksdb, place the migration SQLs files in db\migration\booksdb
• for authorsdb, place the migration SQLs files in db\migration\authorsdb

---

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.

---