Thoughts on Innodb Scaling using waffle grid

Some thoughts on scaling innodb with waffle grid

Leverage OS container virtualization

• Static or on demand OS containers provisioning
• Instantiate memcache node
• Publish to existing memcache cluster
• Manage on demand memcache node from load balancer like squid

Benefits of this approach

• Latency between cache nodes is reduced
• Potentially enhance memcache server to perform addressing of objects using PAE http://kerneltrap.org/node/2450
• Key value pairs could leverage PAE addressing for optimizing data structure as linked list

A more detailed version of Innodb vs MyISAM slides is here http://www.scribd.com/doc/22677819/inodbvsmyisam