Re:Readyset: A MySQL and Postgres wire-compatible caching layer
by jitl on Wednesday February 21, 2024 @08:04AM
(#39453274)
How do you invalidate your cache? Is it complicated? What about search queries with many filters? What about responses that are unique per user? What about common queries that are shared between multiple views, do you constantly re-run those as your response cache is invalidated?
[ Parent
| on HN ]
Re:Readyset: A MySQL and Postgres wire-compatible caching layer
by marceloaltmann on Wednesday February 21, 2024 @08:14AM
(#39453376)
Caches are never invalidated. Readyset uses CDC to receive updates from PostgreSQL/MySQL and update the cache entries. No invalidation required. The price you pay is eventually consistent data, which is already true if you use any async replication like readyset does.