I've spoken with Rackspace's people about the ability of cloud sites to scale. It is true that the sites will auto-scale but the mysql database will not auto scale - they have the same database scaling issues as everyone else.