Hello ServerFault Community,
I'm usually a StackOverflow lurker/contributor, however I've been playing with a server cloud service recently and would appreciate your thoughts.
I build web applications (generally small to medium in size with low-ish traffic) and at present I have 3 virtual machines running on Debian and serving web files through Apache and data with MySQL. Each VPS runs between 10 and 30 sites; some custom apps, some Wordpress and a few static HTML sites.
With the new cloud service that I'm playing with (currently in beta so it's free!) I have the ability to start/stop and scale servers as I please. The first experiment on my list is to replace Apache with Nginx and so far this is going well. However, I am beginning to wonder whether there would be any benefit in having one server 'optimised' to serve files via Nginx and store media files and then another server 'optimised' to run and serve data through MySQL.
I don't know whether there's much you could do to optimise each server for either web or database hosting or whether there'd be any other great benefits to separating the services apart? I would appreciate any thoughts/comments on the matter and any other options that I may have missed.
Sidenote: Using the cloud service, I have the option to fully customise the servers on the fly including memory, disc space and disc speed (SATA, SAS, SSD).