I'm currently running a VPS that uses ~1.5GB of ram. I'm thinking of switch to Amazon EC2, because access to our host is pretty slow, lots of downtime, etc.
An EC2 small instance has 1.7GB, so I assume if I want to migrate I'm going to need more than one instance. The idea would be to run Apache on one instance and MySQL on another, then figure out where to run the rest of my processes (Mono, Red5, etc.) based on RAM usage on either instance.
I'm not really a server professional, so I don't know if this makes any sense, or if there is something I am missing. Will there be a big performance hit if Apache (Wordpress, etc.) has to access databases on another EC2 instance? Anything else that might make this a bad idea?