Memcached + MySQL
Patrick Galbraith
patg at grazr.com
Wed Oct 31 02:44:14 UTC 2007
Looks like what I was thinking of, actually. I'll have to think about
what I was brainstorming the other night and see if this does just that.
I knew he had done the work with Lua, and somehow missed his memcached_udf.
One less thing to possibly have to do ;)
Chris Goffinet wrote:
> Doesn't this already exist?
>
> http://jan.kneschke.de/projects/mysql/udf
>
>
>
> Chris Goffinet
> goffinet at yahoo-inc.com
>
>
>
> On Oct 30, 2007, at 6:46 PM, Patrick Galbraith wrote:
>
>> Also coming soon will be Memcached UDFs (user defined functions)
>> which will allow you to be able to use MySQL, via SQL, to interact
>> with Memcached. Consider this a pre-announcement announcement ;)
>>
>>
>>
>> Brian Aker wrote:
>>
>>> Hi!
>>>
>>> On Oct 30, 2007, at 2:11 PM, Angelo McComis wrote:
>>>
>>>> I saw the one-page with the source download, I've read the README in
>>>> there... essentially it's pre-alpha work.
>>>
>>>
>>>
>>> Expect that to change very quickly soon. The current work for the
>>> engine is solid, the problem was at the time I had no C client
>>> library that would work from either a license point of view or a
>>> "it does not leak memory and is thread safe". The library I
>>> implemented, libmemcached, is now pretty solid so I can turn back
>>> my attention to the engine sometime in the next month. There are
>>> some issues I want to work on with node failure, but that it minor
>>> work at this point.
>>>
>>>> improve the performance of this thing. MemcacheD looked appealing
>>>> as it
>>>> could theoretically plug in as a storage engine and turn disk
>>>> reads into
>>>> memory reads for frequently resolved DNS queries.
>>>
>>>
>>>
>>> This will work. If you are just looking for a one node solution,
>>> you can just use the MEMORY in engine in MySQL.
>>>
>>> One thing to consider is whether or not you might just want to use
>>> memcached directly. The advantages of running it as a table are
>>> tools and structures, but you do hit a performance cost for doing
>>> that.
>>>
>>> Cheers,
>>> -Brian
>>>
>>> --
>>> _______________________________________________________
>>> Brian "Krow" Aker, brian at tangent.org
>>> Seattle, Washington
>>> http://krow.net/ <-- Me
>>> http://tangent.org/ <-- Software
>>> http://exploitseattle.com/ <-- Fun
>>> _______________________________________________________
>>> You can't grep a dead tree.
>>>
>>>
>>
>>
>> --
>> Patrick Galbraith, Senior Programmer Grazr - Easy feed grazing and
>> sharing
>> http://www.grazr.com
>> Satyam Eva Jayate - Truth Alone Triumphs
>> Mundaka Upanishad
>>
>>
>>
>
--
Patrick Galbraith, Senior Programmer
Grazr - Easy feed grazing and sharing
http://www.grazr.com
Satyam Eva Jayate - Truth Alone Triumphs
Mundaka Upanishad
More information about the memcached
mailing list