We have 22 HTTP servers, each of which works with separate ASP.NET caches. They are read from a read-only database that is updated only from peak hours.
We use the file dependency to invalidate the cache, asking the servers to "update" their caches ... If this is accidentally done during peak hours, it risks knocking down our database cluster due to a sudden flood of open connections.
Has anyone used memcached with ASP.NET in this distributed form? It seems to me that this will be a huge advantage: you only need to create one cache (and hit DB 21 times less), and memcached will process it in every window.
If you have one, will you put it in the same field as the HTTP mailboxes, or are you using a separate cache level? How scalable is it, can we expect it to require powerful servers? Our working dataset is not huge (we enter it in 4 gigabytes of memory on each HTTP field, just fine).
How do you deal with invalidity?
We are looking for experience and military stories.
EDIT: Win2k3, IIS6, 64-bit servers ... 4 gigabytes in a box (I think we might have upgraded it to 16 gigs when we switched to 64-bit servers).
source
share