MongoDB deployment super detailed step records

# /try/download/community
wget /linux/mongodb-linux-x86_64-rhel70-7.0.

tar fx mongodb-linux-x86_64-rhel70-7.0. -C /usr/local/

ln -s /usr/local/mongodb-linux-x86_64-rhel70-7.0.14/ /usr/local/mongodb

mkdir /usr/local/mongodb/{data,logs}
touch /usr/local/mongodb/logs/

vim /etc/profile
export MONGODB_HOME=/usr/local/mongodb
export PATH=$MONGODB_HOME/bin:$PATH

source /etc/profile

vim /etc/
#Specify the database pathdbpath=/usr/local/mongodb/data
#Specify MongoDB log filelogpath=/usr/local/mongodb/logs/
# Write logs using appendlogappend=true
#Port Numberport=27017 
#Convenient to access external networkbind_ip=0.0.0.0
fork=true # Run MongoDB as a daemon and create a server process#auth=true #Enable user authentication#bind_ip=0.0.0.0 #Bind service IP, if 127.0.0.1 is bound, it can only be accessed by local machine. If it is not specified, all local IPs will be defaulted to be accessed by default.#replSet=single #Enable oplog log for master-slave replication

# start upmongod -f /etc/
# closuremongod --shutdown -f /etc/

 ps -ef|grep mongodb
 netstat -ntlp|grep 27017

# Download link: /try/download/shellwget /compass/mongosh-2.3.

tar fx mongosh-2.3.

cp mongosh-2.3.2-linux-x64/bin/mongosh /usr/local/bin/

# No certification requiredmongosh
# Need to be certifiedmongosh mongodb://192.168.9.25:27017/admin -u "admin" -p "abc123456"

# Can only create logic libraries in adminreadAnyDatabase: Only create users inadminIn the logic library，Allows reading of any logical library
readWriteAnyDatabase: Only create users inadminIn the logic library，Allows reading and writing of any logical library
dbAdminAnyDatabase: Only create users inadminIn the logic library，Allows management of any logical library
userAdminAnyDatabase: Only create users inadminIn the logic library，Allows management of any logical library用户
clusterAdmin: Only create users inadminIn the logic library，Allow managementMongoDBCluster
root: Only create users inadminIn the logic library，Super Administrator，Have the highest authority

# Create on the specified logical libraryRead: Allows users to read the specified logical library
readWrite: Allows users to read and write specified logic libraries
dbAdmin: Can manage specified logical libraries
userAdmin: Users who can manage specified logical libraries

# Create an administratoruse admin
({user:"admin",pwd:"abc123456",roles:[{role:"root",db:"admin"}]})
# Create a normal roleuse common
({user:"qyc",pwd:"abc123456",roles:[{role:"dbAdmin",db:"common"},{role:"readWrite",db:"common"}]})

# Query all().pretty()
show users
# Query the specified role('qyc')
({usersInfo:"qyc"})

('qyc',{'roles':[{'role':'userAdmin','db':'common'},{'role':'read','db':'common'}]})

("qyc", "123456")

('qyc')

('qyc','123456')

show dbs

# Switch to the specified library, it will be automatically created if it does not existuse common

db

()

("student")

show collections

("stu")

()

# ()
# View the total size of the collection (bytes in units)()
# View the statistics of the collection()

()

# Insert a single({name:"Scott",sex:"male",age:25,city:"Beijing"})
# Insert multiple lines, save will update if the primary key of save exists, and insert if it does not exist.([{name:"Scott3",sex:"male",age:22,city:"Beijing"},{name:"Scott2",sex:"male",age:22,city:"Beijing"}])
([{name:"Scott3",sex:"male",age:22,city:"Beijing"},{name:"Scott2",sex:"male",age:22,city:"Beijing"}])
([{name:"Scott3",sex:"male",age:22,city:"Beijing"},{name:"Scott2",sex:"male",age:22,city:"Beijing"}])

