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.