points by mrkurt 6 years ago

The "simplest" gains come from adding an in memory cache, we include Redis for this and some apps work really well just leaving the DB where it is, caching aggressively, and running close to users: https://fly.io/docs/redis/

Read only replicas are a great first step for most applications. I'd probably do caching first, then replicas (which are kind of like caching).

Region specific persistence is one way to improve write latency, and I think the simplest for most apps. We've experimented with CockroachDB for this (it keeps ranges of rows where they're most busy), and you can actually deploy MongoDB this way.

chrisjarvis 6 years ago

Thanks that totally makes sense! I look forward to playing around with this.

awoods187 6 years ago

PM@cockroach labs here. Which tools did you experiment with? We've been working to increase our tooling capabilities!

  • mrkurt 6 years ago

    We got hung up with the migration tooling for popular frameworks. If we can get those migrations to work with minimal drama, we want to basically show people “global full stack” with app + cache + database.