We are planning to package MongoDB-PostgreSQL hybrid solution in our application that will be deployed on customer site on-premise. It will be packaged as a software virtual appliance.
Our reason for considering MongoDB: The no-schema value proposition is really lucrative for us, we know that by design our schema will evolve. So MongoDB looks good from application point of view, what I am not sure is the manageability/admin part in the on-premise deployed scenario. It may not be very high-scale application. Also we do need RDBMS for our customizable analytics with heavy dependency on ROLAP. Hence the data movement part also kicks-in as a trade-off.
Questions: 1.Is MongoDB a technology that can be deployed and managed on-premise successfully.
2.Have You done it?
3.Will the customer need to have a MongoDB admin? ( How often MongoDB needs to be looked at, in your experience)
4.We are thinking to replicate data to PostgreSQL for analytics use cases. What problems need to consider regarding data movement, is it doable? Specially since it is deployed on customer-site.
I am aware that the questions are not very specific, but it would be still very valuable for me to get different perspectives. So Appreciate your response to these generic questions.