Category: MongoDB

MongoDB GridFS explained

Posted on March 20, 2019March 24, 2019 by Jerwin Roy

Many people are aware of the data type called BLOB in the database system that can store huge amount of

Why you need to choose mongodb over other databases?

Posted on March 20, 2019March 24, 2019 by Jerwin Roy

In the recent times i have come across various perople asking why do we need to

Health Instance Monitoring on MongoDB Cluster

Posted on October 9, 2018November 25, 2018 by Luis Silva

Script to monitor Health Instance on MongoDB Cluster

##
## 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 &gt; $PLOGL 2&gt; $PLOGE

grep "name" $PLOGL | sed 's/\t//g' | sed 's/,//g' | sed 's/"//g' | sed 's/name/Server/g' &gt; $PHOME/temp01.txt
grep "stateStr" $PLOGL | sed 's/\t//g' | sed 's/,//g' | sed 's/"//g' | sed 's/stateStr/Status/g' &gt; $PHOME/temp02.txt

awk 'FNR==NR { a[FNR""] = $0; next } { print a[FNR""],"-----", $0 }' $PHOME/temp01.txt $PHOME/temp02.txt &gt; $PHOME/tmp.txt

echo "Subject: MongoDB Instance Monitoring " | sendmail -v email@companyname.com &lt; $PHOME/tmp.txt
rm $PHOME/temp01.txt $PHOME/temp02.txt $PHOME/tmp.txt

## 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

Posted on October 3, 2018November 25, 2018 by Luis Silva

Script to monitor Mongo DB processes across a cluster.

##
##
## 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 &amp;&amp; $PCOMM" 2&gt; $PLOGE &gt;&gt; $PLOGL
done

cat $PLOGL | mail -s "DBSMT Mongo Cluster " email@companyname.com

## 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`

ssh $i "hostname && $PCOMM" 2> $PLOGE >> $PLOGL

done

cat $PLOGL | mail -s "DBSMT Mongo Cluster " email@companyname.com

Log file result:

[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