Synchronization of memcached with database

[Adi]

Hi,
I am newbie in memcached, i am devloping ASP.Net application in a web
farm and i need distributed cache solution. And most probably i will
use caching most of the time and wants to synchronize cache objects
with database in off peak time.

I have following question in my mind before proceeding with the
memcached.

1) Could it possible to synchronize memcached cache object with
database and vice versa? If the synchronization is not possible than
how can it be done?

2) Memcached is supported for 64Bit Windows Server 2003?

3) Is there any detail documentation of memcached available? if than
please give me its links.

Thanks in advace.
Waiting for your reply
Adi

[Jeremy Dunck]

On Tue, Aug 25, 2009 at 11:28 AM, Adi<adeel...@gmail.com> wrote:
> I have following question in my mind before proceeding with the
> memcached.
>
> 1) Could it possible to synchronize memcached cache object with
> database and vice versa? If the synchronization is not possible than
> how can it be done?

Maybe you want something like pgmemcache or wafflegrid?
http://pgfoundry.org/projects/pgmemcache/
http://www.bigdbahead.com/?p=80

[Henrik Schröder]

1) It's a cache, not a datastore. You put objects in the cache for faster access, if they're not in the cache, you read it from your primary datastore, such as a database or whatever you have, and put them in the cache. When you update objects, you update them in your datastore, and in the cache. That way objects in your cache will always be up-to-date, or simply not cached yet.

2) Yes, we're running on that and it works perfectly. Make sure you get at least version 1.2.5 or later though.

3) What do you mean? For the server there is the protocol specs: http://code.sixapart.com/svn/memcached/trunk/server/doc/protocol.txt

For the clients, it depends on the client. You can find some documentation for my client here: http://code.google.com/p/beitmemcached/wiki/Examples


/Henrik Schröder