Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Investigate MongoDB as replacement for Postgres #384

Open
TWilkin opened this issue Jul 6, 2023 · 0 comments
Open

Investigate MongoDB as replacement for Postgres #384

TWilkin opened this issue Jul 6, 2023 · 0 comments
Labels
api Relating to the API service enhancement New feature or request kubernetes Relating to the Kubernetes deployment persistence Relating to the persistence service
Milestone
High Availability

Comments

@TWilkin
Copy link
Owner

TWilkin commented Jul 6, 2023

  • MongoDB supports replicas.

  • PowerPi is storing JSON messages, so a document store makes more sense anyway.

  • Remove need to run db on a single node as each node can have it's own copy of the db that is synchronised by MongoDB.

  • Create migration script.

  • Deploy MongoDB alongside Postgres.

  • Update persistence to write to MongoDB.

  • Update API to query MongoDB.
@TWilkin TWilkin added enhancement New feature or request api Relating to the API service persistence Relating to the persistence service kubernetes Relating to the Kubernetes deployment labels Jul 6, 2023
@TWilkin TWilkin added this to the High Availability milestone Jul 6, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
api Relating to the API service enhancement New feature or request kubernetes Relating to the Kubernetes deployment persistence Relating to the persistence service
Projects
None yet
Milestone
High Availability
Development

No branches or pull requests
1 participant
@TWilkin