I'm just getting started with Amazon EC2 and trying to get my head round how the databases should work. If I have a high traffic site and want to load balance traffic over multiple instances I'm guessing these instances will have to be retrieving and saving data to a single separate instance to avoid data being fragmented across multiple machines.
Should I in that case install and run mongoDB on its own instance and have all other instances connect to this single data store? Or should I just run mongo and my http server on the same instance?
Would love to hear some of your best practices.