Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
add comment

1 Answer

  1. Yes. Hundreds of customers run on premise
  2. Yes. Both of physical boxes and virtual boxes.
  3. You will need to allocate sufficient time to ensure the cluster is setup correctly. Also you need to plan for certain events like adding shards, failover, compacting etc. But overall it is managable and no worse than other databases. Another option is to use a DBaaS solution like here
  4. Are you planning to do this with code or by using some mongodb<->postgre replication software? Theoritically its possible, the specifics depend on your use case.
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.