search

superfly / litefs

FUSE-based file system for replicating SQLite databases across a cluster of machines
Apache License 2.0
3.96k stars 95 forks source link

Support for a single writer with read only replicas? #220

Closed callumj closed 1 year ago

callumj commented 1 year ago

I’m looking to SQLite as a simpler way to index data stored across some systems into a shared database.

Only one writer would be active at a time and then a different set of replicas (in say read only mode) or an entirely different set of apps (eg a web UI for SQLite) could hook directly on to S3 (no need for Consul, no need for service discovery). Is this something being considered for LiteFS or within something you’d like LiteFS to be able to do?

benbjohnson commented 1 year ago

hey @callumj. There's is an option for a "static lease" where a single node permanently acts as the writer and other nodes only act as read-only replicas. Is that what you're thinking? https://fly.io/docs/litefs/config/#static-leasing