何时使用MongoDB(When to use MongoDB)

 我正在编写一个不一定需要扩展能力的应用程序，因为它不会在开始时收集大量数据。 （但是，如果我很幸运，我可能会走上这条路。） 
 
 我将在同一个盒子上运行我的Web服务器和数据库（现在）。 
 
 这就是说，我正在寻找性能和效率。 
 
 我的应用程序的主要部分将加载博客文章。 使用RDBMS（MySQL）我会做6个查询（其中2个查询是连接），只是加载一个博客文章页面。 
 
select blog
select blog_album
select blog_tags
select blog_notes
select blog_comments (join with users)
select blog_author_participants (join with users)
 
 但是，通过MongoDB，我可以将6个表格取消规格化并将其平整为2个表格/集合，并将我的查询最小化为可能只有1个查询， 
 
users
blogs
    ->blog_album
    ->blog_tags        
    ->blog_notes
    ->blog_comments
    ->blog_author_participants
 
 现在，使用MongoDB模式，将会有一些数据冗余。 但是，硬盘空间比CPU /服务器便宜。 
 
 1.）这会是一个很好的使用MongoDB的场景吗？ 
 
 2.）你在扩展到单个服务器之外时是否只使用MongoDB获得性能好处？ 
 
 3.）使用MongoDB有没有耐久性风险？ 我听说在执行插入操作时可能会丢失数据 - 因为插入操作先写入内存，然后写入数据库。 
 
 4.）这应该阻止我在生产中使用MongoDB吗？ 

I'm writing an application that doesn't necessarily need scaling abilities as it won't be collecting large amounts data at the beginning. (However, if I'm lucky, I could down the road potentially.)
 
I will be running my web server and database on the same box (for now).
 
That being said, I am looking for performance and efficiency. 
 
The main part of my application will be loading blog articles. Using an RDBMS (MySQL) I will make 6 queries (2 of the queries being joins), just to load a single blog article page. 
 
select blog
select blog_album
select blog_tags
select blog_notes
select blog_comments (join with users)
select blog_author_participants (join with users)
 
However, with MongoDB I can de-normalize and flatten 6 tables into just 2 tables/collections and minimizes my queries to potentially just one 1 query,
 
users
blogs
    ->blog_album
    ->blog_tags        
    ->blog_notes
    ->blog_comments
    ->blog_author_participants
 
Now, going with the MongoDB schema, there will be some data redundancy. However, hard drive space is cheaper than CPU/servers. 
 
1.) Would this be a good scenario to use MongoDB? 
 
2.) Do you only benefit in performance using MongoDB when scaling beyond a single server?
 
3.) Are there any durability risks using MongoDB? I hear that there is potential for loss of data while performing inserts - as insert are written to memory first, then to the database.
 
4.) Should this stop me from using MongoDB in production?

原文：https://stackoverflow.com/questions/4981753