一:写入测试数据
db.conf.insert({
"_id" : "sushardA",
"version" : 14,
"protocolVersion" : NumberLong(1),
"members" : [
{
"_id" : 1,
"host" : "172.20.0.132:27017",
"arbiterOnly" : false,
"buildIndexes" : true,
"hidden" : false,
"priority" : 70,
"tags" : {
"vpc" : "bj"
},
"slaveDelay" : NumberLong(0),
"votes" : 1
},
{
"_id" : 2,
"host" : "172.20.9.93:27017",
"arbiterOnly" : false,
"buildIndexes" : true,
"hidden" : false,
"priority" : 50,
"tags" : {
"vpc" : "bj"
},
"slaveDelay" : NumberLong(0),
"votes" : 1
},
{
"_id" : 3,
"host" : "172.20.8.48:27017",
"arbiterOnly" : false,
"buildIndexes" : true,
"hidden" : false,
"priority" : 30,
"tags" : {
"vpc" : "bj"
},
"slaveDelay" : NumberLong(0),
"votes" : 1
},
{
"_id" : 4,
"host" : "172.20.9.94:27017",
"arbiterOnly" : false,
"buildIndexes" : true,
"hidden" : false,
"priority" : 0,
"tags" : {
"vpc" : "hidden"
},
"slaveDelay" : NumberLong(0),
"votes" : 1
},
{
"_id" : 5,
"host" : "172.20.5.69:27017",
"arbiterOnly" : false,
"buildIndexes" : true,
"hidden" : true,
"priority" : 0,
"tags" : {
"vpc" : "bj"
},
"slaveDelay" : NumberLong(86400),
"votes" : 1
},
{
"_id" : 6,
"host" : "172.30.10.23:27017",
"arbiterOnly" : false,
"buildIndexes" : true,
"hidden" : false,
"priority" : 0,
"tags" : {
"vpc" : "bjtx"
},
"slaveDelay" : NumberLong(0),
"votes" : 0
},
{
"_id" : 7,
"host" : "172.30.10.143:27017",
"arbiterOnly" : false,
"buildIndexes" : true,
"hidden" : false,
"priority" : 0,
"tags" : {
"vpc" : "bjtx"
},
"slaveDelay" : NumberLong(0),
"votes" : 0
},
{
"_id" : 8,
"host" : "172.30.0.58:27017",
"arbiterOnly" : false,
"buildIndexes" : true,
"hidden" : false,
"priority" : 0,
"tags" : {
"vpc" : "bjtx"
},
"slaveDelay" : NumberLong(0),
"votes" : 0
},
{
"_id" : 9,
"host" : "172.30.0.85:27017",
"arbiterOnly" : false,
"buildIndexes" : true,
"hidden" : false,
"priority" : 10,
"tags" : {
"vpc" : "bjtx"
},
"slaveDelay" : NumberLong(0),
"votes" : 1
}
],
"settings" : {
"chainingAllowed" : true,
"heartbeatIntervalMillis" : 2000,
"heartbeatTimeoutSecs" : 10,
"electionTimeoutMillis" : 10000,
"catchUpTimeoutMillis" : -1,
"catchUpTakeoverDelayMillis" : 30000,
"getLastErrorModes" : {
},
"getLastErrorDefaults" : {
"w" : 1,
"wtimeout" : 0
},
"replicaSetId" : ObjectId("5cf0ead69212443417490592")
}
})
二:执行删除
db.conf.update({},{$pull:{members :{host: /172.20/}}})
参考:https://cloud.tencent.com/developer/article/1183393
更新数组中like"172.30.10"的vote字段
方法1.
db.conf.update({}, {$set: {"members.$[i].votes": 2}}, {arrayFilters: [{"i.host": /172.30.10/}]})
方法2.
db.conf.find({"members.host": /172.30.10/}).forEach(function(host) {
host.members.forEach(function(arr, index) {
mh=host.members[index].host
db.conf.update({"members.host": mh},{"$set": {"members.$.votes": 1,"members.$.priority": 99}})
});
})
方法3.
['172.30.10.23:27017','172.30.10.143:27017','172.30.0.58:27017',"172.30.0.85:27017"].forEach(function(host){db.conf.update({"members.host": host},{"$set": {"members.$.votes": 1,"members.$.priority": 99}})})
参考:https://jira.mongodb.org/browse/SERVER-1243
验证简单查询数组字段:
db.conf.find({"members.host": /172.30/})