{"id":987,"date":"2015-03-21T21:36:25","date_gmt":"2015-03-21T13:36:25","guid":{"rendered":"http:\/\/zerobox.org\/notes\/?p=987"},"modified":"2016-06-02T19:36:57","modified_gmt":"2016-06-02T11:36:57","slug":"mongodb%e4%bd%bf%e7%94%a8%e5%b0%8f%e7%bb%93","status":"publish","type":"post","link":"http:\/\/zerobox.org\/notes\/987.html","title":{"rendered":"MongoDB\u4f7f\u7528\u5c0f\u7ed3"},"content":{"rendered":"

\u6765\u6e90:http:\/\/www.cnblogs.com\/cswuyg\/p\/4355948.html<\/p>\n

\u6700\u8fd1\u4e00\u5e74\u5fd9\u788c\u4e8e\u6570\u636e\u5904\u7406\u76f8\u5173\u7684\u5de5\u4f5c\uff0c\u8ddfMongoDB\u6253\u4ea4\u9053\u6781\u591a\uff0c\u4ee5\u4e0b\u4e3a\u5b9e\u8df5\u8fc7\u7a0b\u4e2d\u7684Q&A\uff0c\u540e\u7eed\u4f1a\u4e0d\u5b9a\u671f\u66f4\u65b0\u8865\u5145\u3002<\/p>\n

1\u3001count\u7edf\u8ba1\u7ed3\u679c\u9519\u8bef<\/p>\n

\u8fd9\u662f\u7531\u4e8e\u5206\u5e03\u5f0f\u96c6\u7fa4\u6b63\u5728\u8fc1\u79fb\u6570\u636e\uff0c\u5b83\u5bfc\u81f4count\u7ed3\u679c\u503c\u9519\u8bef\uff0c\u9700\u8981\u4f7f\u7528aggregate pipeline\u6765\u5f97\u5230\u6b63\u786e\u7edf\u8ba1\u7ed3\u679c\uff0c\u4f8b\u5982\uff1a<\/p>\n

db.collection.aggregate([{$group: {_id: null, count: {$sum: 1}}}])<\/p>\n

\u5f15\u7528\uff1a\u201cOn a sharded cluster, count can result in an inaccurate count if orphaned documents exist or if a chunk migration is in progress.\u201d<\/p>\n

\u53c2\u8003\uff1ahttp:\/\/docs.mongodb.org\/manual\/reference\/command\/count\/<\/p>\n

2\u3001\u4eceshell\u4e2d\u66f4\u65b0\/\u5199\u5165\u5230\u6587\u6863\u7684\u6570\u5b57\uff0c\u4f1a\u53d8\u4e3afloat\u7c7b\u578b<\/p>\n

\u5f15\u7528\uff1a\u201cshell\u4e2d\u7684\u6570\u5b57\u90fd\u88abMongoDB\u5f53\u4f5c\u662f\u53cc\u7cbe\u5ea6\u6570\u3002\u8fd9\u610f\u5473\u7740\u5982\u679c\u4f60\u4ece\u6570\u636e\u5e93\u4e2d\u83b7\u5f97\u7684\u662f\u4e00\u4e2a32\u4f4d\u6574\u6570\uff0c\u4fee\u6539\u6587\u6863\u540e\uff0c\u5c06\u6587\u6863\u5b58\u56de\u6570\u636e\u5e93\u7684\u65f6\u5019\uff0c\u8fd9\u4e2a\u6574\u6570\u4e5f\u5c31\u88ab\u6362\u6210\u4e86\u6d6e\u70b9\u6570\uff0c\u5373\u4fbf\u4fdd\u6301\u8fd9\u4e2a\u6574\u6570\u539f\u5c01\u4e0d\u52a8\u4e5f\u4f1a\u8fd9\u6837\u7684\u3002\u201d<\/p>\n

\u53c2\u8003\uff1a\u300aMongoDB\u6743\u5a01\u6307\u5357\u300b\u7b2c\u4e00\u7248<\/p>\n

3\u3001restore\u6570\u636e\u5230\u65b0DB\u65f6\uff0c\u4e0d\u8981\u53bb\u5148\u5efa\u7d22\u5f15<\/p>\n

\u628abson\u6570\u636e\u6587\u4ef6restore\u5230\u53e6\u4e00\u4e2aDB\u65f6\uff0c\u9700\u8981\u6ce8\u610f\uff1a\u4e0d\u80fd\u5148\u521b\u5efa\u7d22\u5f15\u518drestore\u6570\u636e\uff0c\u5426\u5219\u6027\u80fd\u6781\u5dee\uff0cmongorestore\u5de5\u5177\u9ed8\u8ba4\u4f1a\u5728restore\u5b8c\u6570\u636e\u65f6\uff0c\u6839\u636edump\u51fa\u6765\u7684index\u4fe1\u606f\u521b\u5efa\u7d22\u5f15\uff0c\u65e0\u987b\u81ea\u5df1\u521b\u5efa\uff0c\u5982\u679c\u662f\u8981\u66f4\u6362\u7d22\u5f15\uff0c\u4e5f\u5e94\u8be5\u5728\u6570\u636e\u5165\u5e93\u5b8c\u4e4b\u540e\u518d\u521b\u5efa\u3002<\/p>\n

4\u3001DB\u4e2d\u7684namespace\u6570\u91cf\u592a\u591a\u5bfc\u81f4\u65e0\u6cd5\u521b\u5efa\u65b0\u7684collection<\/p>\n

\u9519\u8bef\u63d0\u793a\uff1aerror: hashtable namespace index max chain reached:1335\uff0c\u5982\u4f55\u89e3\u51b3\u5462\uff1f
\n\u8fd9\u662fDB\u4e2d\u7684collection\u4e2a\u6570\u592a\u591a\u5bfc\u81f4\uff0c\u5728\u5b9e\u8df5\u4e2d\u4ee5\u6bcf\u4e2acollection 8KB\u8ba1\u7b97\uff08\u8ddf\u5b98\u65b9\u6587\u6863\u91cc\u8bf4\u7684\u4e0d\u540c\uff0c\u53ef\u80fd\u8ddfindex\u6709\u5173\u7cfb\uff09\uff0c256MB\u53ef\u4ee5\u652f\u630136000\u4e2acollection\u3002db.system.namespaces.count() \u547d\u4ee4\u53ef\u4ee5\u7edf\u8ba1\u5f53\u524dDB\u5185\u7684collection\u6570\u76ee\uff0cDB\u53ef\u652f\u6301collection\u6570\u91cf\u662f\u7531\u4e8enssize\u53c2\u6570\u6307\u5b9a\u7684\uff0c\u5b83\u6307\u5b9a\u4e86dbname.ns\u78c1\u76d8\u6587\u4ef6\u7684\u5927\u5c0f\uff0c\u4e5f\u5c31\u6307\u5b9a\u4e86DB\u53ef\u652f\u6301\u7684\u6700\u5927collection\u6570\u76ee\uff0cns\u4e3anamespace\u7f29\u5199\u3002\u9ed8\u8ba4nssize\u4e3a16MB\u3002
\n\u5982\u679c\u91cd\u542fMongoD\u5e76\u4fee\u6539\u4e86nssize\u53c2\u6570\uff0c\u8fd9\u65b0nssize\u53ea\u4f1a\u5bf9\u65b0\u52a0\u5165\u7684DB\u751f\u6548\uff0c\u5bf9\u4ee5\u524d\u5df2\u7ecf\u5b58\u5728\u7684DB\u4e0d\u751f\u6548\uff0c\u5982\u679c\u4f60\u60f3\u5bf9\u5df2\u7ecf\u5b58\u5728\u7684DB\u91c7\u7528\u65b0\u7684nssize\uff0c\u5fc5\u987b\u5728\u52a0\u5927nssize\u91cd\u542f\u4e4b\u540e\u65b0\u5efaDB\uff0c\u7136\u540e\u628a\u65e7DB\u7684collection \u590d\u5236\u5230\u65b0DB\u4e2d\u3002
\nnamespace\u9650\u5236\u76f8\u5173\u6587\u6863\uff1ahttp:\/\/docs.mongodb.org\/manual\/reference\/limits\/#Number-of-Namespaces<\/p>\n

5\u3001moveChunk\u56e0\u65e7\u6570\u636e\u672a\u5220\u9664\u800c\u5931\u8d25<\/p>\n

\u9519\u8bef\u65e5\u5fd7\uff1a\u201dmoveChunk failed to engage TO-shard in the data transfer: can’t accept new chunks because there are still 1 deletes from previous migration\u201c\u3002
\n\u610f\u601d\u662f\u8bf4\uff0c\u5f53\u524d\u6b63\u8981\u53bb\u63a5\u53d7\u65b0chunk \u7684shard\u6b63\u5728\u5220\u9664\u4e0a\u4e00\u6b21\u6570\u636e\u8fc1\u79fb\u51fa\u7684\u6570\u636e\uff0c\u4e0d\u80fd\u63a5\u53d7\u65b0Chunk\uff0c\u4e8e\u662f\u672c\u6b21\u8fc1\u79fb\u5931\u8d25\u3002\u8fd9\u79cdlog\u91cc\u663e\u793a\u7684\u662fwarning\uff0c\u4f46\u6709\u65f6\u5019\u4f1a\u53d1\u73b0shard\u7684\u5220\u9664\u6301\u7eed\u4e86\u5341\u51e0\u5929\u90fd\u6ca1\u5b8c\u6210\uff0c\u67e5\u770b\u65e5\u5fd7\uff0c\u53ef\u4ee5\u53d1\u73b0\u540c\u4e00\u4e2achunk\u7684\u5220\u9664\u5728\u4e0d\u65ad\u91cd\u590d\u6267\u884c\uff0c\u91cd\u542f\u6240\u6709\u65e0\u6cd5\u63a5\u53d7\u65b0chunk\u7684shard\u53ef\u4ee5\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\u3002
\n\u53c2\u8003\uff1a
\nhttp:\/\/stackoverflow.com\/questions\/26640861\/movechunk-failed-to-engage-to-shard-in-the-data-transfer-cant-accept-new-chunk
\n\u5982\u679c\u91c7\u7528\u4e86balancer\u81ea\u52a8\u5747\u8861\uff0c\u90a3\u4e48\u53ef\u4ee5\u52a0\u4e0a_waitForDelete\u53c2\u6570\uff0c\u5982\uff1a
\n{ “_id” : “balancer”, “activeWindow” : { “start” : “12:00”, “stop” : “19:30” }, “stopped” : false, “_waitForDelete” : true }
\n\uff0c\u8fd9\u6837\u5c31\u4e0d\u4f1a\u56e0delete\u5806\u79ef\u800c\u5bfc\u81f4\u540e\u7eedmigrate\u5931\u8d25\uff0c\u5f53\u7136\uff0c\u9700\u8981\u8003\u8651\u5230\u8fd9\u91cc\u7684\u963b\u585e\u662f\u5426\u4f1a\u5f71\u54cd\u5230\u7a0b\u5e8f\u6b63\u5e38\u8fd0\u8f6c\uff0c\u5728\u5b9e\u8df5\u4e2d\u614e\u91cd\u91c7\u7528\u4f7f\u7528waitForDelete<\/strong>\uff0c\u56e0\u4e3a\u53d1\u73b0\u52a0\u4e0a\u5b83\u4e4b\u540e\u8fc1\u79fb\u6027\u80fd\u975e\u5e38\u5dee\uff0c\u53ef\u80fd\u51fa\u73b0\u5361\u4f4f\u5341\u51e0\u4e2a\u5c0f\u65f6\u7684\u60c5\u51b5\uff0c\u5916\u754c\u62ff\u4f4f\u4e86\u88ab\u8fc1\u79fbchunk\u7684\u6e38\u6807\u53e5\u67c4\uff0c\u8fd9\u65f6\u5019\u5220\u9664\u4e0d\u80fd\u6267\u884c\uff0c\u963b\u585e\u4e86\u540e\u7eed\u5176\u5b83\u8fc1\u79fb\u64cd\u4f5c\u3002
\n\u6e38\u6807\u88ab\u6253\u5f00\u800c\u5bfc\u81f4\u88ab\u8fc1\u79fb\u6570\u636e\u65e0\u6cd5\u53ca\u65f6\u5220\u9664\u65f6\u7684\u65e5\u5fd7\uff1a
\n2015-03-07T10:21:20.118+0800 [RangeDeleter] rangeDeleter waiting for open cursors in: cswuyg_test.cswuyg_test, min: { _id: -6665031702664277348 }, max: { _id: -6651575076051867067 }, elapsedSecs: 6131244, cursors: [ 220477635588 ]
\n\u8fd9\u53ef\u80fd\u4f1a\u5361\u4f4f\u51e0\u5341\u5c0f\u65f6\uff0c\u751a\u81f3\u4e00\u76f4\u5361\u4f4f\uff0c\u5f71\u54cd\u540e\u7eed\u7684moveChunk\u64cd\u4f5c\uff0c\u5bfc\u81f4\u6570\u636e\u4e0d\u5747\u8861\u3002
\n\u89e3\u51b3\u65b9\u6cd5\u8fd8\u662f\uff1a\u91cd\u542f\u3002<\/p>\n

6\u3001bson size\u4e0d\u80fd\u8d85\u8fc716MB\u7684\u9650\u5236<\/p>\n

\u5355\u4e2a\u6587\u6863\u7684BSON size\u4e0d\u80fd\u8d85\u8fc716MB\u3002find\u67e5\u8be2\u6709\u65f6\u4f1a\u9047\u523016MB\u7684\u9650\u5236\uff0c\u8b6c\u5982\u4f7f\u7528$in \u67e5\u8be2\u7684\u65f6\u5019\uff0cin\u4e2d\u7684\u6570\u7ec4\u5143\u7d20\u4e0d\u80fd\u592a\u591a\u3002\u5bf9\u4e00\u4e9b\u7279\u6b8a\u7684\u6570\u636e\u6e90\u505aMapReduce\uff0cMapReduce\u4e2d\u95f4\u4f1a\u5c06\u6570\u636e\u7ec4\u5408\u4e3a\u201cKEY\uff1a[VALUE1\u3001VALUE2]\u201d\u8fd9\u6837\u7684\u683c\u5f0f\uff0c\u5f53value\u7279\u522b\u591a\u7684\u65f6\u5019\uff0c\u4e5f\u53ef\u80fd\u4f1a\u9047\u4e0a16MB\u7684\u9650\u5236\u3002 \u9650\u5236\u65e0\u5904\u4e0d\u5728\uff0c\u9700\u8981\u6ce8\u610f\uff0c\u201dThe issue is that the 16MB document limit applies to everything – documents you store, documents MapReduce tries to generate, documents aggregation tries to return, etc.<\/p>\n

7\u3001\u6279\u91cf\u63d2\u5165<\/p>\n

\u6279\u91cf\u63d2\u5165\u53ef\u4ee5\u51cf\u5c11\u6570\u636e\u5f80\u670d\u52a1\u5668\u7684\u63d0\u4ea4\u6b21\u6570\uff0c\u63d0\u9ad8\u6027\u80fd\uff0c\u4e00\u822c\u6279\u91cf\u63d0\u4ea4\u7684BSON size\u4e0d\u8d85\u8fc748MB\uff0c\u5982\u679c\u8d85\u8fc7\u4e86\uff0c\u9a71\u52a8\u7a0b\u5e8f\u81ea\u52a8\u4fee\u6539\u4e3a\u5f80mongos\u7684\u591a\u6b21\u63d0\u4ea4\u3002<\/p>\n

8\u3001\u5b89\u5168\u5199\u5165\u4ecb\u7ecd\u53ca\u5176\u6cbf\u9769<\/p>\n

\u5173\u952e\u5b57\uff1aacknowledge\u3001write concern\u3002<\/p>\n

\u57282012\u5e7411\u6708\u4e4b\u524d\uff0cMongoDB\u9a71\u52a8\u3001shell\u5ba2\u6237\u7aef\u9ed8\u8ba4\u662f\u4e0d\u5b89\u5168\u5199\u5165\uff0c\u4e5f\u5c31\u662ffire-and-forget\uff0c\u52a8\u4f5c\u53d1\u51fa\u4e4b\u540e\uff0c\u4e0d\u5173\u5fc3\u662f\u5426\u771f\u7684\u5199\u5165\u6210\u529f\uff0c\u5982\u679c\u8fd9\u65f6\u5019\u51fa\u73b0\u4e86_id\u91cd\u590d\u3001\u975eUTF8\u5b57\u7b26\u7b49\u5f02\u5e38\uff0c\u5ba2\u6237\u7aef\u4e0d\u4f1a\u77e5\u9053\u3002\u57282012\u5e7411\u6708\u4e4b\u540e\uff0c\u9ed8\u8ba4\u4e3a\u5b89\u5168\u5199\u5165\uff0c\u5b89\u5168\u7ea7\u522b\u76f8\u5f53\u4e8e\u53c2\u6570w=1\uff0c\u5ba2\u6237\u7aef\u53ef\u4ee5\u77e5\u9053\u5199\u5165\u64cd\u4f5c\u662f\u5426\u6210\u529f\u3002\u5982\u679c\u4ee3\u7801\u4f7f\u7528Mongo\u6216\u8005Collection\u6765\u8fde\u63a5\u6570\u636e\u5e93\uff0c\u5219\u8bf4\u660e\u5b83\u662f\u9ed8\u8ba4\u4e0d\u5b89\u5168\u5199\u5165\u7684legacy\u4ee3\u7801\uff0c\u5b89\u5168\u5199\u5165\u5df2\u7ecf\u628a\u8fde\u63a5\u6570\u636e\u5e93\u4fee\u6539\u4e3aMongoClient\u63a5\u53e3\u3002
\n\u5b89\u5168\u5199\u5165\u53ef\u4ee5\u5206\u4e3a\u4e09\u4e2a\u7ea7\u522b\uff0c
\n\u7b2c\u4e00\u7ea7\u662f\u9ed8\u8ba4\u7684\u5b89\u5168\u5199\u5165\uff0c\u786e\u8ba4\u6570\u636e\u5199\u5165\u5230\u5185\u5b58\u4e2d\u5c31\u8fd4\u56de\uff08w=N\u5c5e\u4e8e\u8fd9\u4e00\u7ea7\uff09\uff1b
\n\u7b2c\u4e8c\u7ea7\u662fJournal save\uff0c\u6570\u636e\u5728\u5199\u5165\u5230DB\u78c1\u76d8\u6587\u4ef6\u4e4b\u524d\uff0cMongoDB\u4f1a\u5148\u628a\u64cd\u4f5c\u5199\u5165\u5230Journal\u6587\u4ef6\uff0c\u8fd9\u4e00\u7ea7\u6307\u7684\u662f\u786e\u8ba4\u5199\u5165\u4e86Journal\u6587\u4ef6\u5c31\u8fd4\u56de\uff1b
\n\u7b2c\u4e09\u7ea7\u662ffysnc\uff0c\u6240\u6709\u6570\u636e\u5237\u5199\u5230\u5230DB\u78c1\u76d8\u6587\u4ef6\u624d\u8fd4\u56de\u3002
\n\u4e00\u822c\u7b2c\u4e00\u7ea7\u5c31\u8db3\u591f\u4e86\uff0c\u7b2c\u4e8c\u7ea7\u662f\u4e3a\u4e86\u4fdd\u8bc1\u5728\u673a\u5668\u5f02\u5e38\u65ad\u7535\u7684\u60c5\u51b5\u4e0b\u4e5f\u4e0d\u4f1a\u4e22\u5931\u6570\u636e\u3002\u5b89\u5168\u5199\u5165\u8981\u4ed8\u51fa\u6027\u80fd\u7684\u4ee3\u7801\uff1a\u4e0d\u5b89\u5168\u5199\u5165\u7684\u6027\u80fd\u5927\u6982\u662f\u9ed8\u8ba4\u5b89\u5168\u5199\u5165\u76843\u500d\u3002\u4f7f\u7528fync\u53c2\u6570\u5219\u6027\u80fd\u66f4\u5dee\uff0c\u4e00\u822c\u4e0d\u4f7f\u7528\u3002
\n\u5982\u679c\u662f\u526f\u672c\u96c6\uff08replica set\uff09\uff0c\u5176w=N\u53c2\u6570\uff0cN\u8868\u793a\u5b89\u5168\u5199\u5165\u5230\u591a\u5c11\u4e2a\u526f\u672c\u96c6\u624d\u8fd4\u56de\u3002
\n\u53c2\u8003\uff1a
\nhttp:\/\/docs.mongodb.org\/manual\/release-notes\/drivers-write-concern\/
\nhttp:\/\/docs.mongodb.org\/manual\/core\/write-concern\/
\nhttp:\/\/blog.mongodirector.com\/understanding-durability-write-safety-in-mongodb\/
\nhttp:\/\/whyjava.wordpress.com\/2011\/12\/08\/how-mongodb-different-write-concern-values-affect-performance-on-a-single-node\/<\/p>\n

9\u3001\u5584\u7528\u7d22\u5f15\u2014\u2014\u53ef\u80fd\u8ddf\u4f60\u4ee5\u4e3a\u7684\u4e0d\u4e00\u6837<\/p>\n

\u4f7f\u7528\u7ec4\u5408\u7d22\u5f15\u7684\u65f6\u5019\uff0c\u5982\u679c\u6709\u4e24\u7ec4\u7d22\u5f15\uff0c\u5728\u9650\u91cf\u67e5\u8be2\u7684\u60c5\u51b5\u4e0b\uff0c\u53ef\u80fd\u8ddf\u5e38\u89c4\u7684\u8ba4\u8bc6\u4e0d\u540c\uff1a
\n\u5229\u7528\u7ec4\u5408\u7d22\u5f15\u505a\u7684\u67e5\u8be2\uff0c\u5728\u4e0d\u540c\u6570\u91cf\u7ea7\u4e0b\u4f1a\u6709\u4e0d\u540c\u6027\u80fd\uff1a
\n\u7ec4\u5408\u7d22\u5f15A\uff1a {“age”: 1, “username”: 1}
\n\u7ec4\u5408\u7d22\u5f15B\uff1a {“username”: 1, “age”: 1}
\n\u5168\u91cf\u67e5\u8be2\uff1a db.user.find({“age”: {“$gte”: 21, “$lte”: 30}}).sort({“username” :1})\uff0c\u4f7f\u7528\u7d22\u5f15A\u7684\u6027\u80fd\u4f18\u4e8e\u7d22\u5f15B\u3002
\n\u9650\u91cf\u67e5\u8be2\uff1a db.user.find({“age”: {“$gte”: 21, “$lte”: 30}}).sort({“username”: 1}).limit(1000)\uff0c\u4f7f\u7528\u7d22\u5f15B\u7684\u6027\u80fd\u4f18\u4e8e\u7d22\u5f15A\u3002
\n\u8fd9\u4e24\u4e2a\u67e5\u8be2\u5728\u4f7f\u7528\u7d22\u5f15A\u7684\u65f6\u5019\uff0c\u662f\u5148\u6839\u636eage\u7d22\u5f15\u627e\u5230\u7b26\u5408age\u7684\u6570\u636e\uff0c\u7136\u540e\u518d\u5bf9\u8fd9\u4e9b\u7ed3\u679c\u505a\u6392\u5e8f\u3002\u4f7f\u7528\u7d22\u5f15B\u7684\u65f6\u5019\uff0c\u662f\u904d\u5386name\uff0c\u5bf9\u5e94\u7684\u6570\u636e\u5224\u65adage\uff0c\u7136\u540e\u5f97\u5230\u7684\u7ed3\u679c\u662fname\u6709\u5e8f\u7684\u3002
\n\u4f18\u5148\u4f7f\u7528sort key\u7d22\u5f15\uff0c\u5728\u5927\u591a\u6570\u5e94\u7528\u4e0a\u6267\u884c\u5f97\u5f88\u597d\u3002
\n\u53c2\u8003\uff1a\u300aMongoDB\u2014\u2014The Definitive Guide 2nd Edition\u300bpage89<\/p>\n

10\u3001\u67e5\u8be2\u65f6\u7d22\u5f15\u4f4d\u7f6e\u7684\u65e0\u987a\u5e8f\u6027<\/p>\n

\u505afind\u7684\u65f6\u5019\uff0c\u5e76\u4e0d\u8981\u6c42\u7d22\u5f15\u4e00\u5b9a\u8981\u5728\u524d\u9762\uff0c
\n\u8b6c\u5982\uff1a
\ndb.test\u96c6\u5408\u4e2d\u5bf9R\u6709\u7d22\u5f15
\ndb.test.find({R:”AA”, “H”: “BB”}).limit(100).explain()
\ndb.test.find({“H”:”BB”, “R” : “AA”}).limit(100).explain()
\n\u8fd9\u4e24\u4e2a\u67e5\u627e\u6027\u80fd\u4e00\u6837\uff0c\u5b83\u90fd\u4f1a\u4f7f\u7528R\u7d22\u5f15\u3002<\/p>\n

11\u3001\u4f7f\u7528\u7ec4\u5408\u7d22\u5f15\u505ashard key\u53ef\u4ee5\u5927\u5e45\u5ea6\u63d0\u9ad8\u96c6\u7fa4\u6027\u80fd<\/p>\n

\u201c\u56fa\u5b9a\u503c+\u589e\u91cf\u503c\u201d \u4e24\u5b57\u6bb5\u505a\u7ec4\u5408\u7d22\u5f15\u53ef\u4ee5\u6709\u6548\u7684\u5b9e\u73b0\u5206\u5e03\u5f0f\u96c6\u7fa4\u4e2d\u7684\u5206\u6563\u591a\u70ed\u70b9\u5199\u5165\u3001\u8bfb\u53d6\u3002\u4ee5\u4e0b\u4e3a\u8bfb\u4e66\u7b14\u8bb0\uff1a
\n\u5728\u5355\u4e2aMongoDB\u5b9e\u4f8b\u4e0a\uff0c\u6700\u9ad8\u6548\u7684\u5199\u5165\u662f\u987a\u5e8f\u5199\u5165\uff0c\u800cMongoDB\u96c6\u7fa4\u5219\u8981\u6c42\u5199\u5165\u80fd\u968f\u673a\uff0c\u4ee5\u4fbf\u5e73\u5747\u5206\u6563\u5230\u591a\u4e2aMongoDB\u5b9e\u4f8b\u3002\u6240\u4ee5\u6700\u9ad8\u6548\u7684\u5199\u5165\u662f\u6709\u591a\u4e2a\u5c40\u90e8\u70ed\u70b9\uff1a\u5728\u591a\u4e2aMongoDB\u5b9e\u4f8b\u4e4b\u95f4\u662f\u5206\u6563\u5199\u5165\uff0c\u5728\u5b9e\u4f8b\u5185\u90e8\u662f\u987a\u5e8f\u5199\u5165\u3002 \u8981\u5b9e\u73b0\u8fd9\u4e00\u70b9\uff0c\u6211\u4eec\u91c7\u7528\u7ec4\u5408\u7d22\u5f15\u3002
\n\u4f8b\u5982\uff1ashardkey\u7684\u7b2c\u4e00\u90e8\u5206\u662f\u5f88\u7c97\u7cd9\u7684\uff0c\u53ef\u9009\u96c6\u5f88\u5c11\u7684\u5b57\u6bb5\uff0c\u7d22\u5f15\u7684\u7b2c\u4e8c\u90e8\u5206\u662f\u9012\u589e\u5b57\u6bb5\uff0c\u5f53\u6570\u636e\u589e\u52a0\u5230\u4e00\u5b9a\u7a0b\u5ea6\u65f6\uff0c\u4f1a\u51fa\u73b0\u5f88\u591a\u7b2c\u4e00\u90e8\u5206\u76f8\u540c\u7b2c\u4e8c\u90e8\u5206\u4e0d\u540c\u7684chunk\uff0c\u6570\u636e\u53ea\u4f1a\u5728\u6700\u540e\u4e00\u4e2achunk\u91cc\u5199\u5165\u6570\u636e\uff0c\u5f53\u7b2c\u4e00\u90e8\u5206\u4e0d\u540c\u7684chunk\u5206\u6563\u5728\u591a\u4e2ashard\u4e0a\uff0c\u5c31\u5b9e\u73b0\u4e86\u591a\u70ed\u70b9\u7684\u5199\u5165\u3002\u5982\u679c\u5728\u4e00\u4e2ashard\u4e0a\uff0c\u4e0d\u6b62\u4e00\u4e2achunk\u53ef\u4ee5\u5199\u5165\u6570\u636e\uff0c\u90a3\u4e5f\u5c31\u662f\u8bf4\u4e0d\u6b62\u4e00\u4e2a\u70ed\u70b9\uff0c\u5f53\u70ed\u70b9\u975e\u5e38\u591a\u7684\u65f6\u5019\uff0c\u4e5f\u5c31\u7b49\u540c\u4e8e\u65e0\u70ed\u70b9\u7684\u968f\u673a\u5199\u5165\u3002\u5f53\u4e00\u4e2achunk\u5206\u88c2\u4e4b\u540e\uff0c\u53ea\u80fd\u6709\u4e00\u4e2a\u6210\u4e3a\u70ed\u70b9\uff0c\u53e6\u4e00\u4e2a\u4e0d\u80fd\u518d\u88ab\u5199\u5165\uff0c\u5426\u5219\u5c31\u4f1a\u4ea7\u751f\u4e24\u4e2a\u70ed\u70b9\uff0c\u4e0d\u518d\u5199\u5165\u7684chunk\u4e5f\u5c31\u662f\u6b7b\u6389\u4e86\uff0c\u540e\u7eed\u53ea\u4f1a\u5bf9\u5b83\u6709\u8bfb\u64cd\u4f5c\u3002
\n\u6211\u5728\u5b9e\u8df5\u4e2d\u9664\u4e86\u4e66\u4e2d\u8bb2\u5230\u7684\u7ec4\u5408\u952e\u65b9\u5f0f\u5916\uff0c\u8fd8\u52a0\u4e0a\u4e86\u9884\u5206\u7247\u7b56\u7565\uff0c\u907f\u514d\u4e86\u65e9\u671f\u6570\u636e\u589e\u957f\u8fc7\u7a0b\u4e2d\u7684\u5206\u7247\u548c\u6570\u636e\u8fc1\u79fb\u3002\u53e6\u5916\u8fd8\u5c3d\u53ef\u80fd\u7684\u5236\u9020\u80fd\u5229\u7528\u5c40\u90e8\u6027\u539f\u7406\u7684\u6570\u636e\u5199\u5165\uff0c\u4f8b\u5982\u5728\u6570\u636e\u5199\u5165\u4e4b\u524d\u5148\u5bf9\u6570\u636e\u6392\u5e8f\uff0c\u6709\u5927\u7ea630%\u5de6\u53f3\u7684update\u6027\u80fd\u63d0\u5347\u3002
\n\u9884\u5206\u7247\u662f\u8fd9\u6837\u5b50\u505a\u7684\uff1a\u6839\u636e\u7ec4\u5408shardkey\u4fe1\u606f\u5148\u5206\u88c2\u597dchunk\uff0c\u628a\u8fd9\u4e9b\u7a7achunk\u79fb\u52a8\u5230\u5404\u4e2ashard\u4e0a\uff0c\u907f\u514d\u4e86\u540e\u7eed\u81ea\u52a8\u5206\u88c2\u5f15\u8d77\u7684\u6570\u636e\u8fc1\u79fb\u3002
\n\u53c2\u8003\uff1a\u300aMongoDB\u2014\u2014The Definitive Guide 2nd Edition\u300b page268<\/p>\n

12\u3001\u600e\u4e48\u5efa\u7d22\u5f15\u66f4\u80fd\u63d0\u9ad8\u67e5\u8be2\u6027\u80fd\uff1f<\/p>\n

\u5728\u67e5\u8be2\u65f6\uff0c\u7d22\u5f15\u662f\u5426\u9ad8\u6548\uff0c\u8981\u6ce8\u610f\u5b83\u7684cardinality\uff08cardinality\u8d8a\u9ad8\u8868\u793a\u8be5\u952e\u53ef\u9009\u62e9\u7684\u503c\u8d8a\u591a\uff09\uff0c\u5728\u7ec4\u5408\u7d22\u5f15\u4e2d\uff0c\u8ba9cardinality\u9ad8\u7684\u653e\u5728\u524d\u9762\u3002\u6ce8\u610f\u8fd9\u91cc\u8ddf\u5206\u5e03\u5f0f\u73af\u5883\u9009\u62e9shard key\u7684\u4e0d\u540c\u3002\u4ee5\u4e0b\u4e3a\u8bfb\u4e66\u7b14\u8bb0\uff1a
\nindex cardinality\uff08\u7d22\u5f15\u6563\u5217\u7a0b\u5ea6\uff09\uff0c\u8868\u793a\u7684\u662f\u4e00\u4e2a\u7d22\u5f15\u6240\u5bf9\u5e94\u5230\u7684\u503c\u7684\u591a\u5c11\uff0c\u6563\u5217\u7a0b\u5ea6\u8d8a\u4f4e\uff0c\u5219\u4e00\u4e2a\u7d22\u5f15\u5bf9\u5e94\u7684\u503c\u8d8a\u591a\uff0c\u7d22\u5f15\u6548\u679c\u8d8a\u5dee\uff1a\u5728\u4f7f\u7528\u7d22\u5f15\u65f6\uff0c\u9ad8\u6563\u5217\u7a0b\u5ea6\u7684\u7d22\u5f15\u53ef\u4ee5\u66f4\u591a\u7684\u6392\u9664\u4e0d\u7b26\u5408\u6761\u4ef6\u7684\u6587\u6863\uff0c\u8ba9\u540e\u7eed\u7684\u6bd4\u8f83\u5728\u4e00\u4e2a\u66f4\u5c0f\u7684\u96c6\u5408\u4e2d\u6267\u884c\uff0c\u8fd9\u66f4\u9ad8\u6548\u3002\u6240\u4ee5\u4e00\u822c\u9009\u62e9\u9ad8\u6563\u5217\u7a0b\u5ea6\u7684\u952e\u505a\u7d22\u5f15\uff0c\u6216\u8005\u5728\u7ec4\u5408\u7d22\u5f15\u4e2d\uff0c\u628a\u9ad8\u6563\u5217\u7a0b\u5ea6\u7684\u952e\u653e\u5728\u524d\u9762\u3002
\n\u53c2\u8003\uff1a\u300aMongoDB\u2014\u2014The Definitive Guide 2nd Edition\u300b page98<\/p>\n

13\u3001\u975e\u539f\u5730update\uff0c\u6027\u80fd\u4f1a\u5f88\u5dee<\/p>\n

update\u6587\u6863\u65f6\uff0c\u5982\u679c\u65b0\u6587\u6863\u7684\u7a7a\u95f4\u5360\u7528\u5927\u4e8e\u65e7\u6587\u6863\u52a0\u4e0a\u5b83\u5468\u56f4padding\u7684\u7a7a\u95f4\uff0c\u90a3\u4e48\u5c31\u4f1a\u653e\u5f03\u539f\u6765\u7684\u4f4d\u7f6e\uff0c\u628a\u6570\u636e\u62f7\u8d1d\u5230\u65b0\u7a7a\u95f4\u3002
\n\u53c2\u8003\uff1a\u300aMongoDB\u2014\u2014The Definitive Guide 2nd Edition\u300b page43<\/p>\n

14\u3001\u65e0\u6cd5\u5728\u7d22\u5f15\u5efa\u7acb\u4e4b\u540e\u518d\u53bb\u589e\u52a0\u7d22\u5f15\u7684\u8fc7\u671f\u65f6\u95f4<\/p>\n

\u5982\u679c\u7d22\u5f15\u5efa\u7acb\u6307\u5b9a\u4e86\u8fc7\u671f\u65f6\u95f4\uff0c\u540e\u7eed\u8981update\u8fc7\u671f\u65f6\u95f4\u53ef\u4ee5\u8fd9\u6837\u5b50\uff1adb.runCommand({“collMod”:”a”, index:{keyPattern:{“_”:-1}, expireAfterSeconds: 60}})\u3002<\/p>\n

\u6ce8\u610f\uff0c\u901a\u8fc7collMod\u80fd\u4fee\u6539\u8fc7\u671f\u65f6\u95f4\u7684\u524d\u63d0\u662f\uff1a\u8fd9\u4e2a\u7d22\u5f15\u6709\u8fc7\u671f\u65f6\u95f4\uff0c\u5982\u679c\u8fd9\u4e2a\u7d22\u5f15\u4e4b\u524d\u6ca1\u6709\u8bbe\u7f6e\u8fc7\u671f\u65f6\u95f4\uff0c\u90a3\u4e48\u65e0\u6cd5update\uff0c\u53ea\u80fd\u5220\u4e86\u7d22\u5f15\uff0c\u91cd\u5efa\u7d22\u5f15\u5e76\u6307\u5b9a\u8fc7\u671f\u65f6\u95f4\u3002
\n\u53c2\u8003\uff1ahttp:\/\/docs.mongodb.org\/manual\/tutorial\/expire-data\/<\/p>\n

15\u3001_id\u7d22\u5f15\u65e0\u6cd5\u5220\u9664<\/p>\n

\u53c2\u8003\uff1a\u300aMongoDB\u2014\u2014The Definitive Guide 2nd Edition\u300b page114<\/p>\n

16\u3001paddingFactor\u662f\u4ec0\u4e48\uff1f<\/p>\n

\u5b83\u662f\u5b58\u50a8\u7a7a\u95f4\u5197\u4f59\u7cfb\u6570\uff0c1.0\u8868\u793a\u6ca1\u6709\u5197\u4f59\uff0c1.5\u8868\u793a50%\u7684\u5197\u4f59\u7a7a\u95f4\uff0c\u6709\u4e86\u5197\u4f59\u7a7a\u95f4\uff0c\u53ef\u4ee5\u8ba9\u540e\u7eed\u5f15\u53d1size\u589e\u52a0\u7684\u64cd\u4f5c\u66f4\u5feb\uff08\u4e0d\u4f1a\u5bfc\u81f4\u91cd\u65b0\u5206\u914d\u78c1\u76d8\u7a7a\u95f4\u548c\u6587\u6863\u8fc1\u79fb\uff09\uff0c\u4e00\u822c\u662f\u57281\u52304\u4e4b\u95f4\u3002\u53ef\u4ee5\u901a\u8fc7db.collection.stats()\u770b\u5230collection\u7684\u8be5\u503c\u201cpaddingFactor\u201d\u3002
\n\u8be5\u503c\u662fMongoDB\u81ea\u5df1\u5904\u7406\u7684\uff0c\u4f7f\u7528\u8005\u65e0\u6cd5\u8bbe\u7f6epaddingFactor\u3002\u6211\u4eec\u53ef\u4ee5\u5728compact\u7684\u65f6\u5019\u5bf9\u5df2\u7ecf\u6709\u7684\u6587\u6863\u6307\u5b9a\u8be5\u503c\uff0c\u4f46\u8fd9\u4e2apaddingFactor\u503c\u4e0d\u5f71\u54cd\u540e\u7eed\u65b0\u63d2\u5165\u7684\u6587\u6863\u3002
\nrepairDatabase\u8ddfcompact\u7c7b\u4f3c\uff0c\u4e5f\u80fd\u79fb\u9664\u5197\u4f59\u51cf\u5c11\u5b58\u50a8\u7a7a\u95f4\uff0c\u4f46\u5197\u4f59\u7a7a\u95f4\u5c11\u4e86\u4f1a\u5bfc\u81f4\u540e\u7eed\u589e\u52a0\u6587\u6863size\u7684update\u64cd\u4f5c\u53d8\u6162\u3002
\n\u867d\u7136\u6211\u4eec\u65e0\u6cd5\u8bbe\u7f6epaddingFactor\uff0c\u4f46\u662f\u53ef\u4ee5\u4f7f\u7528usePowerOf2Sizes\u4fdd\u8bc1\u5206\u914d\u7684\u7a7a\u95f4\u662f2\u7684\u500d\u6570\uff0c\u8fd9\u6837\u4e5f\u53ef\u4ee5\u8d77\u5230\u4f5c\u7528\uff08MongoDB2.6\u7248\u672c\u8d77\u9ed8\u8ba4\u542f\u7528usePowerOf2Size\uff09\u3002
\n\u6216\u8005\u624b\u52a8\u5b9e\u73b0padding\uff1a\u5728\u63d2\u5165\u6587\u6863\u7684\u65f6\u5019\u5148\u7528\u9ed8\u8ba4\u5b57\u7b26\u5360\u7528\u4e00\u5757\u7a7a\u95f4\uff0c\u7b49\u5230\u771f\u5b9e\u6570\u636e\u5199\u5165\u65f6\uff0c\u518dunset\u6389\u5b83\u3002<\/p>\n

\u53c2\u8003\uff1a
\nhttp:\/\/docs.mongodb.org\/v2.4\/core\/record-padding\/
\nhttp:\/\/docs.mongodb.org\/v2.4\/faq\/developers\/#faq-developers-manual-padding<\/p>\n

17\u3001usePowerOf2Size\u662f\u4ec0\u4e48<\/p>\n

\u8fd9\u662f\u4e3a\u66f4\u6709\u6548\u7684\u590d\u7528\u78c1\u76d8\u7a7a\u95f4\u800c\u8bbe\u7f6e\u7684\u53c2\u6570\uff1a\u5206\u914d\u7684\u78c1\u76d8\u7a7a\u95f4\u662f2\u7684\u500d\u6570\uff0c\u5982\u679c\u8d85\u8fc7\u4e864MB\uff0c\u5219\u662f\u8ddd\u79bb\u8ba1\u7b97\u503c\u6700\u8fd1\u7684\u4e14\u5927\u4e8e\u5b83\u7684\u5b8c\u6574MB\u6570\u3002
\n\u53ef\u4ee5\u901a\u8fc7db.collections.stats()\u770b\u5230\u8be5\u503c\u201cuserFlags\u201d\u3002
\nMongoDB2.6\u4e4b\u540e\u9ed8\u8ba4\u5f00\u542fusePowerOf2Size\u53c2\u6570
\n\u4f7f\u7528\u540e\u7684\u6548\u679c\u53ef\u4ee5\u770b\u8fd9\u91cc\u7684PPT\uff1ahttp:\/\/www.slideshare.net\/mongodb\/use-powerof2sizes-27300759<\/p>\n

18\u3001aggregate pipeline \u6307\u5b9a\u8fd0\u7b97\u5b8c\u6210\u8f93\u51fa\u6587\u6863\u8ddfMapReduce\u76f8\u6bd4\u6709\u4e0d\u8db3<\/p>\n

\uff08\u57fa\u4e8eMongoDB2.6\u7248\u672c\uff09MapReduce\u53ef\u4ee5\u6307\u5b9a\u8f93\u51fa\u5230\u7279\u5b9a\u7684db.collection\u4e2d\uff0c\u4f8b\u5982\uff1aout_put = bson.SON([(“replace”, “collection_name” ), (“db”, “xx_db”)])
\naggregate pipeline\u53ea\u80fd\u6307\u5b9acollection\u540d\u5b57\uff0c\u4e5f\u5c31\u610f\u5473\u7740\u6570\u636e\u53ea\u80fd\u5199\u5165\u5230\u672cdb\uff0c\u540c\u65f6\u7ed3\u679c\u4e0d\u80fd\u5199\u5165\u5230capped collection\u3001shard collection\u4e2d\u3002
\n\u76f8\u6bd4\u4e4b\u4e0b\uff0caggregate pipeline\u9650\u5236\u662f\u6bd4\u8f83\u591a\u7684\uff0c\u5982\u679c\u6211\u4eec\u9700\u8981\u628a\u7ed3\u679c\u653e\u5230\u67d0\u4e2aDB\u4e0b\uff0c\u5219\u9700\u8981\u518d\u505a\u4e00\u6b21\u8fc1\u79fb\uff1a
\ndb.runCommand({renameCollection:”sourcedb.mycol”,to:”targetdb.mycol”})
\n\u4f46\u662f\uff01\uff01\u4e0a\u9762\u7684\u8fd9\u6761\u547d\u4ee4\u8981\u6c42\u5728admin\u4e0b\u6267\u884c\uff0c\u4e14\u53ea\u80fd\u8fc1\u79fb\u5f80\u540cshard\u4e0b\u7684DB\uff0c\u4e14\u88ab\u8fc1\u79fb\u7684collection\u4e0d\u80fd\u662fshard\u7684\u3002
\n\u9644\u9519\u8bef\u7801\u4fe1\u606f\uff1a
\nhttps:\/\/github.com\/mongodb\/mongo\/blob\/master\/src\/mongo\/s\/commands_public.cpp#L778
\nuassert(13140, “Don’t recognize source or target DB”, confFrom && confTo);
\nuassert(13138, “You can’t rename a sharded collection”, !confFrom->isSharded(fullnsFrom));
\nuassert(13139, “You can’t rename to a sharded collection”, !confTo->isSharded(fullnsTo));
\nuassert(13137, “Source and destination collections must be on same shard”, shardFrom == shardTo);
\n\u53c2\u8003\uff1ahttp:\/\/docs.mongodb.org\/manual\/reference\/method\/db.collection.mapReduce\/#mapreduce-out-mtd<\/p>\n

19\u3001\u6740\u6389MongoD\u8fdb\u7a0b\u7684\u51e0\u79cd\u65b9\u5f0f<\/p>\n

1\uff09\u8fdb\u5165\u5230MongoD\u7684\u547d\u4ee4\u884c\u6a21\u5f0f\u6267\u884cshutdown\uff0c
\neg:
\n$ mongo –port 10001
\n> use admin
\n> db.shutdownServer()
\n2\uff091\u65b9\u5f0f\u7684\u7b80\u5316\uff1a
\neg\uff1amongo admin –port 10001 –eval “db.shutdownServer()”
\n3\uff09\u4f7f\u7528MongoD\u547d\u4ee4\u884c\u5173\u95ed\uff0c\u9700\u8981\u6307\u5b9adb\u8def\u5f84\uff1a
\nmongod –dbpath .\/data\/db –shutdown<\/p>\n

20\u3001\u96c6\u7fa4\u7684shard key\u614e\u91cd\u91c7\u7528hash<\/p>\n

\u5982\u679c\u4f60\u7684\u65e5\u5fd7\u662f\u6709\u65e5\u671f\u5c5e\u6027\u7684\uff0c\u90a3\u4e48shard key\u4e0d\u8981\u4f7f\u7528hash\uff0c\u5426\u5219\u5220\u9664\u8fc7\u671f\u65e5\u5fd7\u65f6\u65e0\u6cd5\u6210\u5757\u5220\u9664\uff1b\u5728\u66f4\u65b0\u65e5\u5fd7\u7684\u65f6\u5019\uff0c\u4e5f\u4e0d\u80fd\u5229\u7528\u5c40\u90e8\u6027\u539f\u7406<\/strong>\uff0c\u67e5\u627e\u3001\u66f4\u65b0\u3001\u63d2\u5165\u6570\u636e\u90fd\u4f1a\u56e0\u6b64\u800c\u53d8\u6162\u3002\u4e00\u822c\u6765\u8bf4\uff0chash id\u5e94\u4ed8\u5c0f\u6570\u636e\u91cf\u65f6\u538b\u529b\u4e0d\u5927\uff0c\u4f46\u5728\u6570\u636e\u91cf\u8f83\u5927\uff08\u70ed\u6570\u636e\u5927\u4e8e\u53ef\u7528\u5185\u5b58\u5bb9\u91cf\uff09\u65f6\uff0cCRUD\u6027\u80fd\u6781\u5dee\uff0c\u4e14\u4f1a\u653e\u5927\u788e\u7247\u5bf9\u6027\u80fd\u7684\u5f71\u54cd\uff1a\u6570\u636e\u975e\u5e38\u5206\u6563\uff0c\u5f53\u6709\u8fc7\u671f\u65e5\u5fd7\u88ab\u5220\u9664\u540e\uff0c\u8fd9\u4e9b\u5220\u9664\u540e\u7684\u7a7a\u95f4\u6210\u4e3a\u788e\u7247\uff0c\u53ef\u80fd\u4f1a\u56e0\u4e3a\u78c1\u76d8\u9884\u8bfb\u7b56\u7565\u88ab\u52a0\u8f7d\u5230\u5185\u5b58\u4e2d\u3002<\/span>\u53e6\u5916\uff0c\u91c7\u7528hash shard key\u8fd8\u4f1a\u6d6a\u8d39\u6389\u4e00\u4e2a\u7d22\u5f15\uff0c\u6d6a\u8d39\u4e0d\u5c11\u7a7a\u95f4\u3002<\/span><\/p>\n

21\u3001\u526f\u672c\u6570\u4e5f\u4e0d\u7528\u592a\u591a<\/p>\n

\u5982\u679c\u4f60\u7684\u526f\u672c\u6570\u91cf\u8d85\u8fc7\u4e8612\u4e2a\uff08MongoDB3.0.0\u8d85\u8fc7\u4e8650\u4e2a\uff09\uff0c\u90a3\u4e48\u5c31\u8981\u9009\u62e9\u4f7f\u7528 master-slave \uff0c\u4f46\u8fd9\u6837\u4f1a\u5931\u53bb\u6545\u969c\u81ea\u6062\u590d\u529f\u80fd\uff0c\u4e3b\u8282\u70b9\u6545\u969c\u65f6\uff0c\u9700\u8981\u624b\u52a8\u53bb\u5207\u6362\u5230\u65e0\u6545\u969c\u8282\u70b9\u3002<\/p>\n

22\u3001mongos\u7684config server\u914d\u7f6e\u4fe1\u606f\u4e2d\u4e0d\u8981\u4f7f\u7528localhost\u3001127.0.0.1<\/p>\n

\u542f\u52a8mongos\u65f6\uff0cconfig server\u7684\u914d\u7f6e\u4fe1\u606f\u4e0d\u5f97\u4f7f\u7528localhost\u3001127.0.0.1\uff0c\u5426\u5219\u6dfb\u52a0\u5176\u5b83\u673a\u5668\u7684shard\u65f6\uff0c\u4f1a\u51fa\u73b0\u9519\u8bef\u63d0\u793a\uff1a
\n“can\u2019t use localhost as a shard since all shards need to communicate. either use all shards and configdbs in localhost or all in actual IPs host: xxxxx isLocalHost”<\/p>\n

\u4ee5\u65b0\u7684config server\u542f\u52a8mongos\uff0c\u4e5f\u9700\u8981\u91cd\u542fconfig server\uff0c\u5426\u5219\u4f1a\u6709\u9519\u8bef\u63d0\u793a\uff1a
\n\u201ccould not verify config servers were active and reachable before write\u201d<\/p>\n

\u5982\u679c\u6539\u5b8c\u540e\u9762\u53c8\u51fa\u73b0 \u201cmongos specified a different config database string\u201d \u00a0\u9519\u8bef\uff0c\u90a3\u4e48\u8fd8\u9700\u8981\u91cd\u542fmongod\uff0c<\/p>\n

\u4fee\u6539\u4e86config server \u51e0\u4e4e\u662f\u8981\u5168\u90e8\u5b9e\u4f8b\u91cd\u542f\u3002\u53e6\u5916\uff0c\u5728\u914d\u7f6ereplica set\u65f6\u4e2d\u4e5f\u4e0d\u5f97\u4f7f\u7528localhost\u3001127.0.0.1\u3002
\n\u53c2\u8003\uff1ahttp:\/\/stackoverflow.com\/questions\/21226255\/where-is-the-mongos-config-database-string-being-stored<\/p>\n

23\u3001shard key\u7684\u9009\u62e9\u8ddfupdate\u6027\u80fd\u7d27\u5bc6\u5173\u8054<\/p>\n

\u5206\u5e03\u5f0fMongoDB\uff0cshard key\u7684\u9009\u62e9\u8ddfupdate\u6027\u80fd\uff0c\u751a\u81f3\u662fupdate\u53ef\u7528\u6027\u6709\u5f88\u5927\u5173\u7cfb\uff0c\u9700\u8981\u6ce8\u610f\u3002
\n1\u3001\u5728\u5bf9\u6587\u6863\u4e2a\u522b\u5b57\u6bb5update\u65f6\uff0c\u5982\u679cquery\u90e8\u5206\u6ca1\u6709\u5e26\u4e0ashard key\uff0c\u6027\u80fd\u4f1a\u5f88\u5dee\uff0c\u56e0\u4e3amongos\u9700\u8981\u628a\u8fd9\u6761update\u8bed\u53e5\u6d3e\u53d1\u7ed9\u6240\u6709\u7684shard \u5b9e\u4f8b\u3002
\n2\u3001\u5f53update \u7684upsert\u53c2\u6570\u4e3atrue\u65f6\uff0cquery\u90e8\u5206\u5fc5\u987b\u5e26\u4e0a shard key\uff0c\u5426\u5219\u8bed\u53e5\u6267\u884c\u51fa\u9519\uff0c\u4f8b\u5b50\uff1a
\nmongos> db.test.update({“_id”:”.7269993106A92327A89ABCD70D46AD5″}, {“$set”:{“P”: “aaa”}, “$setOnInsert”:{“TEST”:”a”}}, true)
\nWriteResult({
\n“nMatched” : 0,
\n“nUpserted” : 0,
\n“nModified” : 0,
\n“writeError” : {
\n“code” : 61,
\n“errmsg” : “upsert { q: { _id: \\”.7269993106A92327A89ABCD70D46AD5\\” }, u: { $set: { P: “aaa” }, $setOnInsert: { TEST: \\”a\\” } }, multi: false, upsert: true } does not contain shard key for pattern { _: 1.0, B: 1.0 }”
\n}
\n})
\n\u8fd9\u662f\u56e0\u4e3a\u5982\u679c\u6ca1\u6709shard key\uff0cmongos\u65e2\u4e0d\u80fd\u5728\u6240\u6709shard\u5b9e\u4f8b\u4e0a\u6267\u884c\u8fd9\u6761\u8bed\u53e5\uff08\u53ef\u80fd\u4f1a\u5bfc\u81f4\u6bcf\u4e2ashard\u90fd\u63d2\u5165\u6570\u636e\uff09\uff0c\u4e5f\u65e0\u6cd5\u9009\u62e9\u5728\u67d0\u4e2ashard\u4e0a\u6267\u884c\u8fd9\u6761\u8bed\u53e5\uff0c\u4e8e\u662f\u51fa\u9519\u4e86\u3002
\n\u53e6\u5916\uff0c\u9700\u8981\u7279\u522b\u6ce8\u610f\uff0c\u5982\u679c\u4f7f\u7528pymongo\u5f15\u64ce\uff0c\u5b83\u4e0d\u4f1a\u544a\u8bc9\u4f60\u51fa\u9519\u4e86\uff0c\u53ea\u662f\u51fd\u6570\u8c03\u7528\u9677\u5165\u4e0d\u8fd4\u56de<\/strong>\uff0c\u5728shell\u4e0b\u6267\u884c\u624d\u80fd\u770b\u5230\u9519\u8bef\u4fe1\u606f\u3002<\/p>\n

\u9644\uff1a
\n\u4ee5\u4e0b\u82f1\u6587\u90e8\u5206\u6765\u81ea\uff1ahttps:\/\/jira.mongodb.org\/browse\/SERVER-13010
\nIt’s actually not clear to me that this is something we can support – problem is this:
\n> db.coll.update({ _id : 1 }, { }, true);
\n> db.coll.find()
\n{ “_id” : ObjectId(“53176700a2bc4d46c176f14a”) }
\nUpserts generate new _ids in response to this operation, and therefore we can’t actually target this correctly in a sharded environment. The shard on which we need to perform the query may not be the shard on which the new _id is placed.
\n\u610f\u601d\u662f\u8bf4\uff0cupsert\u4ea7\u751f\u4e86\u65b0\u7684_id\uff0c_id\u5c31\u662fshard key\uff0c\u4f46\u662f\u5982\u679cquery\u91cc\u6ca1\u6709shard key\uff0c\u5b83\u4eec\u4e0d\u77e5\u9053\u8981\u5230\u54ea\u4e2ashard\u4e0a\u6267\u884c\u8fd9\u4e2a\u547d\u4ee4\uff0cupsert\u4ea7\u751f\u7684shard key\u53ef\u80fd\u5e76\u4e0d\u662f\u6267\u884c\u8fd9\u6761\u547d\u4ee4\u7684shard\u7684\u3002
\n\u53e6\u5916\uff0c\u5982\u679c_id\u4e0d\u662fshard key\u6211\u4eec\u7684\u4f8b\u5b50\u4e5f\u662f\u4e0d\u80fd\u6210\u529f\u7684\uff0c\u56e0\u4e3a\u6ca1\u6709shard key\uff0c\u8fd9\u6761upsert\u8981\u5728\u54ea\u4e2ashard\u4e0a\u6267\u884c\u5462\uff1f\u4e0d\u80fd\u50cf\u666e\u901aupdate\u90a3\u6837\u7ed9\u6240\u6709\u7684shard\u53bb\u505a\uff0c\u5426\u5219\u53ef\u80fd\u5bfc\u81f4\u63d2\u5165\u591a\u6761\u3002
\n\u53c2\u8003\uff1a
\nhttps:\/\/jira.mongodb.org\/browse\/SERVER-13010
\nhttp:\/\/docs.mongodb.org\/manual\/core\/sharding-shard-key\/
\nhttp:\/\/stackoverflow.com\/questions\/17190246\/which-of-the-following-statements-are-true-about-choosing-and-using-a-shard-key<\/p>\n

24\u3001\u901a\u8fc7repairDatabase\u63d0\u9ad8\u6027\u80fd<\/p>\n

\u4ecedb.stats()\u4e2d\u53ef\u4ee5\u770b\u5230\u51e0\u4e2a\u8ddf\u788e\u7247\u76f8\u5173\u7684\u5173\u952e\u5b57\u6bb5\uff0cdataSize\uff0c\u8868\u793a\u6570\u636e\u7684\u5927\u5c0f\uff0c\u5b83\u5305\u542b\u4e86padding\u7684\u7a7a\u95f4\uff1bstorageSize\uff0c\u8868\u793a\u8fd9\u4e9b\u6570\u636e\u5b58\u50a8\u5360\u7528\u7684\u7a7a\u95f4\uff0c\u5305\u542b\u4e86dataSize\u548c\u88ab\u5220\u9664\u6570\u636e\u6240\u5360\u7a7a\u95f4\uff0c\u53ef\u4ee5\u8ba4\u4e3astorageSize\/dataSize\u5c31\u662f\u78c1\u76d8\u788e\u7247\u6bd4\u4f8b\uff0c\u5f53\u5220\u9664\u3001update\u6587\u6863\u6bd4\u8f83\u591a\u540e\uff0c\u5b83\u4f1a\u53d8\u5927\uff0c\u8003\u8651\u505arepairDatabase<\/strong>\uff0c\u4ee5\u51cf\u5c11\u788e\u7247\u8ba9\u6570\u636e\u66f4\u7d27\u51d1\uff0c\u5728\u5b9e\u8df5\u4e2d\uff0c\u8fd9\u5bf9\u63d0\u9ad8CURD\u6027\u80fd\u6781\u5176\u6709\u7528\u3002repairDatabase\u65f6\u9700\u8981\u6ce8\u610f\uff1a\u5b83\u662f\u628a\u6570\u636e\u62f7\u8d1d\u5230\u65b0\u7684\u5730\u65b9\uff0c\u7136\u540e\u518d\u505a\u5904\u7406\uff0c\u6240\u4ee5repair\u4e4b\u524d\u5728DB\u76ee\u5f55\u6240\u5728\u78c1\u76d8\u9700\u8981\u9884\u7559\u4e00\u500d\u7684\u7a7a\u95f2\u78c1\u76d8\u7a7a\u95f4\uff0c\u5982\u679c\u4f60\u53d1\u73b0\u78c1\u76d8\u7a7a\u95f4\u4e0d\u8db3\uff0c\u53ef\u4ee5\u505c\u6b62\u670d\u52a1\uff0c\u7136\u540e\u589e\u52a0\u4e00\u5757\u65b0\u78c1\u76d8\uff0c\u518d\u6267\u884c\u5b9e\u4f8b\u7ea7\u522b\u7684repair\uff0c\u5e76\u6307\u5b9a–repairpath\u4e3a\u65b0\u78c1\u76d8\u8def\u5f84\uff0ceg\uff1amongod –dbpath \/path\/to\/corrupt\/data –repair –repairpath \/media\/external-hd\/data\/db\uff0c\u5b9e\u4f8b\u7684\u6570\u636e\u4f1a\u62f7\u8d1d\u5230\/media\/external-hd\/data\/db\u4e0a\u505a\u5904\u7406\u3002<\/p>\n

\u53c2\u8003\uff1a\u300aMongoDB\u2014\u2014The Definitive Guide 2nd Edition\u300bpage325<\/p>\n","protected":false},"excerpt":{"rendered":"

\u6765\u6e90:http:\/\/www.cnblogs.com\/cswuyg\/p\/43559 …<\/p>\n