We have a product that uses Postgres for RDBMSish data (accounts, billing, etc.) and MongoDB for each of the accounts data (which obviously can't be maintained on Postgres).
In local development we set up our boxes to have the psql
instance and mongod
instance on the same box (accompanied with the application server and web server), but as we are moving to beta phase I'd like to know what is the best set up for production environment or rather what is easier to set up and maintain.
An instance (cloud server) holding both the databases together or should we split instances and each should have his own machine? (Obviously the second option is always better)
Has anyone ever experienced with these sorts of setups and have some insights? We also look at the possibility of migrating to MongoDB completely but that possibility is further down the road.