Re: Memcached for Database server

Hi,

2011/05/17 14:31, Adarsh Sharma wrote:
> Rick Genter wrote:
>> On May 16, 2011, at 10:09 PM, Adarsh Sharma wrote:
>>
>>
>>> Dear all,
>>>
>>> I need to research on Memcache in the next few days.
>>>
>>> What I want to know is it worth to have memcahed enable in our Mysql/ Postgres Production Servers.
>>> We have databases from 20 to 230 GB and it's not the OLTP just a simple OLAP where data is fetched and stored in some meaningful format.
>>>
>>>
>>> What are benefits& why we used memcahed?
>>>
>>> What are the bottlenecks to meet?
>>>
>>
>> You need to read about memcached. Memcached is not something you "enable". You have to program to it.
>>
>
> Thanks Rick, just one question..
>
> At what stage we need memcached & what is the purpose of using it.
>
> I just want to know whether it is worth to use memcahced or not as per our requirements.

I just built a software to enable query caching for PostgreSQL
with using memcached, which adds a proxy layer.

http://pgsnaga.blogspot.com/2011/03/postgresql-query-cache-pqc.html

Please take a look.

Thanks,

>
>> --
>> Rick Genter
>> rick(dot)genter(at)gmail(dot)com
>>
>>
>

--
NAGAYASU Satoshi <satoshi(dot)nagayasu(at)gmail(dot)com>