← Back to team overview

drizzle-discuss team mailing list archive

Re: Wild feature: query de-duplication

 

Brian,

How does the Gearman solution to de-duplication work ?

Might be wandering off topic.. if so please reply off list.

Is it part of Moxi ?

Does Gearman have a key on the query in the queue to avoid duplicates ?

--
Tom
On 25 Jun 2010, at 18:05, Brian Moon wrote:

So, one common use for Gearman seems to be running SQL queries through it so that a given query only ever is running once at a given time. This solves one big issue I have seen with a cache stampede. The application servers all run the same queries at the same time. Pushing this logic down to the database server seems like a good idea from where I sit. The server could recognize that there are N connections all running the same query and not try and do all the work needed to send back the result.

What do you guys think? Does this make sense at the database layer? Is the drizzle plugin architecture able to support this type of behavior?

--

Brian.
--------
http://brian.moonspot.net/

_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to     : drizzle-discuss@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help   : https://help.launchpad.net/ListHelp

Tom Hanlon
tom@xxxxxxxxxxxxxxxxxxx
Cloudera Certified Hadoop Developer
Certified MySQL DBA




References