Flyway database migration on startup and multiple application nodes ?

[omasseau]

Hello,

I am a bit confused if automatic Flyway migration on application startup could be problematic when having a cluster of multiple application nodes.

The Flyway FAQ says this:

(Source: https://documentation.red-gate.com/fd/frequently-asked-questions-277579363.html#parallel)

But the Quarkus documentation says this:

(Source: https://quarkus.io/guides/flyway#flyway-on-kubernetes)

It is not very clear if it should be ABSOLUTELY disabled to avoid any problem when having multiple nodes or if it is just recommended, when under Kubernetos, to use Job, just to speed up startup times of nodes (as they won't have to check if the migration has to be performed).

[quarkus-bot[bot]]

/cc @cristhiank (flyway), @gastaldi (flyway), @geoand (flyway,kubernetes), @gsmet (flyway), @iocanel (kubernetes)