update strategy

mrot mrot at neostrada.pl
Sat Oct 8 00:20:08 PDT 2005


I have a question about data update strategy.
Assume that we cache database queries and their results.
Who is responsible for updating cache if one of the processes updates 
data in database ?
clients do (pseudocode):
 value=mc->get("SELECT description FROM table1 where id=123");
And we obtain the data fomr cache. Looks good....

But one of the clients does:
MySQL database.
database.execeuteQuery("UPDATE description SET description='new 
description' WHERE id=123");

Now we have inconsistency between cache and database.
How this should be handled ?


More information about the memcached mailing list