MongoDB Series – Admin UIs

In this post we are going to manage MongoDB visually. MongoDB has many admin UIs for many platforms, you can visit http://www.mongodb.org/display/DOCS/Admin+UIs to choose your suitable client UI.

We are going to setup one of these admin UI , as we are using windows platform I preferred to use MongoVUE.

Brief about MongoVUE

MongoVUE is an innovative MongoDB desktop application for Windows OS that gives you an elegant and highly usable GUI interface to work with MongoDB. Now there is one less worry in managing your web-scale data.

Before Installation

After installing MongoDB on your machine you noticed that each time you have to run the server mongod shell and it must be running along your work with the database. For a better solution you can run MongoDB as a service behind the seen. First open your cmd and locate your MongoDB directory (for Win 7 run as an administrator) and type :

mongod --logpath d:\mongo\logs\logfilename.log --logappend --dbpath d:\mongo\data --install

lets explain each parameter :

–logpath Specify the log file path which will log every transaction on mongo server.
–logappend So that restarts of the service append to the existing log file.
–dbpath Specify the database saving path.

now you can find MongoDB service installed in your computer services

make sure it’s started and then try to connect by shell without running the mongod again.

Now we have to add a user to admin db so that we can connect from our server client and manage our databases.

every thing is now ready to install MongoVUE.

Install MongoVUE

Download MongoVUE installer from the official website and follow the wizard. Run MongoVUE from start menu.

When you run MongoVUE a window will show you the available connections so you can add/edit/delete connections to the server.

click on the green button to add a new connection, a window appears asking for basic settings.

Name Choose any name to save the connection with.
Server the localhost server IP for local connection is 127.0.0.1 otherwise put online address.
Port MongoDB default port is 27017
Username user can authenticate
Password: use’rs password
Database specify database or leave it blank so you can see all databases.

now you can test your connection and save it.

choose your connection and click connect , now you r running the server.

the left side bar shows the databases.

the admin database which holds the admin users, default system db local , and test db.

Now create new database let’s name it treenodesdb , right click on databases add database.

now you can add collections to treenodesdb , let’s create employees collection , right click on the database and add collection.

To add a document (record) on employees collection , right click on the collection and click insert document , will show dialogue to write the insert statement in BSON form

After adding some records  you can see all the records by clicking on View menu.

There are three types of view Tree View, Table View and Text View

This is the simplest actions you can do it on the Admin UI MongoVUE but there are advanced transactions will talk about it later.

References

http://www.mongodb.org/display/DOCS/Security+and+Authentication#SecurityandAuthentication-ViewingUsers

http://www.mongodb.org/display/DOCS/Admin+UIs#AdminUIs-MongoVision

http://www.mongovue.com/

Comments are closed.