Hi!
On Nov 12, 2008, at 8:33 AM, Lei Gao wrote:
Thanks for your update. Let's see if I want those UDF's to be
invoked in my slave db when receiving data changes from the master
db, would I have to invoke those functions within a trigger?
That is one way to do it. Personally I favor embedding the udf either
in the query itself, or in using a multi-sql issued set and having the
UDF run against a null table (aka blackhole).
I was looking at the UDF's for mysql but could not find any function
for invalidating memcached entries. Does it mean one can only delete/
update existing entries with mysql UDF's?
Invalidation is just deleting the object in the cache. As soon as a
cache miss occurs your application should then just repopulate the
cache.
Cheers,
-Brian
--
_______________________________________________________
Brian "Krow" Aker, brian at tangent.org
Seattle, Washington
http://krow.net/ <-- Me
http://tangent.org/ <-- Software
_______________________________________________________
You can't grep a dead tree.
