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 →

How to identify if MongoDB Backup Snapshot Encryption is enabled

Question: How can I identify if Backup Snapshot Encryption for MongoDB using the KMIP compliant management is enabled & configured? Answer: To have MongoDB Backup Snapshot Encryption enabled the DBA would apply a master key that a KMIP-compliant key management appliance would generate and maintain. This master key encrypts key that encrypts the database. As outlined in the MongoDB documentation : "Prerequisites : A host running KMIP-compliant key management to generate and store encryption keys. IMPORTANT Clusters running MongoDB FCV 4.2 or later must use KMIP servers. These clusters don’t support local key management using files. IMPORTANT You must maintain... Read more →