This is a good start and we should look for various options to speed up the db access.
For cloudstack ACID compliance is important and some of these solutions achieve speed by trading off ACID properties. So I guess complete replacement of SQL may not be possible. There is another option of using nosql like Redis to cache the mysql query data. Again we need to see the complexity of using the native memcached API Vs simplicity of the nosql db to do caching. -abhi On 14/12/12 10:52 AM, "Edison Su" <edison...@citrix.com> wrote: >Looks like, the nosql-on-mysql >(http://dev.mysql.com/tech-resources/articles/whats-new-in-mysql-5.6.html# >nosql) an ideal solution for cloudstack API layer. >"Using the memcached API, web services can now directly access the InnoDB >storage engine without transformations to SQL, ensuring low latency and >high throughput for read/write queries." >Isn't what we want for api layer?