mongodb 数据备份和恢复
mongodb 可以导出bson 和 json 两种格式的备份。bson为数据存储格式 less space but not readable
点击查看代码
mongodump --uri "mongodb+srv://<your username>:<your password>@<your cluster>.mongodb.net/sample_supplies"
mongoexport --uri="mongodb+srv://<your username>:<your password>@<your cluster>.mongodb.net/sample_supplies" --collection=sales --out=sales.json
mongorestore --uri "mongodb+srv://<your username>:<your password>@<your cluster>.mongodb.net/sample_supplies" --drop dump
mongoimport --uri="mongodb+srv://<your username>:<your password>@<your cluster>.mongodb.net/sample_supplies" --drop sales.json
mongodb CRUD 不擅长
mongodb index 相关
创建索引会阻塞读写 注意使用"background" : true
点击查看代码
background 过程中可以通过
db.currentOp() 来查看进度
{
"desc" : "conn7805468",
"threadId" : "140603841742592",
"connectionId" : 7805468,
"client" : "10.111.146.226:59984",
"appName" : "MongoDB Shell",
"clientMetadata" : {
"application" : {
"name" : "MongoDB Shell"
},
"driver" : {
"name" : "MongoDB Internal Client",
"version" : "3.4.20"
},
"os" : {
"type" : "Linux",
"name" : "CentOS Linux release 7.6.1810 (Core) ",
"architecture" : "x86_64",
"version" : "Kernel 3.10.0-957.21.3.el7.x86_64"
}
},
"active" : true,
"opid" : 2136890871,
"secs_running" : 0,
"microsecs_running" : NumberLong(32),
"op" : "command",
"ns" : "admin.$cmd",
"query" : {
"currentOp" : 1
},
"numYields" : 0,
"locks" : {
},
"waitingForLock" : false,
"lockStats" : {
}
},
{
"desc" : "conn7805467",
"threadId" : "140603939641088",
"connectionId" : 7805467,
"client" : "10.111.146.226:59944",
"appName" : "MongoDB Shell",
"clientMetadata" : {
"application" : {
"name" : "MongoDB Shell"
},
"driver" : {
"name" : "MongoDB Internal Client",
"version" : "3.4.20"
},
"os" : {
"type" : "Linux",
"name" : "CentOS Linux release 7.6.1810 (Core) ",
"architecture" : "x86_64",
"version" : "Kernel 3.10.0-957.21.3.el7.x86_64"
}
},
"active" : true,
"opid" : 2136753025,
"secs_running" : 124,
"microsecs_running" : NumberLong(124927372),
"op" : "command",
"ns" : "kidappoint.$cmd",
"query" : {
"createIndexes" : "kidappoint_log",
"indexes" : [
{
"key" : {
"stamp" : -1
},
"name" : "stamp_-1",
"background" : true
}
]
},
"msg" : "Index Build (background) Index Build (background): 31647928/37672663 84%",
"progress" : {
"done" : 31647929,
"total" : 37672663
},
"numYields" : 248108,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w"
},
"waitingForLock" : false,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(248109),
"w" : NumberLong(248109)
}
},
"Database" : {
"acquireCount" : {
"w" : NumberLong(248109),
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"w" : NumberLong(3)
},
"timeAcquiringMicros" : {
"w" : NumberLong(405)
}
},
"Collection" : {
"acquireCount" : {
"w" : NumberLong(248109)
}
}
}
},