I'm a web developer by day but I haven't had as much server administration experience as I'd like. I'm working on some side projects which are hosted on a 512mb linode server.
The main app that I'm working on is a rails app that really doesn't do anything resource intensive.
Based on the size server I have is it best to run my primary database on the same server?
Would it be detrimental at all to put the primary database on another 512mb linode? Would there be in latency issues, maybe with larger reads/writes, if the second box is in the same data center with a private ip (192.168.x.x)?
Also I'm thinking about trying MongoDB. I know that Mongo loves a lot of memory because the memory mapped file strategy it uses but is there anyway I can get away with running MongoDB on my 512mb linode along side my application or even on it's own 512mb linode?
One last question, is it better to keep the primary and the first slave/replica set on the same box, or should I split the first slave/replica set to it's own box?