+1 We use gearman for this.
Brian.
--------
http://brian.moonspot.net/
On 6/3/10 3:13 PM, dormando wrote:
We're building a system with heavy real-time write volume and looking
for a way to decouple db writes from the user request path.
We're exploring the approach of buffering updated entities in
memcached and writing them back to the database asynchronously. The
primary problem that we're concerned about is how to ensure that the
entity remains in the cache until the background process has a change
to write it.
Any advice and/or references would be greatly appreciated.
You really probably want to use a job server... http://gearman.org/ -
write updates async to gearman and update caches in memcached if you want,
then have workers write them back to the DB as fast as your system can
handle.