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?
Comments
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?
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.