MongoDB Groom expanding space

What is a groom job in MongoDB? Read more →

The default write concern may change when upgrading to 5.0

Question: After an upgrade from MongoDB 4.4 to MongoDB 5 some start up warning signs have appeared . {"t":{"$date":"2023-01-20T13:35:05.354+00:00"},"s":"I", "c":"REPL", "id":5569202, "ctx":"ReplCoord-0","msg":"** WARNING: The default write concern may change when upgrading to 5.0. Use setDefaultRWConcern to set a cluster-wide default write concern that won't change.","tags":["startupWarnings"]} What is the fix ? Answer: db.adminCommand( { setDefaultRWConcern : 1, defaultWriteConcern: { "w" : "majority" } } ) Read more →

Is mongodb+srv necessary for a MongoDB connection

MongoDB SRV on connection strings allows better management on connection string management Read more →

Default Isolation Levels across database systems

Most DBMS systems have a range of isolation levels. Fine line between bugs & deadlocks related to setting isolation levels Read more →

How to automatically delete MongoDB documents after a certain time with TTL indexes

A developer asked me if event log data can be cleared from a MongoDB automatically Read more →

How to use MongoDB queries to increase your DBA expertise

A group of application developers asked me for a quick guide on MongoDB queries Read more →

How to display current user in MongoDB

How to view your current user details on MongoDB Read more →

How to create an index on a MongoDB collection

A question about creating a MongoDB index for a collection Read more →

How to rename a MongoDB database

A developer asked me how to rename a MongoDB database Read more →

How to avoid displaying password with Mongo shell logon

Question: I'd like to document a procedure to logon with Mongo shell but to not display the password . The situation is I'm running a the mongo Shell and then storing the command in a text file . Clearly this causes a security threat problem. Is there an option to avoid this situation mongo --port 27017 -u "myUser" -p "myPw" --authenticationDatabase "admin" Answer: This is an interesting problem - it's not uncommon to end up with connection strings with hard coded passwords across the network , desktops , internal sharepoint sites and anywhere you can store a connection string. There... Read more →