stage1.pdf

Transcript

1. ॳ识 MongoDB {“name”: “mongo”, “type”: “db”} Sunday, March 4, 12
2. ෆੋ 佄Ռ •humongousɼ䈀େతɼଖେᏠൺత •C++, 10gen ग़඼ Sunday, March 4, 12
3. ႓࿽值ಘ䎔஫త • Apache Cassandra (Facebook) • Apache CouchDB • Redis Sunday, March 4, 12
4. Apache Cassandra • Java • 㜎ࣅ BigTable • 查询ೳྗൺ MongoDB ᜗ऑ Sunday, March 4, 12
5. Apache CouchDB • Erlang • HTTP/REST ઀ޱɼՄ௚઀༻ js ૢ࡞ • JSON ֨ࣜ਺ਾ Sunday, March 4, 12
6. Redis • C/C++ • key-value ਺ਾ库ɼ࿨ Memcache 㜎ࣅɼୠੋշతଟ • ਺ਾՄҎอଘ౸ߗ盘 Sunday, March 4, 12
7. ಛ఺ • BSON ʢBinary JSONɼ扩లత JSONʣ • ਪᣑ 64 Ґ linux ܥ统ɼ഑ஔཁٻ较ߴɼਚՄೳଟత࢖༻಺ଘ • schema-free Ꮰ໛ࣜɼෆधཁݐද • NoSQL த查询ೳྗ较㖘తҰ䝅 • GridFS, Map Reduce, Auto-Sharding Sunday, March 4, 12
8. 术语 RDBMS MongoDB Database Database Table Collection Row Document Sunday, March 4, 12
9. ҆૷ • Ubuntu: # add to /etc/apt/sources.list deb http://downloads.mongodb.org/distros/ubuntu 10.10 10gen sudo apt-key adv --keyserver keyserver.ubuntu.com --recv 7F0CEB10 sudo apt-get update sudo apt-get install mongodb-stable • ௚઀ղ压ɿ wget http://fastdl.mongodb.org/linux/mongodb-linux-x86_64-1.6.5.tgz tar xzvf mongodb-linux-x86_64-1.6.5.tgz sudo mv mongodb-linux-x86_64-1.6.5 /usr/local/mongodb cd /usr/local/bin sudo ln -sf /usr/local/mongodb/bin/* Sunday, March 4, 12
10. 启动 •sudo /etc/init.d/mongodb start •sudo mongod --bind_ip 0.0.0.0 --port 27017 \ --dbpath /var/lib/mongodb \ --logpath /var/log/mongodb/mongodb.log \ --logappend --fork run • dbpath ᘍ认为 /data or C:\dataɼ೔ࢤ输ग़౸߇੍୆ 编码为 utf-8ɼ୺ޱ为 27017, 28017 Sunday, March 4, 12
11. ఀࢭ •sudo /etc/init.d/mongodb stop •Control-C •pgrep mongod | xargs sudo kill •mongo > db.shutdownServer() Sunday, March 4, 12
12. ؅ཧ • rockmongo (PHP) http://github.com/iwind/rockmongo • MongoHub-Mac (native app) http://github.com/bububa/MongoHub-Mac • 访问 http://127.0.0.1:28017 ໵ՄҎ查؃ঢ়态ɼൺ较简᮶ • 启动޳ᘍ认༗ࡾ࿽਺ਾ库 admin, test, localɼ޳䫆࿽为ۭ Sunday, March 4, 12
13. म䐾਺ਾ库 •sudo rm /var/lib/mongodb/mongod.lock sudo mongod --dbpath /var/lib/mongodb --repair • ༻ဋඇਖ਼ৗ䎔ص౳导கෆೳਖ਼ৗ启动త৘ႎ Sunday, March 4, 12
14. 备㟨༩还ݪ • 备㟨ɿmongodump -h 127.0.0.1 -d foo • 还ݪɿmongorestore -h 127.0.0.1 -d foo dump/foo • ೋ进੍ɼ㭕༻ဋ׬੔备㟨 Sunday, March 4, 12
15. 导ग़༩导ೖ • 导ग़ɿ mongoexport -h 127.0.0.1 -d foo -c bar > bar.js • 导ೖɿ mongoimport -h 127.0.0.1 -d foo -c bar --file bar.js • 纯จຊɼ㭕༻ဋগྔ҃෦෼਺ਾ Sunday, March 4, 12
16. ߇੍୆ •mongo mongo 127.0.0.1/foo mongo 127.0.0.1:27017/foo •V8 or Spider Monkey JS Ҿ№ɼ᪑ࣸ js ࠩෆଟ Sunday, March 4, 12
17. ᎎೖ > use blog switched to db blog > entry = {'title':'mongo', 'author':'ratazzi', 'tags':['mongo', 'basic'], 'content':'...'} { ! "title" : "mongo", ! "author" : "ratazzi", ! "tags" : [ ! ! "mongo", ! ! "basic" ! ], ! "content" : "..." } > db.entries.insert(entry) Sunday, March 4, 12
18. 查询 > db.entries.findOne({author:'ratazzi'}) { ! "_id" : ObjectId("4d26c758a44a96211b000000"), ! "title" : "stage1", ! "author" : "ratazzi", ! "tags" : [ ! ! "mongo", ! ! "basic" ! ] } Sunday, March 4, 12
19. ߋ৽ > entry = db.entries.findOne(){ ! "_id" : ObjectId("4d26d40ab7aa5974220a55cb"), ! "author" : "ratazzi", ! "content" : "...", ! "last_modify" : 1294390054, ! "tags" : [ ! ! "mongo", ! ! "basic" ! ], ! "title" : "mongo" } > db.entries.update({_id:entry['_id']}, {$set:{last_modify: 1294390054}}) Sunday, March 4, 12
20. ࡧҾ > db.entries.ensureIndex({last_modify:-1}) Sunday, March 4, 12
21. 删আ > db.entries.remove({_id:entry['_id']}) Sunday, March 4, 12
22. ҆શੑ • ෆଘࡏ㜎ࣅ SQL ஫ೖత问题 Sunday, March 4, 12
23. Production Deployments • foursquare • bit.ly • Github • sourceforge.net • ea.com Sunday, March 4, 12