I am interested in stories from people who started out with a relational db (postgres, mysql, ..), outgrew it in the sense that it could no longer handle the amount of data and/or requests and then migrated to a NoSQL db. I am not talking about projects that used mongodb from the beginning "because it needs to scale", but stories from migrations from one to the other. What triggered the migration? What type of data did you have? How did the migration turn out? Did you get the expected benefits?<p>The reason I'm interested in this is that I hear it again and again: We need to use a NoSQL db, because postgres is not fast enough. Is it though? Did you try and it was <i>actually</i> not fast enough or are you talking about some hypothetical future performance benefits? I am sure there are cases where this is true, but I am just as sure that there are cases where a relational db is just fine.
Not a migration to NoSQL but checkout these exciting presentations and blogposts on Uber's migration, they started out on MySQL then migrated to Postgres [0]<p>Then as they blitzcaled they famously migrated again from Postgres back to MySQL 3 years later. [1] [2]<p>Seems that MySQL is good enough at Uber's scale.<p>[0] <a href="https://www.yumpu.com/en/document/view/53683323/migrating-uber-from-mysql-to-postgresql" rel="nofollow">https://www.yumpu.com/en/document/view/53683323/migrating-ub...</a><p>[1] <a href="https://eng.uber.com/postgres-to-mysql-migration/" rel="nofollow">https://eng.uber.com/postgres-to-mysql-migration/</a><p>[2] <a href="https://use-the-index-luke.com/blog/2016-07-29/on-ubers-choice-of-databases" rel="nofollow">https://use-the-index-luke.com/blog/2016-07-29/on-ubers-choi...</a>