57-1、2、3NoSQL基礎(chǔ)及MongoDB、Mongo-創(chuàng)新互聯(lián)

02MongoDB基本應(yīng)用

創(chuàng)新互聯(lián)是一家業(yè)務(wù)范圍包括IDC托管業(yè)務(wù),虛擬空間、主機(jī)租用、主機(jī)托管，四川、重慶、廣東電信服務(wù)器租用,托管服務(wù)器，成都網(wǎng)通服務(wù)器托管,成都服務(wù)器租用,業(yè)務(wù)范圍遍及中國大陸、港澳臺以及歐美等多個國家及地區(qū)的互聯(lián)網(wǎng)數(shù)據(jù)服務(wù)公司。

配置環(huán)境：

node1:192.168.1.121CentOS release 6.7

[root@node1 ~]# cd mongodb-2.6.4/

[root@node1 mongodb-2.6.4]# ls

mongodb-org-2.6.4-1.x86_64.rpm mongodb-org-shell-2.6.4-1.x86_64.rpm

mongodb-org-mongos-2.6.4-1.x86_64.rpm mongodb-org-tools-2.6.4-1.x86_64.rpm

mongodb-org-server-2.6.4-1.x86_64.rpm

[root@node1 mongodb-2.6.4]# yum install mongodb-org-server-2.6.4-1.x86_64.rpm mongodb-org-shell-2.6.4-1.x86_64.rpm mongodb-org-tools-2.6.4-1.x86_64.rpm -y

[root@node1 mongodb-2.6.4]# cd

[root@node1 ~]# mkdir -p /mongodb/data

[root@node1 ~]# id mongod

uid=496(mongod) gid=492(mongod) groups=492(mongod)

[root@node1 ~]# chown -R mongod.mongod /mongodb/

[root@node1 ~]# vim /etc/mongod.conf

修改

dbpath=/var/lib/mongo

為

dbpath=/mongodb/data

修改

bind_ip=127.0.0.1

為

#bind_ip=127.0.0.1

修改

#httpinterface=true

為

httpinterface=true

rest=true

[root@node1 ~]# service mongod start

[root@node1 ~]# ls /mongodb/data/

journal local.0 local.ns mongod.lock _tmp

[root@node1 ~]# du -sh /mongodb/data/

3.1G /mongodb/data/

[root@node1 ~]# ss -tnl

State Recv-Q Send-Q Local Address:Port Peer Address:Port

LISTEN 0 128 :::39591 :::*

LISTEN 0 128 *:27017 *:*

LISTEN 0 128 :::111 :::*

LISTEN 0 128 *:111 *:*

LISTEN 0 128 *:28017 *:*

LISTEN 0 128 *:46453 *:*

LISTEN 0 128 :::22 :::*

LISTEN 0 128 *:22 *:*

LISTEN 0 128 127.0.0.1:631 *:*

LISTEN 0 128 ::1:631 :::*

LISTEN 0 100 ::1:25 :::*

LISTEN 0 100 127.0.0.1:25 *:*

[root@node1 ~]# mongo --host 192.168.1.121

MongoDB shell version: 2.6.4

connecting to: 192.168.1.121:27017/test

Welcome to the MongoDB shell.

For interactive help, type "help".

For more comprehensive documentation, see

http://docs.mongodb.org/

Questions? Try the support group

http://groups.google.com/group/mongodb-user

> show dbs

admin (empty)

local 0.078GB

> use testdb

switched to db testdb

> show dbs

admin (empty)

local 0.078GB

> db.stats()

