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...
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...
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...
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...
Application Security, Technology
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...
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...