Cache invalidation of memcached entries using database triggers
obiwantcp at hotmail.com
Sat Sep 11 20:39:13 PDT 2004
Has anyone written memcached client applications to do cache invalidation?
I was thinking of writing a Perl or PHP daemon towatch for Postgresql's
NOTIFY/LISTEN signals (plus a helper table or two to help infer which record
add/delete/modify will affect which memcached entry) but I have no idea how
reliable NOTIFY/LISTENs are. I figured some of you may have found a good
use for cache invalidators and maybe even made one so I'd like to ask your
opinion on whether to do this with memcached and what to expect. Thanks!
If you have done it with other languages (Python, Dotnet, etc) or other
databases (MySQL, Oracle, SQL Server) please let me know as well. We use
just about everything in the shop.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the memcached