Re:Let's build a distributed Postgres proof of concept
by KingOfCoders on Tuesday May 17, 2022 @02:56PM
(#31414946)
It depends on your access pattern, if every application is write heavy to the same data set, this won't work. If every application is light on writes and those are mostly local (like for many SaaS companies), this will work fine with the future Litestream that redirect writes to one db and then distributes the data (if you can live with slightly stale data). Also depends on the size of you company. Slack does 300k/s messages, this won't work :-)
[ Parent
| on HN ]
Re:Let's build a distributed Postgres proof of concept
by cromd on Tuesday May 17, 2022 @03:24PM
(#31415261)
Oh, maybe I am behind on this “future litestream” that “redirects writes”. I only knew of the ability to sync/backup/restore. Do you have a link to something discussing those other features?
Re:Let's build a distributed Postgres proof of concept
by KingOfCoders on Thursday May 19, 2022 @03:24AM
(#31431721)
"adding feature"
https://fly.io/blog/all-in-on-sqlite-litestream/
"The upcoming release of Litestream will let you live-replicate SQLite directly between databases, which means you can set up a write-leader database with distributed read replicas. Read replicas can catch writes and redirect them to the leader"
Re:Let's build a distributed Postgres proof of concept
by ankraft on Tuesday May 17, 2022 @04:39PM
(#31416022)
It doesn’t redirect writes but you can create read-only replicas: https://github.com/benbjohnson/litestream-read-replica-examp...
Re:Let's build a distributed Postgres proof of concept
by andrewchambers on Tuesday May 17, 2022 @08:55PM
(#31418052)
You can already do this by using rqlite to redirect writes.