Distributed SQLite with Elixir

Re:Distributed SQLite with Elixir by ammmir on Thursday February 16, 2023 @12:08AM (#34815295)

Manually replicating writes to all nodes seems pretty fragile. At some point you're going to run into classic distributed systems issues, like netsplits, and reconciling the latest count. Maybe a CRDT implementation would avoid these issues alltogether?

But it sounds like LiteFS (with a single writer?) might be a pretty nice setup if it handles replication for you, as you probably don't want to build a Raft or Paxos system yourself.

[ Parent | on HN ]

Re:Distributed SQLite with Elixir by im_down_w_otp on Thursday February 16, 2023 @12:32AM (#34815441)

Litestream isn't for those kinds of use cases. It's for DR, not availability and/or scale.

[ Parent | on HN ]

Re:Distributed SQLite with Elixir by geysersam on Thursday February 16, 2023 @12:44AM (#34815502)

Replicating writes to all nodes does not sound scalable. Is it?

[ Parent | on HN ]

Re:Distributed SQLite with Elixir by simonw on Thursday February 16, 2023 @01:33AM (#34815754)

Litestream is different from LiteFS: same author, different projects.

LiteFS provides replication with the ability to serve read traffic from those replicas. Litestream provides disaster recovery by streaming a constant backup to an S3 bucket (or similar).

[ Parent | on HN ]

Re:Distributed SQLite with Elixir by avinassh on Thursday February 16, 2023 @04:27AM (#34816689)

Whats DR?

[ Parent | on HN ]

Re:Distributed SQLite with Elixir by flowcont on Thursday February 16, 2023 @05:41AM (#34817104)

Disaster Recovery

[ Parent | on HN ]