The Definitive Guide to MongoDB: The NoSQL Database for Cloud and Desktop Computing

Prelim......Page 1
Contents at a Glance......Page 6
Contents......Page 7
About the Authors......Page 18
About the Technical Reviewer......Page 19
Acknowledgments......Page 20
 A Special “Thanks” to MongoDB Beijing......Page 21
 Our Approach......Page 22
Basics......Page 23
   Using the Right Tool for the Right Job......Page 25
   Drilling Down on JSON and How It Relates to MongoDB......Page 27
   Adopting a Non-Relational Approach......Page 29
   Opting for Performance vs. Features......Page 30
   Generating or Creating a Key......Page 31
   Using Keys and Values......Page 32
   Using Document-Orientated Storage (BSON)......Page 33
   Supporting Dynamic Queries......Page 34
   Leveraging Geospatial Indexes......Page 35
   Storing Binary Data......Page 36
   Implementing Auto Sharding......Page 37
   Chatting with the MongoDB Developers......Page 38
  Summary......Page 39
  Choosing Your Version......Page 41
   Installing MongoDB Under Linux......Page 42
   Installing MongoDB Manually......Page 43
   Prerequisites......Page 44
   Using the MongoDB Shell......Page 45
  Installing Additional Drivers......Page 46
   Getting MongoDB for PHP......Page 47
   Installing PHP on Unix-based Platforms Automatically......Page 48
   Installing PHP on Unix-Based Platforms Manually......Page 49
   Confirming Your PHP Installation Works......Page 50
   Connecting to and Disconnecting from the PHP Driver......Page 51
   Installing PyMongo Automatically......Page 52
   Installing PyMongo Under Windows......Page 53
  Summary......Page 55
  Designing the Database......Page 57
   Drilling Down on Collections......Page 58
   Using Documents......Page 60
   Embedding vs. Referencing Information in Documents......Page 61
   Creating the _id Field......Page 62
  Building Indexes......Page 63
  Implementing Geospatial Indexing......Page 64
   Querying Geospatial Information......Page 65
  Summary......Page 68
   Viewing Available Databases and Collections......Page 69
  Inserting Data into Collections......Page 70
  Querying for Data......Page 71
   Using the Dot Notation......Page 73
   Using the Sort, Limit, and Skip Functions......Page 74
   Working with Capped Collections, Natural Order, and $natural......Page 75
   Retrieving Unique Values with Distinct()......Page 77
   Grouping Your Results......Page 78
   Working with Conditional Operators......Page 79
   Performing Greater and Less Than Comparisons......Page 80
   Matching all Attributes in a Document......Page 81
   Retrieving a Document with $slice......Page 82
   Filtering Results with $size......Page 83
   Matching Results Based on the BSON Type......Page 84
   Matching an Entire Array......Page 85
   $not (meta-operator)......Page 86
   Updating with update()......Page 87
   Incrementing a Value with $inc......Page 88
   Deleting a Given Field......Page 89
   Adding Data to an Array with $addToSet......Page 90
   Removing Elements from an Array......Page 91
   Specifying the Position of a Matched Array......Page 92
   Atomic Operations......Page 93
   Using the Update if Current Method......Page 94
   Modifying and Returning a Document Atomically......Page 95
  Removing Data......Page 96
   Referencing Data Manually......Page 97
   Referencing Data with DBRef......Page 98
  Implementing Index-Related Functions......Page 100
   Constraining Query Matches......Page 102
  Summary......Page 103
  Filling in Some Background......Page 105
  Working with GridFS......Page 106
  Getting Started with the Command-Line Tools......Page 107
   Determining a File’s Length......Page 108
   Hashing Your Files......Page 109
  Looking Under MongoDB’s Hood......Page 110
   Deleting......Page 112
  Exploiting the Power of Python......Page 113
   Connecting to the Database......Page 114
  Putting Files into MongoDB......Page 115
  Deleting Files......Page 116
  Summary......Page 117
Developing......Page 119
  Comparing Documents in MongoDB and PHP......Page 121
  MongoDB Classes......Page 122
  Connecting and Disconnecting......Page 123
  Inserting Data......Page 124
   Returning a Single Document......Page 126
   Listing All Documents......Page 127
   Querying for Specific Information......Page 128
   Sorting, Limiting, and Skipping Items......Page 129
   Counting the Number of Matching Results......Page 130
   Grouping Data with Map/Reduce......Page 131
   Refining Queries with Conditional Operators......Page 133
   Using the $lt, $gt, $lte, and $gte Operators......Page 134
   Matching Any of Multiple Values with $in......Page 136
   Searching for Multiple Expressions with $or......Page 137
   Retrieving a Specified Number of Items with $slice......Page 138
   Determining Whether a Field Has a Value......Page 139
   Regular Expressions......Page 140
   Updating via update()......Page 141
   Increasing the Value of a Specific Key with $inc......Page 143
   Deleting a Field with $unset......Page 144
   Adding Data to an Array with $addToSet......Page 145
   Removing an Element from an Array with $pop......Page 146
   Upserting Data with save()......Page 147
   Modifying a Document Atomically......Page 148
  Deleting Data......Page 151
  DBRef......Page 152
  GridFS and the PHP Driver......Page 154
   Adding More Metadata to Stored Files......Page 155
   Retrieving Files......Page 156
  Summary......Page 157
  Working with Documents in Python......Page 159
  Connecting and Disconnecting......Page 160
  Inserting Data......Page 161
   Finding a Single Document......Page 162
   Finding Multiple Documents......Page 163
   Returning Fields......Page 164
   Simplifying Queries with Sort, Limit, and Skip......Page 165
   Counting Unique Items with Distinct()......Page 167
   Grouping Data with map_reduce()......Page 168
   Specifying an Index with Hint()......Page 169
   Using the $lt, $gt, $lte, and $gte Operators......Page 170
   Specifying an Array of Matches with $in......Page 172
   Specifying Multiple Expressions to Match with $or......Page 173
   Retrieving Items from an Array with $slice......Page 174
   Conducting Searches with Regular Expression......Page 175
   Updating Your Data......Page 176
   Changing an Existing Value with $set......Page 178
   Adding a Value to an Array with $push......Page 179
   Adding a Value to an Existing Array with $addToSet......Page 180
   Removing a Specific Value with $pull......Page 181
   Saving Documents Quickly with Save()......Page 182
   Putting the Parameters to Work......Page 183
  Deleting Data......Page 184
  Creating a Link Between Two Documents......Page 185
   Retrieving the Information......Page 187
  Summary......Page 188
 Creating a Blog Application with the PHP Driver......Page 189
  Designing the Application......Page 190
  Listing the Posts......Page 191
   Paging with PHP and MongoDB......Page 193
  Looking at a Single Post......Page 194
   Specifying Additional Variables......Page 195
   Viewing and Adding Comments......Page 196
  Searching the Posts......Page 197
  Adding, Deleting, and Modifying Posts......Page 198
   Adding a New Post......Page 199
   Editing a Post......Page 200
   Deleting a Post......Page 201
  Creating the Index Pages......Page 202
  Recapping the blog Application......Page 203
  Summary......Page 212
