Spike: Research impact of running migrations once per instance, and on app startup

[exalate-issue-sync[bot]]

We’re planning to run 4 API instances in test

Document behavior.

On local:

• Comment out {{ # container_name: fecfile-api}}
• Run multiple API instances with  docker compose up -d --scale api=4
• See how all but one API instance crashes due to migrations trying to run at the same time

To complete ticket:

1. Document findings in ticket: see dev notes and above instructions on how to replicate locally
2. Create follow-up ticket if any actions can be taken to address the issue.

QA Notes

null

DEV Notes

[https://stackoverflow.com/a/69608486|https://stackoverflow.com/a/69608486|smart-link]

[https://pythonspeed.com/articles/schema-migrations-server-startup/|https://pythonspeed.com/articles/schema-migrations-server-startup/|smart-link]

[https://groups.google.com/g/south-users/c/9TJuEf-gJEE|https://groups.google.com/g/south-users/c/9TJuEf-gJEE|smart-link]

Previous research: [https://fecgov.atlassian.net/browse/FECFILE-233|https://fecgov.atlassian.net/browse/FECFILE-233|smart-link]

Design

null

See full ticket and images here: FECFILE-1773

[exalate-issue-sync[bot]]

Laura Beaufort commented: Best resources

• [+https://gist.github.com/majackson/493c3d6d4476914ca9da63f84247407b+|https://gist.github.com/majackson/493c3d6d4476914ca9da63f84247407b]
• [+https://teamplify.com/blog/zero-downtime-DB-migrations/+|https://teamplify.com/blog/zero-downtime-DB-migrations/]

Other resources

• [+https://lucasroesler.com/2017/02/zero-downtime-deploys-a-tale-of-django-migrations/+|https://lucasroesler.com/2017/02/zero-downtime-deploys-a-tale-of-django-migrations/]
• [+https://www.youtube.com/watch?v=5ErDx3oi1lI+|https://www.youtube.com/watch?v=5ErDx3oi1lI]
• [https://medium.com/3yourmind/keeping-django-database-migrations-backward-compatible-727820260dbb|https://medium.com/3yourmind/keeping-django-database-migrations-backward-compatible-727820260dbb|smart-link]