MongoDB useful commands

Installation:

mongod --config "D:\MongoDB\bin\mongod.cfg" --install

net start MongoDB

User control:

db.createUser({user: "Bkp",pwd: passwordPrompt(), roles: [ "readWriteAnyDatabase" ]})

db.revokeRolesFromUser("Bkp", [{role:"readWriteAnyDatabase", db:"admin"}])

db.grantRolesToUser("Bkp",[{role:"backup",db:"admin"}])

db.createUser({user: "BACKUP_USER",pwd: "BKP", roles: [ "backup" ]})

db.dropUser("BACKUP_USER1")

db.createUser({user: "BACKUP_USER1",pwd: "BKP", roles: [ "read" ]})

db.grantRolesToUser("BACKUP_USER1",[{role:"readWriteAnyDatabase"}])

db.auth('webdev', 'xxxxx')

db.runCommand({connectionStatus : 1})

db.runCommand({connectionStatus : 1,showPrivileges:true})

Replicaset

mongod --bind_ip 192.168.56.1 --port 27019 --replSet rs0 --dbpath D:\MongoDB\Replicaset\data1 --oplogSize 200 --logpath D:\MongoDB\Replicaset\log1\log1.txt

mongod --bind_ip 192.168.56.1 --port 27020 --replSet rs0 --dbpath D:\MongoDB\Replicaset\data2 --oplogSize 200 --logpath D:\MongoDB\Replicaset\log2\log2.txt

mongod --bind_ip 192.168.56.1 --port 27021 --replSet rs0 --dbpath D:\MongoDB\Replicaset\data3 --oplogSize 200 --logpath D:\MongoDB\Replicaset\log3\log3.txt

rconfig={

_id:"rs0",

members:[

{_id:0,host:"192.168.56.1:27019"},

{_id:1,host:"192.168.56.1:27020"},

{_id:2,host:"192.168.56.1:27021"}]

}

rconfig

rs.initiate(rconfig)     # To activate replicaSet

rs.status()                   # To check the replicaSet status

rs.isMaster()              # To check the node is primary or not

rs.secondaryOk()       # To make it readable

rs.add("192.168.56.2:27019")  # To add a member to RS

rs.remove("192.168.56.2:27019")  # To remove a member from RS