Welcome to MongoDB

Presentation on MongoDB basics presented at http://www.meetup.com/Oporto-mongoDB-User-Group/events/139839692/

Transcript

1. Welcome to MongoDB Senior Solutions Architect, MongoDB Norberto Leite #portomug
2. http://2.bp.blogspot.com/-SmvbTyt0Fv8/T-Iq9T2k87I/AAAAAAAACa8/hQ_61YKKgIA/s320/Dino-Meira.jpg
3. Who am I •  Norberto •  Solutions Architect •  Barcelona (on my way to Brussels) •  I like databases
4. Agenda
5. Agenda •  Databases •  MongoDB •  Features •  QA •  PIZZA + SUPER BOCK
6. Databases
7. Relational by Default Did you learn anything else but relational database in school?
9. Relational Databases •  Been around for a while –  First paper to be published on relational db back to 1970 –  http://dl.acm.org/citation.cfm?doid=362384.362685 •  Lot’s of different tech based on SQL •  Default standard for persisting information
10. Norberto Leite, Solutions Architect, MongoDB “We are hooked on SQL/RDMS”
11. Norberto, Solutions Architect, MongoDB “Don’t ever quote yourself on your own presentations. That’s just silly!”
12. With “relations” between rows
14. It hides what you’re really doing
15. Relational Databases Optimize for Storage
17. RDBMS Scale = Bigger Computers “Clients can also opt to run zEC12 without a raised datacenter floor -- a first for high-end IBM mainframes.” IBM Press Release 28 Aug, 2012
18. Key -> Value •  One-dimensional storage •  Single value is a blob •  Query on key only •  No schema •  No updates just replaces Key Blob
19. Relational •  2-dimensional storage (tuples) •  Each field contains one value •  Query on any field •  Very structured schema (tables) •  In-place updates •  Normalization requires many tables, joins, indexes •  Poor data locality Primary Key
20. Document •  N-dimensional storage •  Each field can contain 0,1, many or embedded values •  Query on any field & level •  Flexible schema •  Inline updates •  Embedding related data has optimal data locality, requires fewer indexes, has better performance _id
21. NoSQL
22. NoSQL Databases •  Key Value Stores –  Redis •  Tabular –  Cassandra –  Hbase –  CouchBase •  Document –  MongoDB –  CouchDB •  Graph –  OrientDB –  Neo4J
23. Document Database
24. Terminology RDBMS MongoDB Table, View ➜ Collection Row ➜ Document Index ➜ Index Join ➜ Embedded Document Foreign Key ➜ Reference Partition ➜ Shard
25. In a relational base app We would start by doing schema design
26. Typical (relational) ERD User ·Name ·Email address Category ·Name ·URL Comment ·Comment ·Date ·Author Article ·Name ·Slug ·Publish date ·Text Tag ·Name ·URL
27. In a MongoDB based app We start building our app and let the schema evolve
28. MongoDB ERD User ·Name ·Email address Article ·Name ·Slug ·Publish date ·Text ·Author Comment[] ·Comment ·Date ·Author Tag[] ·Value Category[] ·Value
29. NoSQL are Optimize for Usage
30. What is MongoDB?
31. http://geekandpoke.typepad.com/.a/6a00d8341d3df553ef0162fd7fe2e6970d-pi
32. MongoDB is a ___________ database •  Document •  Open source •  High performance •  Horizontally scalable •  Full featured
33. Document Database •  Not for .PDF & .DOC files •  A document is essentially an associative array •  Document = JSON object •  Document = PHP Array •  Document = Python Dict •  Document = Ruby Hash •  etc
34. Open Source •  MongoDB is an open source project •  On GitHub •  Licensed under the AGPL •  Started & sponsored by 10gen •  Commercial licenses available •  Contributions welcome
36. High Performance •  Written in C++ •  Extensive use of memory-mapped files i.e. read-through write-through memory caching. •  Runs nearly everywhere •  Data serialized as BSON (fast parsing) •  Full support for primary & secondary indexes •  Document model = less work
37. Database Landscape Depth of Functionality Scalability & Performance Memcached MongoDB RDBMS
38. Full Featured •  Ad Hoc queries •  Real time aggregation •  Rich query capabilities •  Strongly consistent •  Geospatial features •  Support for most programming languages •  Flexible schema
39. mongodb.org/downloads
40. $ tar –z xvf mongodb-osx-x86_64-2.4.x.tgz $ cd mongodb-osx-i386-2.4.4/bin $ mkdir –p /data/db $ ./mongod Running MongoDB
41. MacBook-Air-:~ $ mongo MongoDB shell version: 2.4.4 connecting to: test > db.test.insert({text: 'Welcome to MongoDB'}) > db.test.find().pretty() { "_id" : ObjectId("51c34130fbd5d7261b4cdb55"), "text" : "Welcome to MongoDB" } Mongo Shell
42. Working With MongoDB
43. var user = { username: ’erlichson', first_name: ’Andrew', last_name: ’Erlichson', } Start with an object (or array, hash, dict, etc)
44. >db test > use blog switching to db blog > db.users.insert( user ) Switch to Your DB
45. > db.users.insert(user) Insert the Record No collection creation necessary
46. > db.users.findOne() { "_id" : ObjectId("50804d0bd94ccab2da652599"), "username" : ”erlichson", "first_name" : ”Andrew", "last_name" : ”Erlichson" } Find One Record
47. _id •  _id is the primary key in MongoDB •  Automatically indexed •  Automatically created as an ObjectId if not provided •  Any unique immutable value could be used
48. ObjectId •  ObjectId is a special 12 byte value •  Guaranteed to be unique across your cluster •  ObjectId("50804d0bd94ccab2da652599") |----ts-----||---mac---||-pid-||----inc-----| 4 3 2 3
49. > db.article.insert({ title: ‘Hello World’, body: ‘This is my first blog post’, date: new Date(‘2013-06-20’), username: ‘erlichson’, tags: [‘adventure’, ‘mongodb’], comments: [ ] }) Creating a Blog Post
50. > db.article.find().pretty() { "_id" : ObjectId("51c3bafafbd5d7261b4cdb5a"), "title" : "Hello World", "body" : "This is my first blog post", "date" : ISODate("2013-06-20T00:00:00Z"), "username" : "erlichson", "tags" : [ "adventure", "mongodb" ], "comments" : [ ] } Finding the Post
51. > db.article.find({tags:'adventure'}).pretty() { "_id" : ObjectId("51c3bcddfbd5d7261b4cdb5b"), "title" : "Hello World", "body" : "This is my first blog post", "date" : ISODate("2013-06-20T00:00:00Z"), "username" : "erlichson", "tags" : [ "adventure", "mongodb" ], "comments" : [ ] } Querying An Array
52. > db.article.update({_id: new ObjectId("51c3bcddfbd5d7261b4cdb5b")}, {$push:{comments: {name: 'Steve Blank', comment: 'Awesome Post'}}}) > Using Update to Add a Comment
53. > db.article.findOne({_id: new ObjectId("51c3bcddfbd5d7261b4cdb5b")}) { "_id" : ObjectId("51c3bcddfbd5d7261b4cdb5b"), "body" : "This is my first blog post", "comments" : [ { "name" : "Steve Blank", "comment" : "Awesome Post" } ], "date" : ISODate("2013-06-20T00:00:00Z"), "tags" : [ "adventure", "mongodb" ], "title" : "Hello World", "username" : "erlichson" } Post with Comment Attached
54. MongoDB Drivers
55. Real applications are not built in the shell
56. MongoDB has native bindings for over 12 languages
59. Replication @ Secondary Secondary Primary Client Application Driver Write Read Read
60. Replica Set – Failover Node 1 Secondary Node 2 Primary Node 3 Replication Heartbeat
61. Sharding @ www.etiennemansard.com
62. Horizontal Scalability (Scale Out)
63. Node 1 Secondary Config Server Node 1 Secondary Config Server Node 1 Secondary Config Server Shard Shard Shard Mongos App Server Mongos App Server Mongos App Server Sharding infrastructure
64. Much More Productive
65. Way More Productive
66. Obrigado norberto@mongodb.com @nleite #portomug
67. QA