MySQL wants Pluggable Query Cache too!
I was pleased to wake up this morning to find a message from Monty Taylor on my IRC client about how MySQL is working towards a pluggable query cache API:
Why do I care? well I’ve been talking about a pluggable query cache interface for Drizzle from it’s early days so I was delighted to see that someone else in the world cares too. Here are my blog posts that describes this better:
An advise from me is that we can’t really promote the query cache feature with it’s current design since it is far more effective to use memcached directly from the application layer. We really need to come up with a design that allows the cache to be more granular (do better than table-level invalidation for every update) although this is easier said than done heh.
I totally look forward to seeing how the MySQL Query Cache API turns out anyway :)
