Hi guys, I've been following this thread, I like the idea of manage mmc keys from mysql, my only concern is, since mmc keys are managed by the client (hash generation, etc), in my case I use PHP how compatible is the key generation against the UDF mysql functions? I mean, can I generate some key on PHP and erase it from mysql with triggers without any problem?
tty for your time! gabriel On Tue, Nov 11, 2008 at 9:44 PM, Brian Aker <[EMAIL PROTECTED]> wrote: > > 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. > > > > -- Los sabios buscan la sabiduría; los necios creen haberla encontrado. Gabriel Sosa
