Mongodb: Difference between revisions
No edit summary  | 
				|||
| Line 36: | Line 36: | ||
         sudo service mongod restart  |          sudo service mongod restart  | ||
         sudo mongo  |          sudo mongo # may take a minute to be available...  | ||
           rs.initiate()  |            rs.initiate()  | ||
         # hit return after a moment to ensure it becomes PRIMARY  |          # hit return after a moment to ensure it becomes PRIMARY  | ||
Revision as of 15:57, 26 May 2021
Installation
mh-install-mongodb
UI tools =
- MongoDB_Admin
 
git clone https://github.com/hatamiarash7/MongoDB_Admin cd MongoDB_Admin npm start &
- Robo 3T
 
~/apps/robo3t/bin/robo3t &
Querying
- OR
 
{"$or": [{"firstName": "Michael"}, {"firstName": "Tom"}]}
- To remove all documents that do not have a certain value:
 
db.inventory.remove( { type : { $ne: "food" } } )
- To remove all documents that do not have a range of values:
 
db.inventory.remove( { type : { $nin: ["Apple", "Mango"] } } )
Run a script or statement from command line
# This will drop the bookstore db mongo bookstore --eval "printjson(db.dropDatabase())"
Convert a single node to a replica set
This is apparently required for transactions to work...?
- CONVERTING TO SINGLE-NODE REPLICA SET:
 
       sudo emacs -nw /etc/mongod.conf
           # -----------------------
           # MBM enable replication
           replication:
               replSetName: esrs1
           # -----------------------
       sudo service mongod restart
       sudo mongo # may take a minute to be available...
         rs.initiate()
       # hit return after a moment to ensure it becomes PRIMARY