Welcome! Log In Create A New Profile

Advanced

Implementation of MemCached in a high volume, large database, online web system (site and service)

Posted by jonking007 
Hi

Really I'm looking for someone that can dicuss Memcache with me and
how we may integrate this with our systems. I'd be happy to pay for
the assistance.

The situation is this

MySQL Std and PHP5 web site and web service
120GB dB
potential 1,000,000 hits per day
20-30% of these hits may be requesting identical information from our
systems

we'd like to use memcached, if possible, to cache all the responses,
from our systems, to respond to identical requests, thus alleviating
re-processing.

Can anyone assist us?

many Thanks
Jonathan
On 9/27/10 9:33 AM, jonking007 wrote:
> Hi
>
> Really I'm looking for someone that can dicuss Memcache with me and
> how we may integrate this with our systems. I'd be happy to pay for
> the assistance.
>
> The situation is this
>
> MySQL Std and PHP5 web site and web service
> 120GB dB
> potential 1,000,000 hits per day
> 20-30% of these hits may be requesting identical information from our
> systems
>
> we'd like to use memcached, if possible, to cache all the responses,
> from our systems, to respond to identical requests, thus alleviating
> re-processing.
>
> Can anyone assist us?
>
> many Thanks
> Jonathan

Have you read http://code.google.com/p/memcached/wiki/TutorialCachingStory?

--

Brian.
--------
http://brian.moonspot.net/
I don't know about MySQL limitation if any (I use Oracle) but as far
as memcached
I can tell you the following:

One big company I'm with had a problem that on Christmas day, between
9am and 1pm
got pick hits of 6 million hits per hour world wide. This is a lot.

memcached was selected for me but I did the implementation. Several
other solution,
free or not,
Since the DB is about 200Million identity records the solution was
deployed on a 20
machines of 20 GB Ram each You can go up to 64GB but you need to
consider the CPU
power per machine.

The architecture is fairly simple in concept (once you see the
picture).
Every machine serves 1/20 of the DB. The architecture is very much
scaleable.
High availability is not a very big issue because if a machine dies -
1/20 of incoming
requests go to the DB and experience a little larger latency. Not a
big deal.

You can ask specifics or meet with me (as long as you are in the bay
area).
I'll be happy to help.

-Michael

On Sep 27, 7:33 am, jonking007 <[email protected]> wrote:
> Hi
>
> Really I'm looking for someone that can dicuss Memcache with me and
> how we may integrate this with our systems. I'd be happy to pay for
> the assistance.
>
> The situation is this
>
> MySQL Std and PHP5 web site and web service
> 120GB dB
> potential 1,000,000 hits per day
> 20-30% of these hits may be requesting identical information from our
> systems
>
> we'd like to use memcached, if possible, to cache all the responses,
> from our systems, to respond to identical requests, thus alleviating
> re-processing.
>
> Can anyone assist us?
>
> many Thanks
> Jonathan
it depends on your architecture and what type of contents you serve.

for identical information, i assume the response page once created,
the content wont change or in every x mins, html header and server
caching stage should be modified according to the needs. memcached is
good for constant modules that would be needed to create different
respond pages dynamically.

again, depends on the types of pages. maybe you wanna share a little
more about your web architecture?

as for the "pay", mike, brian and i would love to split it! :)

On Sep 27, 10:33 am, jonking007 <[email protected]> wrote:
> Hi
>
> Really I'm looking for someone that can dicuss Memcache with me and
> how we may integrate this with our systems. I'd be happy to pay for
> the assistance.
>
> The situation is this
>
> MySQL Std and PHP5 web site and web service
> 120GB dB
> potential 1,000,000 hits per day
> 20-30% of these hits may be requesting identical information from our
> systems
>
> we'd like to use memcached, if possible, to cache all the responses,
> from our systems, to respond to identical requests, thus alleviating
> re-processing.
>
> Can anyone assist us?
>
> many Thanks
> Jonathan
Sorry, only registered users may post in this forum.

Click here to login