Some systems already have two parallel ways of looking up data built in -- an SQL backend such as MySQl and a fast key-value store cache such as memcached. Such a system might be able to be modified to treat the fast direct InnoDB lookup as the cache level, without modifying too much code.
Comments
This is a fascinating post.
Some systems already have two parallel ways of looking up data built in -- an SQL backend such as MySQl and a fast key-value store cache such as memcached. Such a system might be able to be modified to treat the fast direct InnoDB lookup as the cache level, without modifying too much code.
It's similar to how FriendFeed uses (used?) MySQL:
http://bret.appspot.com/entry/how-friendfeed-uses-mysql