{

"db" : "testdb",

"collections" : 0,

"objects" : 0,

"avgObjSize" : 0,

"dataSize" : 0,

"storageSize" : 0,

"numExtents" : 0,

"indexes" : 0,

"indexSize" : 0,

"fileSize" : 0,

"dataFileVersion" : {

"ok" : 1

}

> db.version()

2.6.4

> db.getCollectionNames()

[ ]

#插入數(shù)據(jù)

> db.students.insert({name:"tom",age:23})

WriteResult({ "nInserted" : 1 })

> show collections

students

system.indexes

> show dbs

admin (empty)

local 0.078GB

testdb 0.078GB

> db.students.stats()

{

"ns" : "testdb.students",

"count" : 1,

"size" : 112,

"avgObjSize" : 112,

"storageSize" : 8192,

"numExtents" : 1,

"nindexes" : 1,

"lastExtentSize" : 8192,

"paddingFactor" : 1,

"systemFlags" : 1,

"userFlags" : 1,

"totalIndexSize" : 8176,

"indexSizes" : {

"_id_" : 8176

"ok" : 1

}

> db.getCollectionNames()

[ "students", "system.indexes" ]

> db.students.insert ({name:"jerry",age:40,gender:"M"})

WriteResult({ "nInserted" : 1 })

> db.students.stats()

{

"ns" : "test.students",

"count" : 1,

"size" : 112,

"avgObjSize" : 112,

"storageSize" : 8192,

"numExtents" : 1,

"nindexes" : 1,

"lastExtentSize" : 8192,

"paddingFactor" : 1,

"systemFlags" : 1,

"userFlags" : 1,

"totalIndexSize" : 8176,

"indexSizes" : {

"_id_" : 8176

"ok" : 1

}

#幫助：

> db.mycoll.help()

> db.mycoll.find.help()

> db.students.find()

{ "_id" : ObjectId("58720933110b5df571418845"), "name" : "jerry", "age" : 40, "gender" : "M" }

{ "_id" : ObjectId("58720a26110b5df571418846"), "name" : "tom", "age" : 23 }

> db.students.count()

> db.students.insert({name:"Ou Yangfeng",Age:90,Course:"HaMogong"})

WriteResult({ "nInserted" : 1 })

> db.students.insert({name:"Yang Guo",Age:20,Course:"Meinv Quan"})

WriteResult({ "nInserted" : 1 })

> db.students.insert({name:"Guo Jing",Age:40,Course:"Xiangchong Shibazhang"})

WriteResult({ "nInserted" : 1 })

#查詢年齡大于30的記錄

> db.students.find({Age:{$gt: 30}})

{ "_id" : ObjectId("58720b48110b5df571418847"), "name" : "Ou Yangfeng", "Age" : 90, "Course" : "HaMogong" }

{ "_id" : ObjectId("58720ba8110b5df571418849"), "name" : "Guo Jing", "Age" : 40, "Course" : "Xiangchong Shibazhang" }

#查詢年齡在20到40之間的記錄

> db.students.find({Age:{$in: [20,40]}})

{ "_id" : ObjectId("58720b71110b5df571418848"), "name" : "Yang Guo", "Age" : 20, "Course" : "Meinv Quan" }

{ "_id" : ObjectId("58720ba8110b5df571418849"), "name" : "Guo Jing", "Age" : 40, "Course" : "Xiangchong Shibazhang" }

#查看年齡不在20到40之間的記錄

> db.students.find({Age:{$nin: [20,40]}})

{ "_id" : ObjectId("58720933110b5df571418845"), "name" : "jerry", "age" : 40, "gender" : "M" }

{ "_id" : ObjectId("58720a26110b5df571418846"), "name" : "tom", "age" : 23 }

{ "_id" : ObjectId("58720b48110b5df571418847"), "name" : "Ou Yangfeng", "Age" : 90, "Course" : "HaMogong" }

#查看Age或age值不在20到40之間的記錄

> db.students.find({$or: [{Age: {$nin: [20,40]}}, {age:{$nin:[20,40]}}]})

{ "_id" : ObjectId("58720933110b5df571418845"), "name" : "jerry", "age" : 40, "gender" : "M" }

{ "_id" : ObjectId("58720a26110b5df571418846"), "name" : "tom", "age" : 23 }

{ "_id" : ObjectId("58720b48110b5df571418847"), "name" : "Ou Yangfeng", "Age" : 90, "Course" : "HaMogong" }

{ "_id" : ObjectId("58720b71110b5df571418848"), "name" : "Yang Guo", "Age" : 20, "Course" : "Meinv Quan" }

{ "_id" : ObjectId("58720ba8110b5df571418849"), "name" : "Guo Jing", "Age" : 40, "Course" : "Xiangchong Shibazhang" }

#查看Age或age值在20到40之間的記錄

> db.students.find({$or: [{Age: {$in: [20,40]}}, {age:{$in:[20,40]}}]})

{ "_id" : ObjectId("58720933110b5df571418845"), "name" : "jerry", "age" : 40, "gender" : "M" }

{ "_id" : ObjectId("58720b71110b5df571418848"), "name" : "Yang Guo", "Age" : 20, "Course" : "Meinv Quan" }

{ "_id" : ObjectId("58720ba8110b5df571418849"), "name" : "Guo Jing", "Age" : 40, "Course" : "Xiangchong Shibazhang" }

#查看存在gender字段的記錄

> db.students.find({gender: {$exists: true}})

{ "_id" : ObjectId("58720933110b5df571418845"), "name" : "jerry", "age" : 40, "gender" : "M" }

#查看不存在gender字段的記錄

> db.students.find({gender: {$exists: false}})

{ "_id" : ObjectId("58720a26110b5df571418846"), "name" : "tom", "age" : 23 }

{ "_id" : ObjectId("58720b48110b5df571418847"), "name" : "Ou Yangfeng", "Age" : 90, "Course" : "HaMogong" }

{ "_id" : ObjectId("58720b71110b5df571418848"), "name" : "Yang Guo", "Age" : 20, "Course" : "Meinv Quan" }

{ "_id" : ObjectId("58720ba8110b5df571418849"), "name" : "Guo Jing", "Age" : 40, "Course" : "Xiangchong Shibazhang" }

#修改"tom"的age為21

> db.students.find()

{ "_id" : ObjectId("58720933110b5df571418845"), "name" : "jerry", "age" : 40, "gender" : "M" }

{ "_id" : ObjectId("58720a26110b5df571418846"), "name" : "tom", "age" : 23 }

{ "_id" : ObjectId("58720b48110b5df571418847"), "name" : "Ou Yangfeng", "Age" : 90, "Course" : "HaMogong" }

{ "_id" : ObjectId("58720b71110b5df571418848"), "name" : "Yang Guo", "Age" : 20, "Course" : "Meinv Quan" }

{ "_id" : ObjectId("58720ba8110b5df571418849"), "name" : "Guo Jing", "Age" : 40, "Course" : "Xiangchong Shibazhang" }

> db.students.update({name:"tom"},{$set: {age: 21}})

WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })

> db.students.find()

{ "_id" : ObjectId("58720933110b5df571418845"), "name" : "jerry", "age" : 40, "gender" : "M" }

{ "_id" : ObjectId("58720a26110b5df571418846"), "name" : "tom", "age" : 21 }

{ "_id" : ObjectId("58720b48110b5df571418847"), "name" : "Ou Yangfeng", "Age" : 90, "Course" : "HaMogong" }

{ "_id" : ObjectId("58720b71110b5df571418848"), "name" : "Yang Guo", "Age" : 20, "Course" : "Meinv Quan" }

{ "_id" : ObjectId("58720ba8110b5df571418849"), "name" : "Guo Jing", "Age" : 40, "Course" : "Xiangchong Shibazhang" }

#刪除age值為21的記錄

> db.students.remove({age:21})

WriteResult({ "nRemoved" : 1 })

> db.students.find()

{ "_id" : ObjectId("58720933110b5df571418845"), "name" : "jerry", "age" : 40, "gender" : "M" }

{ "_id" : ObjectId("58720b48110b5df571418847"), "name" : "Ou Yangfeng", "Age" : 90, "Course" : "HaMogong" }

{ "_id" : ObjectId("58720b71110b5df571418848"), "name" : "Yang Guo", "Age" : 20, "Course" : "Meinv Quan" }

{ "_id" : ObjectId("58720ba8110b5df571418849"), "name" : "Guo Jing", "Age" : 40, "Course" : "Xiangchong Shibazhang" }

#統(tǒng)計Age值在20到40之間的記錄數(shù)

> db.students.find({Age: {$in: [20,40]}}).count()

#顯示Age值在20到40之間的記錄，僅顯示滿足條件的第一條記錄

> db.students.find({Age: {$in: [20,40]}}).limit(1)

{ "_id" : ObjectId("58720b71110b5df571418848"), "name" : "Yang Guo", "Age" : 20, "Course" : "Meinv Quan" }

#顯示Age值在20到40之間的記錄，第一條記錄不顯示

> db.students.find({Age: {$in: [20,40]}}).skip(1)

{ "_id" : ObjectId("58720ba8110b5df571418849"), "name" : "Guo Jing", "Age" : 40, "Course" : "Xiangchong Shibazhang" }

#顯示Age值大于10的記錄，僅顯示一條滿足條件的記錄

> db.students.findOne({Age: {$gt: 10}})

{

"_id" : ObjectId("58720b48110b5df571418847"),

"name" : "Ou Yangfeng",

"Age" : 90,

"Course" : "HaMogong"

}

#刪除students表

> db.students.drop()

true

> show collections;

system.indexes

> db.stats()

{

"db" : "test",

"collections" : 2,

"objects" : 1,

"avgObjSize" : 48,

"dataSize" : 48,

"storageSize" : 16384,

"numExtents" : 2,

"indexes" : 0,

"indexSize" : 0,

"fileSize" : 67108864,

"nsSizeMB" : 16,

"dataFileVersion" : {

"major" : 4,

"minor" : 5

"extentFreeList" : {

"num" : 2,

"totalSize" : 139264

"ok" : 1

}

#刪除數(shù)據(jù)庫

> db.dropDatabase()

{ "dropped" : "test", "ok" : 1 }

> show dbs

admin (empty)

local 0.078GB

testdb 0.078GB

03mongodb索引及復(fù)制集

[root@node1 ~]# mongo

MongoDB shell version: 2.6.4

connecting to: test

> use testdb

switched to db testdb

> for (i=1;i<=10000;i++) db.students.insert({name:"student"+i, age:(i%120), address:"#85 Wenhua Road, Zhengzhou, China"})

> db.students.find().count()

10000

> db.students.find()

{ "_id" : ObjectId("5871e94113222f399a5240a3"), "name" : "tom", "age" : 23 }

{ "_id" : ObjectId("587232dba7eb9c0c7bd54561"), "name" : "student1", "age" : 1, "address" : "#85 Wenhua Road, Zhengzhou, China" }

{ "_id" : ObjectId("587232dba7eb9c0c7bd54562"), "name" : "student2", "age" : 2, "address" : "#85 Wenhua Road, Zhengzhou, China" }

{ "_id" : ObjectId("587232dba7eb9c0c7bd54563"), "name" : "student3", "age" : 3, "address" : "#85 Wenhua Road, Zhengzhou, China" }

{ "_id" : ObjectId("587232dba7eb9c0c7bd54564"), "name" : "student4", "age" : 4, "address" : "#85 Wenhua Road, Zhengzhou, China" }

{ "_id" : ObjectId("587232dba7eb9c0c7bd54565"), "name" : "student5", "age" : 5, "address" : "#85 Wenhua Road, Zhengzhou, China" }

{ "_id" : ObjectId("587232dba7eb9c0c7bd54566"), "name" : "student6", "age" : 6, "address" : "#85 Wenhua Road, Zhengzhou, China" }

{ "_id" : ObjectId("587232dba7eb9c0c7bd54567"), "name" : "student7", "age" : 7, "address" : "#85 Wenhua Road, Zhengzhou, China" }

{ "_id" : ObjectId("587232dba7eb9c0c7bd54568"), "name" : "student8", "age" : 8, "address" : "#85 Wenhua Road, Zhengzhou, China" }

{ "_id" : ObjectId("587232dba7eb9c0c7bd54569"), "name" : "student9", "age" : 9, "address" : "#85 Wenhua Road, Zhengzhou, China" }

{ "_id" : ObjectId("587232dba7eb9c0c7bd5456a"), "name" : "student10", "age" : 10, "address" : "#85 Wenhua Road, Zhengzhou, China" }

{ "_id" : ObjectId("587232dba7eb9c0c7bd5456b"), "name" : "student11", "age" : 11, "address" : "#85 Wenhua Road, Zhengzhou, China" }

{ "_id" : ObjectId("587232dba7eb9c0c7bd5456c"), "name" : "student12", "age" : 12, "address" : "#85 Wenhua Road, Zhengzhou, China" }

{ "_id" : ObjectId("587232dba7eb9c0c7bd5456d"), "name" : "student13", "age" : 13, "address" : "#85 Wenhua Road, Zhengzhou, China" }

{ "_id" : ObjectId("587232dba7eb9c0c7bd5456e"), "name" : "student14", "age" : 14, "address" : "#85 Wenhua Road, Zhengzhou, China" }

{ "_id" : ObjectId("587232dba7eb9c0c7bd5456f"), "name" : "student15", "age" : 15, "address" : "#85 Wenhua Road, Zhengzhou, China" }

{ "_id" : ObjectId("587232dba7eb9c0c7bd54570"), "name" : "student16", "age" : 16, "address" : "#85 Wenhua Road, Zhengzhou, China" }

{ "_id" : ObjectId("587232dba7eb9c0c7bd54571"), "name" : "student17", "age" : 17, "address" : "#85 Wenhua Road, Zhengzhou, China" }

{ "_id" : ObjectId("587232dba7eb9c0c7bd54572"), "name" : "student18", "age" : 18, "address" : "#85 Wenhua Road, Zhengzhou, China" }

{ "_id" : ObjectId("587232dba7eb9c0c7bd54573"), "name" : "student19", "age" : 19, "address" : "#85 Wenhua Road, Zhengzhou, China" }

#在name字段上構(gòu)建一個升序索引

> db.students.ensureIndex({name: 1})

{

"createdCollectionAutomatically" : false,

"numIndexesBefore" : 1,

"numIndexesAfter" : 2,

"ok" : 1

}

#顯示表中索引

> db.students.getIndexes()

[

{

"v" : 1,

"key" : {

"_id" : 1

"name" : "_id_",

"ns" : "testdb.students"

{

"v" : 1,

"key" : {

"name" : 1

"name" : "name_1",

"ns" : "testdb.students"

}

]

#刪除索引

> db.students.dropIndex("name_1")

{ "nIndexesWas" : 2, "ok" : 1 }

> db.students.getIndexes()

[

{

"v" : 1,

"key" : {

"_id" : 1

"name" : "_id_",

"ns" : "testdb.students"

}

]

#創(chuàng)建唯一索引

> db.students.ensureIndex({name: 1},{unique: true})

{

"createdCollectionAutomatically" : false,

"numIndexesBefore" : 1,

"numIndexesAfter" : 2,

"ok" : 1

}

> db.students.getIndexes()

[

{

"v" : 1,

"key" : {

"_id" : 1

"name" : "_id_",

"ns" : "testdb.students"

{

"v" : 1,

"unique" : true,

"key" : {

"name" : 1

"name" : "name_1",

"ns" : "testdb.students"

}

]

#創(chuàng)建唯一索引后，新增相同字段值會提示錯誤

> db.students.insert({name: "student20", age: 20,})

WriteResult({

"nInserted" : 0,

"writeError" : {

"code" : 11000,

"errmsg" : "insertDocument :: caused by :: 11000 E11000 duplicate key error index: testdb.students.$name_1 dup key: { : \"student20\" }"

}

})

> db.students.find({name: "student5000"})

{ "_id" : ObjectId("587232e4a7eb9c0c7bd558e8"), "name" : "student5000", "age" : 80, "address" : "#85 Wenhua Road, Zhengzhou, China" }

#顯示查找語句執(zhí)行過程

> db.students.find({name: "student5000"}).explain()

{

"cursor" : "BtreeCursor name_1",

"isMultiKey" : false,

"n" : 1,

"nscannedObjects" : 1,

"nscanned" : 1,

"nscannedObjectsAllPlans" : 1,

"nscannedAllPlans" : 1,

"scanAndOrder" : false,

"indexOnly" : false,

"nYields" : 0,

"nChunkSkips" : 0,

"millis" : 0,

"indexBounds" : {

"name" : [

[

"student5000",

"student5000"

]

"server" : "node1:27017",

"filterSet" : false

}

> db.students.find({name: {$gt: "student5000"}}).explain()

{

"cursor" : "BtreeCursor name_1",

"isMultiKey" : false,

"n" : 5552,

"nscannedObjects" : 5552,

"nscanned" : 5552,

"nscannedObjectsAllPlans" : 5552,

"nscannedAllPlans" : 5552,

"scanAndOrder" : false,

"indexOnly" : false,

"nYields" : 43,

"nChunkSkips" : 0,

"millis" : 13,

"indexBounds" : {

"name" : [

[

"student5000",

{

}

]

"server" : "node1:27017",

"filterSet" : false

}

另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn，海內(nèi)外云服務(wù)器15元起步，三天無理由+7*72小時售后在線，公司持有idc許可證，提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國服務(wù)器、虛擬主機(jī)、免備案服務(wù)器”等云主機(jī)租用服務(wù)以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡單易用、服務(wù)可用性高、性價比高”等特點與優(yōu)勢，專為企業(yè)上云打造定制，能夠滿足用戶豐富、多元化的應(yīng)用場景需求。

網(wǎng)站標(biāo)題：57-1、2、3NoSQL基礎(chǔ)及MongoDB、Mongo-創(chuàng)新互聯(lián)
鏈接分享：http://muchs.cn/article6/dpiiog.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供品牌網(wǎng)站設(shè)計、做網(wǎng)站、移動網(wǎng)站建設(shè)、網(wǎng)站建設(shè)、品牌網(wǎng)站建設(shè)、建站公司

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源：創(chuàng)新互聯(lián)

猜你還喜歡下面的內(nèi)容

57-1、2、3NoSQL基礎(chǔ)及MongoDB、Mongo-創(chuàng)新互聯(lián)

57-1、2、3NoSQL基礎(chǔ)及MongoDB、Mongo-創(chuàng)新互聯(lián)