MongoDB graceful shutdown script. [root@hostname bin]$ cat new_shutdown.sh #!/bin/bash BIN=/tmp/mongodb/bin DB=admin HOST=`hostname` cd $BIN MONGOPID=`ps -ef | egrep ‘mongod|mongos’ | grep -v egrep | awk ‘{print $2}’` if [ -z $MONGOPID ]; then echo “There are no Mongo processes are…
The following factors influence the Initial sync & sharding timings i.e., the initial sync between primary and secondary for a replica set or the initial sharding/balancing for a sharded cluster 1. Document size 2. No. of documents/collections 3. No….
This is a custom implementation created by the MongoDB developers as a specific index type, and is due to be launched as an experimental feature in MongoDB 2.4. It has features such as: Full text search as an index type…
We observed that inconsistent document counts of a collection when we query thru mongos during initial sharding due to newly added shard to the existing set-up. It’s expected to have inconsistent counts when we query directly on shard, but App…
While there are no built in commands for lock/unLock, it is possible to add them. Here are a couple of simple implementations that remove the user you want to lock from the db.system.users collection and save it in a lockedUsers…
If we create a user in Mongos (router), we can authenticate Mongod’s (RS/Shard: in case of shard, user should have ‘clusterAdmin’ role) using that user. But still we can directly connect to Mongod’s with localhost exception with out any UN/PW….
MemSQL commands must be run on the appropriate type(s) of node in a MemSQL cluster. Please refer the link MemSQL Commands by Type — MemSQL 2.6 documentation for more details. X = recommended to run on this type of node…
some useful Aggregator commands. At Master Aggregator :- ——————— Please find the each command description at http://developers.memsql.com/docs/latest/ref/index.html#select mysql> select database(); +————+ | database() | +————+ | ycsb | +————+ 1 row in set (0.00 sec) mysql> show tables; +—————–+ |…
We have 3 config servers ( say config1, config2 & config3 ) in production and imagine we have config db differ issue (configdb mismatch) on the config1 & config3. Then we may have to follow the following procedure to recover…
To add the scripts in start-up, we can use any of the one following command. In the below scenario, say you wanted add mongod start/stop/restart script to Linux ( reboot/start-up) [root@12d4-dl585-03 init.d]# chkconfig –add mongod [root@12d4-dl585-03 init.d]# (OR) Add a…