PlaceAVote / pav-api

This repository contains the Placeavote API.
0 stars 0 forks source link

Add maintenance stage #56

Open sanel opened 8 years ago

sanel commented 8 years ago

pav-api should have maintenance state, set either with authenticated REST call or field in database, that will prevent any database writes.

This is useful mainly when we do migrations.

johnboy14 commented 8 years ago

Disabling writes means disabling the API during this process in, which will block any user interactions with the app. Instead of doing this we should look at AWS Database Migration service.

From the documentation it looks like it will perform the migration from a source database into a new target database without affecting the current Databases status. I think this would be a much better solution when we are operating at a large scale.

https://aws.amazon.com/dms/

I am not entirely sure if this will operate with Flyway.

sanel commented 8 years ago

Interesting service. No, Flyway will not operate on live database; at least I wasn't table to find any reference.

Disabling writes means disabling the API during this process in

Yea, this is expected behavior. I presume that migrations should not take more than couple of seconds if done properly. However, why not evaluate DMS too :smile_cat: