News for hackers. Stuff that matters.
Re:MySQL - Do Not Pass This Way Again by mscarborough on Saturday January 26, 2013 @11:28PM (#5123061)
As you described it, the query/caching strategy sounds too complicated.

mysql proxy might help you out, or mysql triggers, or plenty of easy indexing strategies.

i agree, caching strategies are not easy, but that is not the fault of databases. IMHO keeping your data layers separate is best.

if you have a multi-site installation, set some kind of prefix within the app that makes sense to you for each application, before it goes into whatever cache.

this will work for you whether it is shared memory, memcached, or some kinda file situation.

Re:MySQL - Do Not Pass This Way Again by zorlem on Sunday January 27, 2013 @07:02AM (#5123971)
> As you described it, the query/caching strategy sounds too complicated.

But that was his whole point - needlessly complicating an otherwise simple setup to get around limitations in the DB engine.

> mysql proxy might help you out, or mysql triggers, or plenty of easy indexing strategies.

I genuinely fail to see how mysql-proxy [1] (which has a sleuth of long-standing, unfixed, problems on its own), or triggers would (elegantly) help in this situation.

[1] http://dev.mysql.com/doc/refman/5.1/en/mysql-proxy.html

edit: formatting

Re:MySQL - Do Not Pass This Way Again by knightni on Sunday January 27, 2013 @03:55AM (#5123698)
...or he could use a dbms that works properly and save himself the hassle.