[Infra] Enable DB migration not to stop existing system

okuda-seminar / Twitter-Clone

0 stars 0 forks source link

[Infra] Enable DB migration not to stop existing system #382

Open nayuta-ai opened 4 months ago

nayuta-ai commented 4 months ago

Summary

Same with the title. https://github.com/okuda-seminar/X-Clone-Backend/pull/30#issuecomment-2217707205

Deadline

8/31

References

https://qiita.com/yy_harachi/items/b2463c0872e044c8c25a
https://qiita.com/an_sony/items/9b8fcb625cccb959f6a0

Notes

None

nayuta-ai commented 3 months ago

Working Time

Report

We investigated whether pgroll allows for schema migration without downtime. The investigation revealed that pgroll can perform schema migrations without downtime, so I documented the system architecture and CD workflow using pgroll in the design document.