# Modify a record({name:"Scott2"},{$set:{age:26,classno:"2-6"}})
# Modify multiple records({name:"Scott3"},{$set:{classno:"2-7"}})
# Add 2 to the age attribute({},{$inc:{age:2}})
# Add elements to array properties({name:"Scott"},{$push:{role:"Squad Leader"}})

ObjectId("66dac03ddf68fdd4c95796d4").getTimestamp()

# Delete fields in the document, {} means modifying all({name:"Scott"},{$unset:{classno:"2-6"}})
# Delete an element in the array({name:"Scott"},{$pull:{role:"Squad Leader"}})
# Delete all documents({})
# Delete the specified document({name:"Scott2"})

# Query all documents()
# Query the specified document and display the specified field. 1 is displayed, 0 is not displayed.({name:"Scott3",classno:"2-8"},{name:1,_id:0})
({age:{$gte:24}})
({name:/^S/})
# View single record({name:/3$/})
# Document nested query# {class:{type: 1, data: [1,2,3]}}
({:1})
({.1:2})
({:[1,2,3]})

# Take the first ten().limit(10)
# Get ten items starting from 21 items().skip(20).limit(10)

# Data sort (1 represents ascending order, -1 represents descending order)().sort({name:1})

# Return the specified data after deduplication, the format is an array("name")
# is the data sort after deduplication (-1 is positive order, 1 is reverse order)("name").sort(function(){return -1})
# Intercept the specified data in the array, (0,5) means intercepting from the first line to the sixth line, (5) means intercepting the sixth line to the last line("name").slice(0,5)

# 1 ascending order, -1 descending order, background means to create when idle({name:1})
({name:-1},{background:true,name:"index_name"})

({sid:1},{background:true,unique:true})

()

()

mongodump --host=localhost --port=27017 -u admin -p abc123456 --authenticationDatabase=admin -o /data

# --dumpDbUsersAndRoles parameter can back up users affiliated with the logical librarymongodump --host=localhost --port=27017 -u admin -p abc123456 --authenticationDatabase=admin -d school -o /data

# --gzip compression backup, --oplog uses oplog for point-time snapshotsmongodump --host=localhost --port=27017 -u admin -p abc123456 --authenticationDatabase=admin -d school -c student -o /data
# Export data from JSON or CSV format data, -f specifies the output field, -q specifies the query statementmongoexport --host=localhost --port=27017 -u admin -p abc123456 --authenticationDatabase=admin -d school -c student -f "_id,name,sex,age" -o 

# --drop means to delete the collection in the database before importingmongorestore --host=localhost --port=27017 -u admin -p abc123456 --authenticationDatabase=admin --drop -d school /data/school

# --gzip decompression Gzip compressed archive restore, --oplogReplay operation content, --oplogLimit and --oplogReplay can be used together, and can be restricted to the specified time point.mongorestore --host=localhost --port=27017 -u admin -p abc123456 --authenticationDatabase=admin -d school -c student /data/school/
# Import json datamongoimport --host=localhost --port=27017 -u admin -p abc123456 --authenticationDatabase=admin -d school -c student --file 

# Use oplog parameters to be fully prepared, you need to enable the replica setmongodump --host=localhost --port=27017 -u admin -p abc123456 --authenticationDatabase=admin --oplog -o /data
# parse oplog file and find out the data of the last timebsondump /data/ > /data/
# Export incremental data, modify it to the time stamp of the most recent linemongodump --host=localhost --port=27017 -u admin -p abc123456 --authenticationDatabase=admin -d local -c  -q '{ts:{$gt:Timestamp(1610789118,416)}}' -o /data/oplog
# Restore full preparationmongorestore --host=localhost --port=27017 -u admin -p abc123456 --authenticationDatabase=admin --oplogReplay /data
# Copy the incremental oplog to the backup directory, rename it to overwrite the originalcp  /data/
# Restore incremental oplogs and specify the time point to restoremongorestore --host=localhost --port=27017 -u admin -p abc123456 --authenticationDatabase=admin --oplogReplay --oplogLimit "1610789168:1" /data