> 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.