Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Being a DBA we have many hands-on experience and knowledge about replication. But replication is quite a bit different in case of Cassandra because it …
Read More »
NoSQL
Why you need to choose mongodb over other databases?
In the recent times i have come across various perople asking why do we need to adopt MongoDB as a database …
Read More »How to improve database performance on MongoDB part3
You should read below articles before reading this article. “How to improve database performance on MongoDB part 1“, “How to improve database performance on …
Read More »How To Improve Database Performance on MongoDB Part2
This article is the second part of the article named “How to improve database performance on MongoDB part 1“ Ensure you have enough RAM. …
Read More »MongoDB Resync stale replica member
In a replica set if one of the members is in RECOVERING state and in the log file of that member if you see: [crayon-66a49b83e4f64085033638/] …
Read More »How To Improve Database Performance on MongoDB Part 1
This little guide is medium in scope, it is not exhaustive. It just gives you an idea to focus 1 Choose the right storage …
Read More »Fragmentation on MongoDB databases
Fragmentation on MongoDB databases When we removing a large amount of data from the collection and no plan to replace it, we generate a …
Read More »Change Data directory and index_path to specific directory path if cluster is built using rolling method
Total Time to perform Activity is: 2hr The following are the high level Steps from DB side: Step 1: Disable Auto-Failover Remove node which …
Read More »Point in time recovery on Mongodb Standalone server.
1:- Enable oplog using –master option while starting mongod service [Version 3.2]. And later version (3.2 +) need to put replSetName=rs0 into the mongo.conf file in …
Read More »Slow queries on MongoDB
During a typical revision of mongod’s logs, we could find slow queries, by default, those queries that take more >100ms. You can change this time …
Read More »