CODEWITHSUNDEEP
flyway
Nam Vu
Nam Vu

Reputation: 171

Flyway concurrent migration

We are having many projects running on many servers looking up into one database, and we"re thinking to setup Flyway to every project for control our database structure.

But we are worrying about concurrent migration problem, if some projects re-deploy in sametime. (Of course, we always take care the "If exist" things in SQL syntax.)

How does Flyway work when concurrent changes are made on same data table or other structural thing?

Upvotes: 15

Views: 5155

Answers (1)

Axel Fontaine
Axel Fontaine

Reputation: 35169

It works as expected. See the answer in the FAQ: https://documentation.red-gate.com/flyway/flyway-cli-and-api/learn-more/frequently-asked-questions#parallel

Can multiple nodes migrate in parallel?

Yes! Flyway uses the locking technology of your database to coordinate multiple nodes. This ensures that even if multiple instances of your application attempt to migrate the database at the same time, it still works. Cluster configurations are fully supported.

Upvotes: 16

Related Questions