Book Image

MongoDB Administrator???s Guide

By : Cyrus Dasadia
Book Image

MongoDB Administrator???s Guide

By: Cyrus Dasadia

Overview of this book

MongoDB is a high-performance and feature-rich NoSQL database that forms the backbone of the systems that power many different organizations. Packed with many features that have become essential for many different types of software professional and incredibly easy to use, this cookbook contains more than 100 recipes to address the everyday challenges of working with MongoDB. Starting with database configuration, you will understand the indexing aspects of MongoDB. The book also includes practical recipes on how you can optimize your database query performance, perform diagnostics, and query debugging. You will also learn how to implement the core administration tasks required for high-availability and scalability, achieved through replica sets and sharding, respectively. You will also implement server security concepts such as authentication, user management, role-based access models, and TLS configuration. You will also learn how to back up and recover your database efficiently and monitor server performance. By the end of this book, you will have all the information you need—along with tips, tricks, and best practices—to implement a high-performance MongoDB solution.
Table of Contents (17 chapters)
Title Page
Credits
About the Author
About the Reviewers
www.PacktPub.com
Customer Feedback
Preface

Managing existing indexes


In this recipe, we will be looking at some common operations we can perform on indexes like viewing, deleting, checking index sizes, and re-indexing.

Getting ready

For this recipe, load the sample dataset and create an index on the city field, as described in the previous recipe.

How to do it...

  1. We begin by connecting to the mongo shell of the server and viewing all indexes on the system:
> db.mockdata.getIndexes()

The following result is obtained:

[
  {
    "v" : 2,
    "key" : {
      "_id" : 1
    },
    "name" : "_id_",
    "ns" : "mydb.mockdata"
  },
  {
    "v" : 2,
    "key" : {
      "city" : 1,
      "first_name" : 1
    },
    "name" : "city_1_first_name_1",
    "ns" : "mydb.mockdata"
  }
]
  1. Execute a dropIndex() command to delete a particular index:
> db.mockdata.dropIndex('city_1_first_name_1')

You should see the following result:

 

{ "nIndexesWas" : 2, "ok" : 1 }
  1. Let's recreate the index:
> db.mockdata.createIndex({'city':1}, {name: 'city_index'})

{
   ...