MongoDB GridFS explained
Many people are aware of the data type called BLOB in the database system that can store huge amount of
Category: MongoDB
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
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
Hadoop-3.1.0 Multi Node Connection and Configuration in easiest way
HADOOP MULTI NODE INSTALLATION PROCESS [ Note: I am creating multi node in most easiest way by creating and using
Fragmentation on MongoDB databases
Fragmentation on MongoDB databases When we removing a large amount of data from the collection and no plan to