News for hackers. Stuff that matters.
Re:Readyset: A MySQL and Postgres wire-compatible caching layer by redwood on Wednesday February 21, 2024 @07:45AM (#39453100)
Anyone successfully using? There are a few other services out there like PolyScale. It will be interesting to see if any of these introduce some form of write support over time
Re:Readyset: A MySQL and Postgres wire-compatible caching layer by marceloaltmann on Wednesday February 21, 2024 @08:37AM (#39453585)
I found one case study on their blog - https://blog.readyset.io/medical-joyworks-improves-page-load...

> It will be interesting to see if any of these introduce some form of write support over time

Writes performed by your application in Readyset are automatically proxied(redirected) to your database.

Re:Readyset: A MySQL and Postgres wire-compatible caching layer by lukoktonos on Wednesday February 21, 2024 @08:31AM (#39453520)
What do you mean by write support here? Readyset will apply writes via a replication stream from the upstream database.
Re:Readyset: A MySQL and Postgres wire-compatible caching layer by jitl on Wednesday February 21, 2024 @08:36AM (#39453568)
I think they mean acting as a write-through cache. If you send writes to the cache and have the cache delegate those writes to the underlying DB you get consistent invalidation, and if the write-through cache is smart enough it can even be transactional with the underlying source of truth.
Re:Readyset: A MySQL and Postgres wire-compatible caching layer by lukoktonos on Wednesday February 21, 2024 @08:47AM (#39453710)
Readyset does have some work and design done towards read-your-writes consistency, but it's still under development. The Noria paper does briefly touch on extending partial materialization with stronger consistency models via MVCC or other mechanisms as well.