我在生产中使用CouchDB。目前它存储了所有不在原始DB模式中的“可选”字段。现在我正在考虑将所有数据转移到CouchDB。

我承认这一步很冒险。首先，因为它还不是1.0版本。其次，因为它需要大量的驾驶空间。根据我的计算，CouchDB文件(带索引)比具有相同行的MySQL数据库大30倍。 但我很确定它会好起来的。

我们使用CouchDB存储移动入站和出站消息，并通过我编写的一些自定义视图报告此流量。前端是用Python编写的。我们没有任何真正的技术问题，它自12月底以来一直在运行。我遇到的唯一障碍是最初从MapReduce的角度思考，但一旦我学会了如何做到这一点，其他一切都很顺利。

CouchDB 0.11(发布于3月底)是1.0版本的特性冻结版。这意味着我们将保持与当前1.0版API的兼容性，所以现在是重新研究CouchDB的好时机(如果您很久没有研究过)。

CouchDB 0.11源代码发布在这里。这里链接了二进制安装程序和其他好东西。

我们将CouchDB作为MySQL的替代品运行在我们的商店(70.0000个商品/商店，所有商品的属性总数为400万个，商品之间的交叉连接)。

我们的目标是:

从master-db轻松复制到具有不同文档的多个客户端。 快速预计算数据，比如“这个属性和那个过滤器有多少部分符合这些条件”

事实:

我们的商店现在运行得比使用MySQL快得多(MySQL数据库需要额外的1-3天的预计算(因此每月更新两次)，使数据为产品计数和过滤做好准备，CouchDB需要5个小时，所以我们可以每晚更新产品数据) 设置(过滤)数据分布和备份到商店节点是快速和容易的

但也:

Understanding map/reduce and the limits of not having joins is quite hard No operation on data like "delete where" or "update where" without external programs Replication works well, unless there is a problem; then it's really hard to find out what was the reason (for beginners) The installation of CouchDB without binaries (yes there are a some in the wild, but not for every OS/version) could be hard, if you are not a Linux geek. But the CouchDB Community is helpful (#couchdb), and luckily there are companies out there (cloudant, iriscouch) that offer services from free to big business. CouchDB is moving forward, so there are a lot of changes (improvements) going on that might change they way you work. But basic things remain stable.

结果是: MySQL作为数据创建和维护的数据库是可靠的，易于理解和处理。我认为我们不会改变这一点。 但我也不想错过CouchDB视图的强大功能和复制设置的便利性。

在工作了几个月之后，生产沙发有时会因为错误配置和忘记日志(视图构建花费太长时间或挂起，复制停止)而造成麻烦，但从未丢失数据，并且总是可以轻松重置。

MongoDB在授权给企业方面存在一些问题，我不确定细节，但我们的法律部门不明确地告诉我们，我们不允许在我们的任何产品中使用MongoDB。

下面是mongoDB生产部署站点的列表

The New Yorks Times: Using it in a form-building application for photo submissions. Mongo's lack of schema gives producers the ability to define any combination of custom form fields. SourceForge: is used for back-end storage on the SourceForge front pages, project pages, and download pages for all projects. Bit.ly Etsy IGN: powers IGN’s real-time traffic analytics and RESTful Content APIs. Justin.tv: powers Justin.tv's internal analytics tools for virality, user retention, and general usage stats that out-of-the-box solutions can't provide. Posterous Intuit Foursquare: Sharded Mongo databases are used for most data at foursquare. Business Insider: Using it since the beginning of 2008. All of the site's data, including posts, comments, and even the images, are stored on MongoDB. Github: is used for an internal reporting application. Examiner: migrated their site from Cold Fusion and SQL Server to Drupal 7 and MongoDB. Grooveshark: currently uses Mongo to manage over one million unique user sessions per day. Buzzfeed Discus Evite: Used for analytics and quick reporting. Squarespace Shutterfly: is used for various persistent data storage requirements within Shutterfly. MongoDB helps Shutterfly build an unrivaled service that enables deeper, more personal relationships between customers and those who matter most in their lives. Topsy Sharethis Mongohq: provides a hosting platform for MongoDB and also uses MongoDB as the back-end for its service. Our hosting centers page provides more information about MongoHQ and other MongoDB hosting options.

和更多的……

提取: http://lineofthought.com/tools/mongodb

你也可以在那里查看其他数据库或工具。