MongoDB user creation and roles management
Security is a supreme criteria in the databases. Proper authentication in the databases must be enabled to ensure high security.
Category: MongoDB
Enabling Profiling in MongoDB
Database should have very good performance for the better production.To have better performance its necessary to optimize the
MongoDB 4.0 new features in nutshell
MongoDB has grown from being a niche database solution to the Swiss army knife of the NoSQL technologies. Grigori Melnik,
MongoDB GridFS explained
Many people are aware of the data type called BLOB in the database system that can store huge amount of
Health Instance Monitoring on MongoDB Cluster
Script to monitor Health Instance on MongoDB Cluster
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 | ## ## Script to Monitoring MongoDB Instances on a Cluster ## ## Show Servername and Status on the Cluster ## PHOME=$HOME/scripts/monitor PDATI=`date +%m%d%Y_%H%M%S` PLOGL=$PHOME/logs/mongodbmon_$PDATI.log PLOGE=$PHOME/logs/mongodbmon_$PDATI.err PPASS=PasswdUserWithRootPrivs PUSER=UserWithRootPrivileges PPORT=PortUsed export PHOME PLOGL PLOGE PPASS PUSER PPORT mongo -u$PUSER -p$PPASS --authenticationDatabase 'admin' --port $PPORT --eval 'rs.status()' --quiet > $PLOGL 2> $PLOGE grep "name" $PLOGL | sed 's/\t//g' | sed 's/,//g' | sed 's/"//g' | sed 's/name/Server/g' > $PHOME/temp01.txt grep "stateStr" $PLOGL | sed 's/\t//g' | sed 's/,//g' | sed 's/"//g' | sed 's/stateStr/Status/g' > $PHOME/temp02.txt awk 'FNR==NR { a[FNR""] = $0; next } { print a[FNR""],"-----", $0 }' $PHOME/temp01.txt $PHOME/temp02.txt > $PHOME/tmp.txt echo "Subject: MongoDB Instance Monitoring " | sendmail -v email@companyname.com < $PHOME/tmp.txt rm $PHOME/temp01.txt $PHOME/temp02.txt $PHOME/tmp.txt |
Note: Requires username and password with RootPrivileges.
Monitoring MongoDB Process
Script to monitor Mongo DB processes across a cluster.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | ## ## ## Script to Monitoring Mongo Process ## ## Search for all mongoX process on the cluster ## datevar=`date +"%m%d%Y"` timevar=`date +"%H%M%S"` PDATI=$datevar"_"$timevar PHOME=$HOME/scripts/monitor PLOGL=$PHOME/logs/mongomon_$PDATI.log PLOGE=$PHOME/logs/mongomon_$PDATI.err PCOMM="ps -fea | grep etc/mongo | grep -v grep | awk '{ print $8 }'" export PLOG1 PCOMM PHOME for i in `cat $HOME/scripts/cluster.cfg` do ssh $i "hostname && $PCOMM" 2> $PLOGE >> $PLOGL done cat $PLOGL | mail -s "DBSMT Mongo Cluster " email@companyname.com |
Log file result:
1 2 3 4 5 6 7 | [lusifer@node01 logs]$ more mongomon_10032018_115156.log node01 mongod 125916 1 1 Sep19 ? 03:56:42 /usr/bin/mongod -f /etc/mongod.conf --auth node02 mongod 58190 1 3 Sep19 ? 10:25:17 /usr/bin/mongod -f /etc/mongod.conf --auth node03 mongod 61171 1 3 Sep19 ? 10:23:20 /usr/bin/mongod -f /etc/mongod.conf --auth |
Note: Requires ssh passwordless
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
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“
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