6 Interesting Features In MongoDB 6.0

Introduction

In this blog, we explore the remarkable enhancements introduced in MongoDB 6.0. We will have a look into the key updates related to indexes, syntax error handling, powerful aggregation capabilities, replicaset improvements, time series collection changes, and the ability to exclude embedded fields. Let’s explore the potential of MongoDB 6.0 and revolutionize your database management experience.

In this blog we are going to see 6 main features in Mongodb 6.0.

Note: These features are specifically after 5.0 versions.

Topics Covered

Below are the 6 interesting features that we have covered in this blog.

1. Changes and Improvements Related With Indexes
2. Syntax Error Handling
3. Aggregation
4. Replicaset Changes
5. Time Series Collection Changes
6. Exclude Embedded Field on serverStatus

1.Changes and Improvements Related With Indexes

CollMod

• Introducing new features in the ‘collMod’ function, a powerful command that allows you to modify existing indexes without the need for recreation. With ‘collMod,’ you can easily make indexes unique, hidden, and even add Time-to-Live (TTL) settings.
• To make the existing index unique, you need to first prevent any incoming duplicate entries. You can achieve this by using the following command, which will stop duplicate entries on the ‘createdAt’ field associated with the index named ‘createdAt_1’.

• Then make the existing index ‘createdAt_1’ unique with the below command.

• By using the ‘collMod’ function, you can modify an existing index to be hidden, making it invisible to regular queries.

db.runCommand({collMod:"collections_name",index:{name: "createdAt_1", hidden: true}})

 

• By using the ‘collMod’ function, enabling TTL on an existing index becomes effortless.

db.runCommand({collMod:"collections_name",index:{name: "createdAt_1", expireAfterSeconds: 30000}})


Drop all Indexes

 

• Now you can drop all the indexes from the collection with a single command, except for the primary index (‘_id’) with the below command.

db.collections_name.dropIndexes()


New operators in partial index

 

• Introducing new operators in the partial index: $in and $or. The $in operator indexes only the documents where the mentioned field (id1) has values of 1 and 2. On the other hand, the $or operator indexes only the documents where the mentioned field (id1) has a value of 1 or 2.

db.collections_name.createIndex({"id1":1},{partialFilterExpression:{id1: {$in: [1,2]}}})

db.collections_name.createIndex({"id1":1},{partialFilterExpression:{$or: [{id1:1},{id1:2}]}})


2. Syntax Error Handling

 

• When you make a syntax error, there is no need to search for the position where you made it. In the new version, it will display the line and position at which you made the error.

Uncaught:
SyntaxError: Unexpected token (1:26)

> 1 | db.collections_name.find({)
| ^
2 |

3. Aggregation

• Introducing new stages in the aggregation:

$documents, $densify, $fill, and $shardedDataDistribution.

 

• Introducing new operators in the aggregation:

$bottom, $bottomN, $firstN, $lastN, $linearfill, $locf, $maxN, $minN, $sortArray, $top, $topN, $tsIncrement and $tsSecond.

Note: Shall provide a more detailed explanation in my upcoming blogs.


4. Replicaset Changes

 

• Introducing the ‘initialSyncMethod’ which determines whether the initial sync method is logical or file-based. Please note that this option is only available in MongoDB Enterprise server.
• Support for multiple arbiters in a replica set is disabled by default. To enable this feature, start each node with the ‘allowMultipleArbiters’ parameter.

5. Time Series Collection Changes

• Now, you can perform updates and deletes on time series collections with some limitations.
• You can only match metafield data values for both update and delete operations. Additionally, you can only modify the value of the metaField field during an update.
• The update and delete commands should not limit the number of documents. Instead, you can utilize the ‘updateMany’ and ‘deleteMany’ commands.
• Introducing Column Compression, which reduces the size of data on disk when compressed with zstd. Additionally, it significantly reduces the space used in the WiredTiger cache.
• Now you can add the additional secondary indexes on the time series collection.

6. Exclude Embedded Field on serverStatus

• Now you can exclude any of the embedded fields from the output of the ‘db.serverStatus()’ command. For example, the ‘histograms’ embedded field has been excluded below.

db.runCommand( { serverStatus: 1, metrics: { query: { multiPlanner: { histograms: false } } } } )

Summary:

MongoDB 6.0 brings a host of significant improvements to streamline your database management. With the introduction of the ‘collMod’ function, modifying indexes becomes more flexible and convenient. Enhanced syntax error handling ensures smoother troubleshooting. Unlock advanced aggregation stages and operators to elevate your data analysis capabilities. Benefit from replicaset changes that offer improved syncing methods. Explore new possibilities in time series collection operations and effortlessly exclude embedded fields in serverStatus output. Upgrade to MongoDB 6.0 and embrace a more efficient and powerful approach to data management.