Memcached + MySQL

[Brian Aker]

Hi!

No offense to Jan but he didn't really expose much of Memcached (and  
from the look of how he did the code it has a high chance crashing  
the server).

Cheers,
	-Brian

On Oct 30, 2007, at 6:49 PM, 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
>>
>>
>>

--
_______________________________________________________
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.