Flyway Articles
4 articles about Flyway. Explore Spring Boot implementation, design, and operations across related topics.
-
How to Introduce baselineOnMigrate for an Existing Database with Spring Boot + Flyway - Initializing baselineVersion and flyway_schema_history
Explains the procedure for introducing Flyway after the fact into a database that is already running with existing tables. Covers the baselineOnMigrate, baselineVersion, and baseline-description settings, separate configuration on the Gradle/Maven plugin side, dry-run verification using flyway info, the mechanism behind the initial baseline marker row created in flyway_schema_history, and the staging verification procedure, all explained with implementation code.
-
How to Fix "Validate failed" / "checksum mismatch" in Spring Boot + Flyway - flyway repair and Production Recovery Steps
Explains the recovery steps for a Spring Boot app that fails to start due to Flyway's Validate failed: Detected failed migration or checksum mismatch errors. Covers the correct usage of flyway repair, why it should not be run carelessly in production, and manual fixes to the flyway_schema_history table, organized in a reverse-lookup format.
-
How to Connect Spring Boot to MySQL - application.yml Configuration, JDBC URL Parameters, and Time Zone/Character Encoding Pitfalls
A step-by-step guide to connecting Spring Boot 3.x to MySQL 8, covering Docker Compose startup, application.yml configuration, and connectivity checks. Also covers recommended JDBC URL parameter values and how to fix the Public Key Retrieval error, date/time offsets, and utf8mb4 garbled characters.
-
Database Migration Management with Flyway in Spring Boot - A Guide from Version Control to Production Deployment
A practical guide to safely version-controlling your database schema using Flyway in Spring Boot applications. Covers introducing spring-boot-starter-flyway, configuring application.properties, how the flyway_schema_history table works, handling existing databases with baseline-on-migrate, and troubleshooting with flywayRepair, all explained with concrete examples.