TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

Ask HN: We just migrated from SQL Server to MongoDB - ask us anything

26 pointsby rfurlanover 13 years ago

9 comments

mark_l_watsonover 13 years ago
I have two customers (I am a consultant) who use MongoDB - one uses paid-for support from 10gen (which seems very good, BTW) and one doesn't. Just curious: are you using paid for support, or investing instead on learning everything you can about MongoDB?<p>BTW, I like your choice: MongoDB is a great developer experience, if you can lighten up on needing immediate consistency.<p>Also, re: backups: why don't you run a slave that you take offline a few times an hour to snapshot? Low ceremony doing this, and I would feel better about the safety of your data. It is pretty easy to run a cron job that cleanly shuts down a slave, ZIPs a backup to S3 (or where ever), and restarts the slave.
评论 #3142550 未加载
gmodenaover 13 years ago
Thanks for sharing your experience. Having performed a sort of reverse migration (mongodb -&#62; pgsql), I'd have a few questions.<p>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?
评论 #3151144 未加载
Joakalover 13 years ago
Did you have extra costs due to more memory requirements? Any other costs? What about savings?<p>How long did it take to train the team to MongoDB?<p>Did you have a rollback plan if MongoDB is not good enough?<p>What were your requirements that made MongoDB better than SQL Server and the other DBs?
评论 #3141797 未加载
评论 #3141809 未加载
rfurlanover 13 years ago
Thank you everyone for the incredible feedback. I have just published the article here: <a href="http://www.wireclub.com/development/TqnkQwQ8CxUYTVT90/read" rel="nofollow">http://www.wireclub.com/development/TqnkQwQ8CxUYTVT90/read</a><p>I hope you will find it useful!
bartonfinkover 13 years ago
Why? What prompted you to move off an RDBMS in general and to MongoDB in particular? Did you move your entire data tier to MongoDB or just particular parts of your data model?
评论 #3141730 未加载
manuscreationisover 13 years ago
I'll start the ball rolling with an easy one...<p>How did it go?<p>Can you talk through some of the changes you had to make, both from a library perspective, as well as any architectural changes that were required?
评论 #3141360 未加载
rfurlanover 13 years ago
We just migrated a large production database for an existing website to MongoDB. I am currently writing an article to share the lessons learned, in the mean time I would be happy to answer your questions!
peschkajover 13 years ago
With SQL Server (or any RDBMS) there are known backup and recovery strategies and a WAL as added security. What kind of disaster recovery strategies are you employing with MongoDB?
评论 #3141828 未加载
评论 #3142495 未加载
评论 #3151944 未加载
mulokaover 13 years ago
What do you use for reporting if any? Do you use still use SSRS? If so how? Would love to hear about how your reporting needs are met.
评论 #3151184 未加载