Advanced......Page 213
 Database Administration......Page 215
   Creating a Backup 101......Page 216
  Digging Deeper into Backups......Page 219
  Restoring Individual Databases or Collections......Page 220
   Using a Local Datastore......Page 221
   Using a Remote (Cloud-Based) Datastore......Page 224
   Creating Snapshots with a Journaling Filesystem......Page 225
   Disk Layout to Use with Volume Managers......Page 227
  Importing Data into MongoDB......Page 228
  Exporting Data from MongoDB......Page 229
  Protecting Your Server with Authentication......Page 230
   Authenticating in the mongo Console......Page 231
   Changing a User’s Credentials......Page 232
   Deleting a User......Page 233
   Starting a Server......Page 234
   Reconfiguring a Server......Page 235
   Getting the Server’s Status......Page 236
   Shutting Down a Server......Page 238
   Repairing a Server......Page 239
   Validating a Single Collection......Page 240
   Repairing Collection Validation Faults......Page 241
   Repairing a Collection’s Datafiles......Page 242
  Monitoring MongoDB......Page 243
   Rolling Your Own Stat Monitoring Tool......Page 244
  Summary......Page 245
   Understanding How MongoDB Uses Memory......Page 247
  MongoDB Profiler......Page 248
   Finding Slow Queries......Page 249
   Analyzing a Specific Query with explain()......Page 250
   Using Profile and explain() to Optimize a Query......Page 251
  Managing Indexes......Page 254
   Creating a Simple Index......Page 255
   Constructing a Compound Index Manually......Page 256
   Killing the Indexing Process......Page 257
   Dropping an Index......Page 258
  How MongoDB Selects Which Indexes It Will Use......Page 259
  Optimizing the Storage of Small Objects......Page 260
  Summary......Page 261
 Replication......Page 263
   Improving Durability/Reliability......Page 264
  Drilling Down on the Oplog......Page 265
  Implementing Single Master/Single Slave Replication......Page 266
   Setting Up a Master/Slave Replication Configuration......Page 267
   Examining the Slave......Page 268
  Configuring a Master/Slave Replication System......Page 270
  Resynchronizing a Master/Slave Replication System......Page 271
   Resyncing a Slave with the --fastsync Option......Page 272
   Setting up a Multiple Master/Slave Replication Configuration......Page 273
   Implementing Master/Master Replication......Page 276
   Implementing Interleaved Replication......Page 277
  Using Replica Pairs......Page 278
   Setting up a Replica Pair......Page 279
   Coping with Failure......Page 281
   Connecting Your Application to a Replica Pair......Page 282
   Resolving Server Disputes with an Arbiter......Page 283
  Implementing Advanced Clustering with Replica Sets......Page 284
   Creating a Replica Set......Page 286
   Getting a Replica Set Member Up and Running......Page 287
   Adding a Server to a Replica Set......Page 288
   Managing Replica Sets......Page 289
   Inspecting an Instance’s Status with rs.status()......Page 290
   Forcing a New Election with rs.stepDown()......Page 291
   Determining If a Member is the Primary Server......Page 292
   Organization of the Members Structure......Page 293
   Exploring the Options Available in the Settings Structure......Page 294
   Connecting to a Replica Set from Your Application......Page 295
   Viewing Replica Set Status with the Web Interface......Page 296
  Summary......Page 297
  Exploring the Need for Sharding......Page 299
   Partitioning Data Horizontally......Page 300
  Analyzing a Simple Sharding Scenario......Page 301
  Implementing Sharding with MongoDB......Page 302
  Setting Up a Sharding Configuration......Page 304
   Adding a New Shard to the Cluster......Page 307
  Removing a Shard from the Cluster......Page 309
  Listing the Status of a Sharded Cluster......Page 310
  Sharding to Improve Performance......Page 312
  Summary......Page 313
 ¦ A......Page 315
 ¦ C......Page 316
 ¦ D......Page 317
 ¦ E......Page 319
 ¦ G......Page 320
 ¦ J......Page 321
 ¦ M......Page 322
 ¦ O......Page 323
 ¦ P......Page 324
 ¦......Page 325
 ¦ R......Page 326
 ¦ S......Page 327
 ¦ T......Page 328
 ¦ X......Page 329