{"id":461,"date":"2019-08-27T15:14:32","date_gmt":"2019-08-27T07:14:32","guid":{"rendered":"http:\/\/www.yumefx.com\/?p=461"},"modified":"2021-03-04T17:32:33","modified_gmt":"2021-03-04T09:32:33","slug":"mongodb%e5%88%86%e5%b8%83%e5%bc%8f%e7%9b%b8%e5%85%b3","status":"publish","type":"post","link":"https:\/\/www.yumefx.com\/?p=461","title":{"rendered":"MongoDB\u5206\u5e03\u5f0f\u76f8\u5173"},"content":{"rendered":"\n

\u8fd9\u4e00\u7bc7\u65e5\u5fd7\u8bb0\u5f55\u4e00\u4e0bMongoDB\u5206\u5e03\u5f0f\u76f8\u5173\u7684\u64cd\u4f5c\uff0c\u65b9\u4fbf\u67e5\u8be2\u3002<\/p>\n

\u5728\u5f00\u59cb\u771f\u6b63\u7684\u5206\u5e03\u5f0f\u4e4b\u524d\uff0c\u5148\u8bf4\u4e00\u4e0b\u4e3b\u4ece\u590d\u5236\u548c\u526f\u672c\u96c6\u3002<\/p>\n

\u00a0<\/h1>\n

\u4e3b\u4ece\u590d\u5236<\/strong><\/h1>\n

\u4e3b\u4ece\u590d\u5236\u7684\u4e3b\u8981\u76ee\u7684\u662f\u8bfb\u5199\u5206\u79bb\uff0c\u5373\u4e3b\u670d\u52a1\u5668\u63d0\u4f9b\u589e\u5220\u6539\u670d\u52a1\uff0c\u4ece\u670d\u52a1\u5668\u4fdd\u6301\u540c\u6b65\u5e76\u53ea\u63d0\u4f9b\u67e5\u8be2\u670d\u52a1\u3002<\/p>\n\n\n\n

\nmongod --dbpath=D:\\master --port 27700 --master            #\u4e3b\u670d\u52a1\u5668<\/span>\nmongod --dbpath=E:\\slave --port 27701 --slave              #\u4ece\u670d\u52a1\u5668 <\/span>\n<\/pre>\n\n\n\n
\u00a0<\/h1>\n
\u526f\u672c\u96c6<\/strong><\/h1>\n
\u526f\u672c\u96c6\u662f\u5177\u6709\u81ea\u52a8\u6545\u969c\u6062\u590d\u529f\u80fd\u7684\u4e3b\u4ece\u96c6\u7fa4\uff0c\u4e3b\u670d\u52a1\u5668\u4e0d\u56fa\u5b9a\uff0c\u4e3b\u670d\u52a1\u5668\u6302\u6389\u540e\uff0c\u4f1a\u5728\u5269\u4e0b\u7684\u4ece\u670d\u52a1\u5668\u91cc\u9009\u4e00\u4e2a\u53d8\u6210\u4e3b\u670d\u52a1\u5668\uff08\u6839\u636e\u4f18\u5148\u7ea7\u6743\u91cd\uff09\uff0c\u5373\u4e00\u4e2a\u6d3b\u8dc3\u8282\u70b9primary\u548c\u591a\u4e2a\u5907\u4efd\u8282\u70b9secondary\u3002<\/p>\n\n\n\n
\nmongod --dbpath=D:\\node1 --logpath D:\\node1\\logs.txt --logappend --port 27701 --replSet yumefx\/localhost:27702 --master            #\u6d3b\u8dc3\u8282\u70b9<\/span>\n<\/span>\nmongod --dbpath=D:\\node2 --logpath D:\\node2\\logs.txt --logappend --port 27702 --replSet yumefx\/localhost:27701                     #\u5907\u4efd\u8282\u70b91<\/span>\n<\/span>\nmongod --dbpath=D:\\node3 --logpath D:\\node3\\logs.txt --logappend --port 27703 --replSet yumefx\/localhost:27701,localhost:27702     #\u5907\u4efd\u8282\u70b92<\/span>\n<\/pre>\n\n\n\n
\u4e0a\u9762yumefx\u662f\u526f\u672c\u96c6\u7684\u540d\u79f0\uff0c\u540e\u9762\u5219\u662f\u58f0\u660e\u548c\u5907\u4efd\u8282\u70b9\u7684\u5173\u7cfb\u3002<\/p>\n
\u526f\u672c\u96c6\u542f\u52a8\u540e\u8fd8\u9700\u8981\u521d\u59cb\u5316\u4e00\u6b21\uff08\u53ea\u80fd\u521d\u59cb\u5316\u4e00\u6b21\uff09\uff0c\u968f\u610f\u767b\u5f55\u4e00\u4e2a\u8282\u70b9\uff0c\u4ee527701\u4e3a\u4f8b\u3002<\/p>\n\n\n\n
\nmongo localhost\uff1a27701 <\/span>\nuse admin<\/span>\ndb.runCommand({<\/span>\n    "replSetInitiate":{<\/span>\n        "_id":"yumefx",<\/span>\n        "members":[<\/span>\n        {<\/span>\n            "_id":1,<\/span>\n            "host":"localhost:27701",<\/span>\n            "priority":30<\/span>\n        },<\/span>\n        {<\/span>\n            "_id":2,<\/span>\n            "host":"localhost:27702",<\/span>\n            "priority":20<\/span>\n        },  <\/span>\n        {<\/span>\n            "_id":3,<\/span>\n            "host":"localhost:27703",<\/span>\n            "priority":10<\/span>\n        }<\/span>\n        ]<\/span>\n    }<\/span>\n});                        #rs.initiate({...})<\/span>\n<\/pre>\n\n\n\n
\nrs.conf()                                  #\u663e\u793a\u5f53\u524d\u914d\u7f6e<\/span>\nrs.add("localhost:27704")                  #\u6dfb\u52a0\u4e00\u4e2a\u526f\u672c<\/span>\nrs.remove("localhost:27704")               #\u5220\u9664\u4e00\u4e2a\u526f\u672c<\/span>\nrs.slaveOk()                               #\u5f53slave\u9ed8\u8ba4\u4e0d\u5141\u8bb8\u8bfb\u5199\u65f6<\/span>\n<\/pre>\n\n\n\n
\u00a0<\/h1>\n
\u5206\u7247\uff08sharding\uff09\u5206\u5e03\u5f0f\u5b58\u50a8<\/strong><\/h1>\n
\u5206\u7247\u662f\u6307\u5c06\u6570\u636e\u62c6\u5206\uff0c\u5206\u6563\u5b58\u5728\u4e0d\u540c\u673a\u5668\u4e0a\uff0c\u6709\u65f6\u4e5f\u7528\u5206\u533a\uff08partitioning\uff09\u6765\u8868\u793a\u8fd9\u4e2a\u6982\u5ff5\u3002\u5206\u7247\u4e4b\u524d\u8fd0\u884c\u4e00\u4e2a\u8def\u7531\u8fdb\u7a0bmongos\uff0c\u5c06\u6570\u636e\u6309\u67d0\u4e00\u952e\u503c\uff08key\uff09\u8fdb\u884c\u62c6\u5206\uff0c\u4ece\u800c\u8be5\u8fdb\u7a0b\u53ef\u4ee5\u77e5\u9053\u6240\u6709\u6570\u636e\u7684\u5b58\u653e\u4f4d\u7f6e\uff0c\u6240\u6709\u5e94\u7528\u53ef\u4ee5\u8fde\u63a5\u5b83\u6765\u53d1\u9001\u8bf7\u6c42\uff0c\u5e94\u7528\u53ea\u77e5\u9053\u81ea\u5df1\u8fde\u63a5\u4e86\u4e00\u4e2a\u6b63\u5e38\u7684mongod\u3002<\/p>\n\n\n\n
\nmongod --dbpath=D:\\node1 --port 27801<\/span>\nmongod --dbpath=D:\\node2 --port 27802<\/span>\nmongod --dbpath=D:\\node3 --port 27803<\/span>\nmongod --dbpath=D:\\configNode --port 27804 --configsvr     #\u5f00\u542fconfig\u670d\u52a1\u5668<\/span>\nmongos --port 27805 --configdb=localhost:27804             #\u5f00\u542fmongos\u670d\u52a1\u5668<\/span>\n<\/pre>\n\n\n\n
config\u670d\u52a1\u5668\u4e0emongos\u670d\u52a1\u5668\u8fde\u63a5\uff0c\u91cc\u9762\u5b58\u653e\u6570\u636e\u4e0e\u5206\u7247\u7684\u5bf9\u5e94\u5173\u7cfb\u3002<\/p>\n
\u63a5\u4e0b\u6765\u5c31\u662f\u8fde\u63a5mongos\u521d\u59cb\u5316\u3002<\/p>\n\n\n\n
\ndb.runCommand({"addshard":"localhost:27801",allowLocal:true})    <\/span>\ndb.runCommand({"addshard":"localhost:27802",allowLocal:true}) <\/span>\ndb.runCommand({"addshard":"localhost:27803",allowLocal:true})   <\/span>\n#sh.addShard("localhost:27803")<\/span>\ndb.runCommand({"enablesharding":"yumedb"})<\/span>\n#sh.enableSharding("yumedb")<\/span>\ndb.runCommand({"shardcollection":"yumedb.person","key":{age:1}})    #\u4ee5age\u4f5c\u4e3a\u533a\u5206\uff0c\u5c06yumedb\u8fd9\u4e2a\u6570\u636e\u5e93\u5206\u7247\u5b58\u50a8\u3002<\/span>\n#sh.shardCollection("yumedb.person",{age:1})<\/span>\n<\/span>\nfor(var i=1;i<=40;i++) { sh.splitAt('yumedx.person',{userid:i*1000}) } <\/span>\n#\u624b\u52a8\u9884\u5148\u5206\u7247\uff0c\u9884\u5148\u5207\u5206\u597d\u7a7a\u7684chunk\uff0c\u4f1a\u5747\u5300\u79fb\u52a8\u5230\u5404\u5206\u7247\u4e0a\uff0c\u4e4b\u540e\u6dfb\u52a0\u6570\u636e\u4f1a\u81ea\u52a8\u5b58\u5230\u9884\u5148\u5206\u914d\u597d\u7684chunk\u4e0a\u3002<\/span>\n<\/pre>\n\n\n\n
allowLocal\u610f\u601d\u662f\u53ef\u4ee5\u5141\u8bb8\u5e94\u7528\u76f4\u63a5\u8fde\u63a5\u5206\u7247\u670d\u52a1\u5668\uff0cyumedb\u662f\u8981\u5206\u7247\u7684\u6570\u636e\u5e93\u3002<\/p>\n
\u00a0<\/h1>\n
\u5206\u7247\u7ed3\u5408\u526f\u672c\u96c6<\/strong><\/h1>\n
\u4ee5\u5206\u7247\u4e3a\u4e3b\uff0c\u6bcf\u4e2a\u5206\u7247\u914d\u591a\u4e2a\u526f\u672c\u96c6\u3002<\/p>\n\n\n\n
\nsh.addShard("yumefx\/localhost:27803")          #yumefx\u4e3a\u526f\u672c\u96c6\u540d\u79f0<\/span>\n<\/pre>\n\n\n\n
\u00a0<\/h1>\n
\u5176\u4ed6<\/strong><\/h1>\n
\u4e0b\u9762\u5c06\u4e00\u4e9b\u5176\u4ed6\u5e38\u7528\u64cd\u4f5c\u4e5f\u5217\u4e3e\u4e00\u4e0b\u3002<\/p>\n\n\n\n
\ndb.c1.insert({name:"yumefx",age:26})<\/span>\ndb.c1.remove({name:"yumefx"},true)                          #\u5220\u9664\u7b2c\u4e00\u4e2a\u7b26\u5408\u6761\u4ef6\u7684<\/span>\ndb.c1.update({age:26},{name:"yume"}})                       #\u7ed3\u679c\u662f\u7b2c\u4e00\u4e2a\u6570\u636e\u7684name\u88ab\u4fee\u6539\uff0cage\u4e22\u5931<\/span>\ndb.c1.update({age:26},{$set:{name:"yume"}})                 #\u7ed3\u679c\u662f\u7b2c\u4e00\u4e2a\u6570\u636e\u7684name\u88ab\u4fee\u6539\uff0cage\u4f9d\u7136\u5728<\/span>\ndb.c1.update({age:26},{$set:{name:"yume"}},1,1)             #\u6240\u6709\u6570\u636e\u7684name\u88ab\u4fee\u6539\uff0cage\u4e0d\u53d8<\/span>\n#\u7b2c\u4e00\u4e2a\u53c2\u6570\u662f\u641c\u7d22\u6761\u4ef6\uff0c\u7b2c\u4e8c\u4e2a\u53c2\u6570\u662f\u8981\u6539\u6210\u7684\u6570\u636e\uff0c\u7b2c\u4e09\u4e2a\u53c2\u6570\u662f\u5982\u679c\u641c\u4e0d\u5230\u662f\u5426\u6dfb\u52a0\u65b0\u6570\u636e\uff0c\u7b2c\u56db\u4e2a\u53c2\u6570\u662f\u662f\u5426\u4fee\u6539\u6240\u6709\u641c\u5230\u7684\u6570\u636e\u3002<\/span>\n#$set\u8bbe\u7f6e\uff0c$unset\u5220\u9664\uff0c$inc\u52a0\uff0c$rename\u91cd\u547d\u540d\u3002<\/span>\n<\/span>\n\u6bd4\u8f83\u8fd0\u7b97\u7b26\uff1a<\/span>\n$gt(>),$gte(>=),$in(in),$lt(<),$lte(<=),$ne(!=),$nin(not in),$all(\u6570\u7ec4\u6240\u6709\u5355\u5143\u5339\u914d),<\/span>\n$or(or),$and(and),$not(not),$nor(\u6240\u6709\u6761\u4ef6\u5747\u4e0d\u6ee1\u8db3)\uff0c<\/span>\n$exists(\u67d0\u5217\u5b58\u5728),$mod\uff08\u6ee1\u8db3\u67d0\u6c42\u4f59\u6761\u4ef6\uff09,$type<\/span>\n$where(js\u8868\u8fbe\u5f0f\u4e3a\u771f),$regex(\u6b63\u5219\u8868\u8fbe\u5f0f\u5339\u914d)\u3002<\/span>\n<\/span>\ndb.c1.count()<\/span>\ndb.c1.find({age:21} ).explain()                #\u5c55\u793a\u67e5\u8be2\u65f6\u95f4\u7b49\u8be6\u7ec6\u4fe1\u606f<\/span>\ndb.c1.ensureIndex({age:1})                     #\u4ee5age\u952e\u503c\uff0c\u5efa\u7acb\u7d22\u5f15<\/span>\n<\/span>\nvar i=db.c1.find({age:21})<\/span>\ni.next()<\/span>\ni.hasnext()<\/span>\n<\/span>\ndb.c1.find({age:{$gt:18}},{name:1,gender:1})       #\u67e5\u8be2\u6240\u6709\u5e74\u9f8418\u7684\u5e76\u5217\u51fa\u59d3\u540d\u548c\u6027\u522b<\/span>\n<\/span>\nmongoexport -h localhost:27701 -d yumedb -c collection1 -o D:\\collection1.xls                         #\u6570\u636e\u5bfc\u51fa<\/span>\nmongoimport -h localhost:27701 -d yumedb -c  collection1 -o D:\\collection1.xls                         #\u6570\u636e\u5bfc\u5165<\/span>\n<\/span>\nmongodump -h localhost:27701 -d yumedb -o D:\\dbbake      #\u6570\u636e\u5e93\u5907\u4efd<\/span>\nmongorestore -h localhost:27701 -d yumedb -directoryperdb D:\\dbbake\\yumedb      #\u6570\u636e\u5e93\u6062\u590d<\/span>\n<\/span>\ndb.createCollection("collectionName",{capped:true,size:10000,max:100})          #\u56fa\u5b9a\u96c6\u5408\uff08\u56fa\u5b9a\u5927\u5c0f\u6216\u8005\u6761\u6570\uff0c\u5148\u8fdb\u5148\u51fa\u88ab\u8986\u76d6\uff09<\/span>\nsize\u6307\u5b9a\u96c6\u5408\u5927\u5c0f\uff0c\u5355\u4f4dKB\uff0cmax\u6307\u6587\u6863\u5927\u5c0f\uff1b\u5f53\u6307\u5b9a\u6587\u6863\u6570\u91cf\u4e0a\u9650\u65f6\uff0c\u5fc5\u987b\u540c\u65f6\u6307\u5b9a\u5927\u5c0f\u3002<\/span>\n<\/pre>\n\n\n\n\n\n
\n\n\n\n
\u6211\u5e76\u4e0d\u671f\u5f85\u4eba\u751f\u8fc7\u5f97\u5f88\u987a\u5229\uff0c
\u4f46\u6211\u5e0c\u671b\u78b0\u5230\u4eba\u751f\u96be\u5173\u7684\u65f6\u5019\uff0c
\u81ea\u5df1\u53ef\u4ee5\u662f\u5b83\u7684\u5bf9\u624b\u3002<\/p>\n
\u300a\u52a0\u7f2a\u624b\u8bb0\u7b2c\u4e09\u5377\u300b
\u2014\u2014\u963f\u5c14\u8d1d\u00b7\u52a0\u7f2a<\/p>\n","protected":false},"excerpt":{"rendered":"
\u8fd9\u4e00\u7bc7\u65e5\u5fd7\u8bb0\u5f55\u4e00\u4e0bMongoDB\u5206\u5e03\u5f0f\u76f8\u5173\u7684\u64cd\u4f5c\uff0c\u65b9\u4fbf\u67e5\u8be2\u3002 \u5728\u5f00\u59cb\u771f\u6b63\u7684\u5206\u5e03\u5f0f\u4e4b\u524d\uff0c\u5148\u8bf4\u4e00\u4e0b\u4e3b\u4ece\u590d\u5236\u548c\u526f\u672c\u96c6 […]<\/p>\n","protected":false},"author":1,"featured_media":1071,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4,6],"tags":[14,55],"_links":{"self":[{"href":"https:\/\/www.yumefx.com\/index.php?rest_route=\/wp\/v2\/posts\/461"}],"collection":[{"href":"https:\/\/www.yumefx.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yumefx.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yumefx.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yumefx.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=461"}],"version-history":[{"count":0,"href":"https:\/\/www.yumefx.com\/index.php?rest_route=\/wp\/v2\/posts\/461\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.yumefx.com\/index.php?rest_route=\/wp\/v2\/media\/1071"}],"wp:attachment":[{"href":"https:\/\/www.yumefx.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=461"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yumefx.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=461"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yumefx.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=461"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}