Infra: Add database - Githubissues

bryantrobbins / baseball

An upcoming web-based tool for sabermetrics.

Apache License 2.0

22 stars 9 forks source link

Infra: Add database #57

Closed bryantrobbins closed 7 years ago

bryantrobbins commented 8 years ago

Trying to decide between Postgres, MongoDB, and Riak. Would like to pick one and add it to the existing infrastructure, for now.

My current favorite is Riak, which is similar to AWS DynamoDB (based off of the Dynamo paper).

Requirements:

Support for multiple nodes
Ability to run nodes in Docker containers, across different Docker hosts
No data loss on single node failure
Ability to backup and restore from tarball
Low-latency querying interface

bryantrobbins commented 8 years ago

Screw it, I'm doing mongodb. Adding it to the buildhost instance in the standard stack for now. Will revisit once I can manage to pull costs down elsewhere (DB probably needs the best instance of the stack, in the long run).