3 db servers running - how to configure

I get that when I’m running a production app I might need multiple db servers to handle capacity, but right now I’m only doing small scale user testing. How can I limit the number of instances?
my fly.toml only seems to handle the the compute resources.

Hi… For development, a single node is fine, but I think you might be misunderstanding the full reasons for having multiple nodes in production:

Having said that, paring down 3 → 1 for the time being, while you are still just testing, might be possible, depending on which database you’re actually using. Plausible ones that come to mind include Fly Postgres (a.k.a. “Legacy Postgres”), Fly MPG, MySQL…

The Fly Postgres clusters in particular are a big responsibility, like owning a pony or something, :brush_and_pony:

I’d just use a managed database, to be honest; self-managed Postgres, and rescuing if necessary, sounds like a headache that folks ought to try to avoid. However SQLite and LiteFS sounds quite good, and I am thinking of trying it. Just remember to take regular backups.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.