4 ms·

Thanks for sharing your experience. Having performed a sort of reverse migration (mongodb -> pgsql), I'd have a few questions. Is it possible to know the use c

by gmodena 15y ago

Thanks for sharing your experience. Having performed a sort of reverse migration (mongodb -> pgsql), I'd have a few questions. Is it possible to know the use case of your setup? Which size (storage, load etc.) are you currently operating at? What is the projected growth in the medium term? What is main the benefit of this migration? Is MongoDB solving a specific problem that could not have been addressed by mysql/pgsql (or some document oriented/nosql other than mongo)? Are you using any ORM and/or middleware to interface to MongoDB?

rfurlan 15y ago
I am actually just finishing writing an article with all the details, I will post a link as soon as it is online :) We are not using any middleware and all our queries are hand-sculpted to make sure we are never causing more I/O impact than we need to. I am sure everything we do could have been done with mysql/pgsql with enough consideration for the performance characteristics of either database. Ultimately, a document-based storage was simply a better, more natural fit for us.