Right now, one of our product offerings is basically LAMP web hosting. We host a PHP CMS, lots of images, and sometimes WordPress in each Apache host–all across multiple linux dedicated boxes. Our clients also have FTP access to their host. Each Apache host has 1 or more mysql databases.
My question is: can this setup be done using some combination of stock cloud services (from AWS or Rackspace)?. If I can avoid having to spin up new dedicated boxes every month or two or save money, that'd be great.
EC2 and RS Cloud Servers have no or little local storage. I could update my CMS to upload files to S3 but I still lose FTP and possibly WordPress. It seems block storage may be the answer. I'm just not sure how all the pieces fit together, specifically with storage and DBs.