Technology

The Most Awaited Feature “SQL Joins” is Now Available in MongoDB 3.2

SQL Joins are used to combine documents/rows from 2 or more tables based upon common field present in them. MongoDB 3.2 launched the most awaited feature "Joins" which is supported in SQL database however was not present in the earlier version of MongoDB. This feature will change the way you design your database schema and application...

by Pawan Goyal
Tag: Mongo DB
17-Nov-2016

Technology

Too Many Indexes May kill your DB performance

Everyone thinks of creating index, but nobody pays attention towards removing them once they are created and not required .Too many indexes or unnecessary index can degrade your DB performance. To Optimize indexes in mongo we need to understand following things : How indexes works in mongoDB: Let’s say we have created compound...

by Pawan Goyal
Tag: Mongo DB
10-Aug-2016

Technology

Mongo Case Insensitive InList Query

As we know in Mongo the match queries are case sensitive. So whether we do a find() operation or use $match stage of aggregate pipeline, the condition would be true only if its a exact case sensitive match. Of cource we can use regex to do case insensitive queries but then again it will not work when we are trying to find a match with in...

by Sandeep Poonia
Tag: Mongo DB
23-Jul-2016

Technology

Mongo Point in Time Restoration

While working with databases sometimes there is a need to have data till a specific time or date across all the secondaries or database peers which is useful for testing a particular functionality. Also, in the event of outage, few folks would like to restore it to a specific weekend or month end just to have uniformity across all the...

by Amit Naudiyal
Tag: Mongo DB
24-Apr-2016

Application Security, Technology

Is your MongoDB publicly accessible?

MongoDB is a NoSQL database that delivers a performance oriented, highly available and scalable database system. Recently, a large number of MongoDB instances were found to be publicly accessible over the Internet. A large amount of data was leaked due to the fact that these instances were running an outdated and unpatched version of...

by Ankit Giri
Tag: Mongo DB
28-Jul-2015

AWS

How to Setup Replica Sets in Mongo DB (AWS EC2)

MongoDB is a popular NoSQL database that stores data in JSON like documents dynamic schemas instead of storing your data in tables and rows as you do with a relational database. In this blog we will setup Mongo DB replication on single node to demonstrate high availability and failover mechanism. What is a MongoDB Replica Set ? We...

by Neeraj Gupta
Tag: Mongo DB
22-Jun-2015