MongoDB Sharding 集群部署

一、configsvr 配置 （10.3.20.14:27017、10.3.20.51:27017、10.3.20.54:27017）

配置过程：以 10.3.20.14:27017 为例，其他两台类似

1、安装配置 mongodb

# wget https://mirrors.aliyun.com/mongodb/yum/redhat/6Server/mongodb-org/3.6/x86_64/RPMS/mongodb-org-3.6.6-1.el6.x86_64.rpm
# wget https://mirrors.aliyun.com/mongodb/yum/redhat/6Server/mongodb-org/3.6/x86_64/RPMS/mongodb-org-mongos-3.6.6-1.el6.x86_64.rpm
# wget https://mirrors.aliyun.com/mongodb/yum/redhat/6Server/mongodb-org/3.6/x86_64/RPMS/mongodb-org-server-3.6.6-1.el6.x86_64.rpm
# wget https://mirrors.aliyun.com/mongodb/yum/redhat/6Server/mongodb-org/3.6/x86_64/RPMS/mongodb-org-shell-3.6.6-1.el6.x86_64.rpm
# wget https://mirrors.aliyun.com/mongodb/yum/redhat/6Server/mongodb-org/3.6/x86_64/RPMS/mongodb-org-tools-3.6.6-1.el6.x86_64.rpm

# ls
mongodb-org-3.6.6-1.el6.x86_64.rpm         mongodb-org-server-3.6.6-1.el6.x86_64.rpm  mongodb-org-tools-3.6.6-1.el6.x86_64.rpm
mongodb-org-mongos-3.6.6-1.el6.x86_64.rpm  mongodb-org-shell-3.6.6-1.el6.x86_64.rpm

# rpm -ivh *
warning: mongodb-org-3.6.6-1.el6.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID 91fa4ad5: NOKEY
Preparing...                ########################################### [100%]
   1:mongodb-org-tools      ########################################### [ 20%]
   2:mongodb-org-shell      ########################################### [ 40%]
   3:mongodb-org-server     ########################################### [ 60%]
   4:mongodb-org-mongos     ########################################### [ 80%]
   5:mongodb-org            ########################################### [100%]
   
   
# egrep -v "^$|^#" /etc/mongod.conf 
systemLog:
  destination: file
  logAppend: true
  path: /var/log/mongodb/mongod.log
storage:
  dbPath: /var/lib/mongo
  journal:
    enabled: true
processManagement:
  fork: true  # fork and run in background
  pidFilePath: /var/run/mongodb/mongod.pid  # location of pidfile
  timeZoneInfo: /usr/share/zoneinfo
net:
  port: 27017
  bindIp: 127.0.0.1,10.3.20.14  # Listen to local interface only, comment to listen on all interfaces.

2、启动 mongodb

# /etc/init.d/mongod start
Starting mongod:                                           [  OK  ]
# ps -ef|grep mongod
mongod     4074      1 32 18:19 ?        00:00:01 /usr/bin/mongod -f /etc/mongod.conf
root       4098   1421  0 18:20 pts/0    00:00:00 grep mongod
# netstat -nltup|grep 4074
tcp        0      0 10.3.20.14:27017            0.0.0.0:*                   LISTEN      4074/mongod         
tcp        0      0 127.0.0.1:27017             0.0.0.0:*                   LISTEN      4074/mongod

3、mongodb 认证配置

# mongo
MongoDB shell version v3.6.6
connecting to: mongodb://127.0.0.1:27017
MongoDB server version: 3.6.6
Server has startup warnings: 
2018-07-16T18:28:34.139+0800 I STORAGE  [initandlisten] 
2018-07-16T18:28:34.139+0800 I STORAGE  [initandlisten] ** WARNING: Using the XFS filesystem is strongly recommended with the WiredTiger storage engine
2018-07-16T18:28:34.139+0800 I STORAGE  [initandlisten] **          See http://dochub.mongodb.org/core/prodnotes-filesystem
2018-07-16T18:28:35.074+0800 I CONTROL  [initandlisten] 
2018-07-16T18:28:35.074+0800 I CONTROL  [initandlisten] ** WARNING: Access control is not enabled for the database.
2018-07-16T18:28:35.074+0800 I CONTROL  [initandlisten] **          Read and write access to data and configuration is unrestricted.
2018-07-16T18:28:35.074+0800 I CONTROL  [initandlisten] 
> show databases
admin  0.000GB
local  0.000GB
> use admin
switched to db admin

// 创建超级用户
> db.createUser({user: 'root', pwd: '123456', roles: ['root']})
Successfully added user: { "user" : "root", "roles" : [ "root" ] }
> 

// 配置要认证才能登录（加上 security: authorization: 'enabled' 配置）
# egrep -v "^$|^#" /etc/mongod.conf 
systemLog:
  destination: file
  logAppend: true
  path: /var/log/mongodb/mongod.log
storage:
  dbPath: /var/lib/mongo
  journal:
    enabled: true
processManagement:
  fork: true  # fork and run in background
  pidFilePath: /var/run/mongodb/mongod.pid  # location of pidfile
  timeZoneInfo: /usr/share/zoneinfo
net:
  port: 27017
  bindIp: 127.0.0.1,10.3.20.14  # Listen to local interface only, comment to listen on all interfaces.
security:
  authorization: 'enabled'


# /etc/init.d/mongod restart

// 访问方式 1
# mongo -u root -p 123456 --authenticationDatabase admin
> show databases;
admin   0.000GB
config  0.000GB
local   0.000GB

4、配置 configsvr 复制集

配置集群 keyfile（3台机器用同一个key）

# openssl rand -base64 756 > mongo.key
# mv mongo.key /var/lib/mongo/
# chown mongod:mongod /var/lib/mongo/mongo.key
# chmod 600 /var/lib/mongo/mongo.key

# egrep -v "^#|^$" /etc/mongod.conf
systemLog:
  destination: file
  logAppend: true
  path: /var/log/mongodb/mongod.log
storage:
  dbPath: /var/lib/mongo
  journal:
    enabled: true
processManagement:
  fork: true  # fork and run in background
  pidFilePath: /var/run/mongodb/mongod.pid  # location of pidfile
  timeZoneInfo: /usr/share/zoneinfo
net:
  port: 27017
  bindIp: 127.0.0.1,10.3.20.14  # Listen to local interface only, comment to listen on all interfaces.
security:
  authorization: 'enabled'
  keyFile: /var/lib/mongo/mongo.key
replication:
  oplogSizeMB: 500
  replSetName: repdata
sharding:
  clusterRole: configsvr

# /etc/init.d/mongod restart

// 这步只需要在 10.3.20.14 操作，建立 configsvr 的复制集
# mongo -u root -p 123456 10.3.20.14/admin
>  cfg={ _id:"repdata", configsvr: true, members:[ {_id:0,host:'10.3.20.14:27017',priority:2}, {_id:1,host:'10.3.20.51:27017',priority:1}, {_id:2,host:'10.3.20.54:27017',priority:1}] }
> rs.initiate(cfg)

二、sharding01 配置 （10.3.20.102:27017、10.3.20.105:27017、10.3.20.132:27017）

1、安装 mongodb，参考 （一）的 1、2、3步骤

2、集群之间的 key，使用（一）的 4 步骤的 mongo.key

3、sharding01 复制集配置

# egrep -v "^$|^#" /etc/mongod.conf 
systemLog:
  destination: file
  logAppend: true
  path: /var/log/mongodb/mongod.log
storage:
  dbPath: /var/lib/mongo
  journal:
    enabled: true
processManagement:
  fork: true  # fork and run in background
  pidFilePath: /var/run/mongodb/mongod.pid  # location of pidfile
  timeZoneInfo: /usr/share/zoneinfo
net:
  port: 27017
  bindIp: 127.0.0.1,10.3.20.102  # Listen to local interface only, comment to listen on all interfaces.
security:
  authorization: 'enabled'
  keyFile: /var/lib/mongo/mongo.key
replication:
  replSetName: sharding01
sharding:
  clusterRole: shardsvr

# /etc/init.d/mongod restart

// 这步只需要在 10.3.20.102 操作，建立 sharding01 的复制集
# mongo -u root -p 123456 10.3.20.102/admin
MongoDB shell version v3.6.6
connecting to: mongodb://10.3.20.102:27017/admin
MongoDB server version: 3.6.6
Server has startup warnings: 
2018-07-18T15:16:32.731+0800 I CONTROL  [initandlisten] 
2018-07-18T15:16:32.731+0800 I CONTROL  [initandlisten] ** WARNING: /sys/kernel/mm/transparent_hugepage/defrag is 'always'.
2018-07-18T15:16:32.731+0800 I CONTROL  [initandlisten] **        We suggest setting it to 'never'
2018-07-18T15:16:32.731+0800 I CONTROL  [initandlisten] 
>  cfg={ _id:"sharding01", members:[ {_id:0,host:'10.3.20.102:27017',priority:2}, {_id:1,host:'10.3.20.105:27017',priority:1}, {_id:2,host:'10.3.20.132:27017',priority:1}] }
{
    "_id" : "sharding01",
    "members" : [
        {
            "_id" : 0,
            "host" : "10.3.20.102:27017",
            "priority" : 2
        },
        {
            "_id" : 1,
            "host" : "10.3.20.105:27017",
            "priority" : 1
        },
        {
            "_id" : 2,
            "host" : "10.3.20.132:27017",
            "priority" : 1
        }
    ]
}
> rs.initiate(cfg)
{ "ok" : 1 }

> rs.status()
{
    "set" : "sharding01",
    "date" : ISODate("2018-07-18T07:53:31.202Z"),
    "myState" : 1,
    "term" : NumberLong(1),
    "syncingTo" : "",
    "syncSourceHost" : "",
    "syncSourceId" : -1,
    "heartbeatIntervalMillis" : NumberLong(2000),
    "optimes" : {
        "lastCommittedOpTime" : {
            "ts" : Timestamp(1531900403, 1),
            "t" : NumberLong(1)
        },
        "readConcernMajorityOpTime" : {
            "ts" : Timestamp(1531900403, 1),
            "t" : NumberLong(1)
        },
        "appliedOpTime" : {
            "ts" : Timestamp(1531900403, 1),
            "t" : NumberLong(1)
        },
        "durableOpTime" : {
            "ts" : Timestamp(1531900403, 1),
            "t" : NumberLong(1)
        }
    },
    "members" : [
        {
            "_id" : 0,
            "name" : "10.3.20.102:27017",
            "health" : 1,
            "state" : 1,
            "stateStr" : "PRIMARY",
            "uptime" : 2223,
            "optime" : {
                "ts" : Timestamp(1531900403, 1),
                "t" : NumberLong(1)
            },
            "optimeDate" : ISODate("2018-07-18T07:53:23Z"),
            "syncingTo" : "",
            "syncSourceHost" : "",
            "syncSourceId" : -1,
            "infoMessage" : "",
            "electionTime" : Timestamp(1531899882, 1),
            "electionDate" : ISODate("2018-07-18T07:44:42Z"),
            "configVersion" : 1,
            "self" : true,
            "lastHeartbeatMessage" : ""
        },
        {
            "_id" : 1,
            "name" : "10.3.20.105:27017",
            "health" : 1,
            "state" : 2,
            "stateStr" : "SECONDARY",
            "uptime" : 539,
            "optime" : {
                "ts" : Timestamp(1531900403, 1),
                "t" : NumberLong(1)
            },
            "optimeDurable" : {
                "ts" : Timestamp(1531900403, 1),
                "t" : NumberLong(1)
            },
            "optimeDate" : ISODate("2018-07-18T07:53:23Z"),
            "optimeDurableDate" : ISODate("2018-07-18T07:53:23Z"),
            "lastHeartbeat" : ISODate("2018-07-18T07:53:30.991Z"),
            "lastHeartbeatRecv" : ISODate("2018-07-18T07:53:31.120Z"),
            "pingMs" : NumberLong(0),
            "lastHeartbeatMessage" : "",
            "syncingTo" : "10.3.20.102:27017",
            "syncSourceHost" : "10.3.20.102:27017",
            "syncSourceId" : 0,
            "infoMessage" : "",
            "configVersion" : 1
        },
        {
            "_id" : 2,
            "name" : "10.3.20.132:27017",
            "health" : 1,
            "state" : 2,
            "stateStr" : "SECONDARY",
            "uptime" : 539,
            "optime" : {
                "ts" : Timestamp(1531900403, 1),
                "t" : NumberLong(1)
            },
            "optimeDurable" : {
                "ts" : Timestamp(1531900403, 1),
                "t" : NumberLong(1)
            },
            "optimeDate" : ISODate("2018-07-18T07:53:23Z"),
            "optimeDurableDate" : ISODate("2018-07-18T07:53:23Z"),
            "lastHeartbeat" : ISODate("2018-07-18T07:53:31.035Z"),
            "lastHeartbeatRecv" : ISODate("2018-07-18T07:53:29.620Z"),
            "pingMs" : NumberLong(0),
            "lastHeartbeatMessage" : "",
            "syncingTo" : "10.3.20.102:27017",
            "syncSourceHost" : "10.3.20.102:27017",
            "syncSourceId" : 0,
            "infoMessage" : "",
            "configVersion" : 1
        }
    ],
    "ok" : 1
}

三、sharding02 配置 （10.3.20.141:27017、10.3.20.142:27017、10.3.20.143:27017）

1、安装 mongodb，参考 （一）的 1、2、3步骤

2、集群之间的 key，使用（一）的 4 步骤的 mongo.key

3、sharding02 复制集配置

# egrep -v "^$|^#" /etc/mongod.conf 
systemLog:
  destination: file
  logAppend: true
  path: /var/log/mongodb/mongod.log
storage:
  dbPath: /var/lib/mongo
  journal:
    enabled: true
processManagement:
  fork: true  # fork and run in background
  pidFilePath: /var/run/mongodb/mongod.pid  # location of pidfile
  timeZoneInfo: /usr/share/zoneinfo
net:
  port: 27017
  bindIp: 127.0.0.1,10.3.20.141  # Listen to local interface only, comment to listen on all interfaces.
security:
  authorization: 'enabled'
  keyFile: /var/lib/mongo/mongo.key
replication:
  replSetName: sharding02
sharding:
  clusterRole: shardsvr

# /etc/init.d/mongod restart

// 这步只需要在 10.3.20.141 操作，建立 sharding02 的复制集  
# mongo -u root -p 123456 10.3.20.141/admin
cfg={ _id:"sharding02", members:[ {_id:0,host:'10.3.20.141:27017',priority:2}, {_id:1,host:'10.3.20.142:27017',priority:1}, {_id:2,host:'10.3.20.143:27017',priority:1}] }
{
    "_id" : "sharding02",
    "members" : [
        {
            "_id" : 0,
            "host" : "10.3.20.141:27017",
            "priority" : 2
        },
        {
            "_id" : 1,
            "host" : "10.3.20.142:27017",
            "priority" : 1
        },
        {
            "_id" : 2,
            "host" : "10.3.20.143:27017",
            "priority" : 1
        }
    ]
}
> rs.initiate(cfg)
{ "ok" : 1 }

> rs.status()
{
    "set" : "sharding02",
    "date" : ISODate("2018-07-18T08:23:04.320Z"),
    "myState" : 2,
    "term" : NumberLong(0),
    "syncingTo" : "",
    "syncSourceHost" : "",
    "syncSourceId" : -1,
    "heartbeatIntervalMillis" : NumberLong(2000),
    "optimes" : {
        "lastCommittedOpTime" : {
            "ts" : Timestamp(0, 0),
            "t" : NumberLong(-1)
        },
        "appliedOpTime" : {
            "ts" : Timestamp(1531902177, 1),
            "t" : NumberLong(-1)
        },
        "durableOpTime" : {
            "ts" : Timestamp(1531902177, 1),
            "t" : NumberLong(-1)
        }
    },
    "members" : [
        {
            "_id" : 0,
            "name" : "10.3.20.141:27017",
            "health" : 1,
            "state" : 2,
            "stateStr" : "SECONDARY",
            "uptime" : 133,
            "optime" : {
                "ts" : Timestamp(1531902177, 1),
                "t" : NumberLong(-1)
            },
            "optimeDate" : ISODate("2018-07-18T08:22:57Z"),
            "syncingTo" : "",
            "syncSourceHost" : "",
            "syncSourceId" : -1,
            "infoMessage" : "could not find member to sync from",
            "configVersion" : 1,
            "self" : true,
            "lastHeartbeatMessage" : ""
        },
        {
            "_id" : 1,
            "name" : "10.3.20.142:27017",
            "health" : 1,
            "state" : 2,
            "stateStr" : "SECONDARY",
            "uptime" : 6,
            "optime" : {
                "ts" : Timestamp(1531902177, 1),
                "t" : NumberLong(-1)
            },
            "optimeDurable" : {
                "ts" : Timestamp(1531902177, 1),
                "t" : NumberLong(-1)
            },
            "optimeDate" : ISODate("2018-07-18T08:22:57Z"),
            "optimeDurableDate" : ISODate("2018-07-18T08:22:57Z"),
            "lastHeartbeat" : ISODate("2018-07-18T08:23:03.949Z"),
            "lastHeartbeatRecv" : ISODate("2018-07-18T08:23:04.102Z"),
            "pingMs" : NumberLong(0),
            "lastHeartbeatMessage" : "",
            "syncingTo" : "",
            "syncSourceHost" : "",
            "syncSourceId" : -1,
            "infoMessage" : "",
            "configVersion" : 1
        },
        {
            "_id" : 2,
            "name" : "10.3.20.143:27017",
            "health" : 1,
            "state" : 2,
            "stateStr" : "SECONDARY",
            "uptime" : 6,
            "optime" : {
                "ts" : Timestamp(1531902177, 1),
                "t" : NumberLong(-1)
            },
            "optimeDurable" : {
                "ts" : Timestamp(1531902177, 1),
                "t" : NumberLong(-1)
            },
            "optimeDate" : ISODate("2018-07-18T08:22:57Z"),
            "optimeDurableDate" : ISODate("2018-07-18T08:22:57Z"),
            "lastHeartbeat" : ISODate("2018-07-18T08:23:03.949Z"),
            "lastHeartbeatRecv" : ISODate("2018-07-18T08:23:04.103Z"),
            "pingMs" : NumberLong(0),
            "lastHeartbeatMessage" : "",
            "syncingTo" : "",
            "syncSourceHost" : "",
            "syncSourceId" : -1,
            "infoMessage" : "",
            "configVersion" : 1
        }
    ],
    "ok" : 1
}

四、mongos 配置 （10.3.20.14:27018、10.3.20.51:27018、10.3.20.54:27018）

1、安装 mongodb，参考 （一）的 1、2、3步骤

2、集群之间的 key，使用（一）的 4 步骤的 mongo.key

3、mongos 配置

# egrep -v "^$|^#" /etc/mongos.conf 
systemLog:
  destination: file
  path: /var/log/mongodb/mongos.log
  logAppend: true
processManagement:
  fork: true
  pidFilePath: /var/run/mongodb/mongos.pid
net:
  bindIp: 127.0.0.1,10.3.20.14
  port: 27018
security:
  keyFile: /var/lib/mongo/mongo.key
sharding:
  configDB: repdata/10.3.20.14:27017,10.3.20.51:27017,10.3.20.54:27017

# mongos -f /etc/mongos.conf

# mongo --host 10.3.20.14 --port 27018
mongos> use admin
// 这里用的是哪个集群（configsvr、sharding01、sharding02）的认证？
mongos> db.auth('root','123456')
1
mongos> sh.addShard("sharding01/10.3.20.102:27017,10.3.20.105:27017,10.3.20.132:27017")
{
    "shardAdded" : "sharding01",
    "ok" : 1,
    "$clusterTime" : {
        "clusterTime" : Timestamp(1531904052, 8),
        "signature" : {
            "hash" : BinData(0,"3jHS/99+ya4pASBp7Pm0JNOBMX8="),
            "keyId" : NumberLong("6579439166424088595")
        }
    },
    "operationTime" : Timestamp(1531904052, 8)
}
mongos> sh.addShard("sharding02/10.3.20.141:27017,10.3.20.142:27017,10.3.20.143:27017")
{
    "shardAdded" : "sharding02",
    "ok" : 1,
    "$clusterTime" : {
        "clusterTime" : Timestamp(1531904104, 4),
        "signature" : {
            "hash" : BinData(0,"XiVKlJFOagVCUpd1C/coLrjG2JY="),
            "keyId" : NumberLong("6579439166424088595")
        }
    },
    "operationTime" : Timestamp(1531904104, 2)
}
mongos> sh.status()
--- Sharding Status --- 
  sharding version: {
    "_id" : 1,
    "minCompatibleVersion" : 5,
    "currentVersion" : 6,
    "clusterId" : ObjectId("5b4edd10f9eb70d9ba075cb4")
  }
  shards:
        {  "_id" : "sharding01",  "host" : "sharding01/10.3.20.102:27017,10.3.20.105:27017,10.3.20.132:27017",  "state" : 1 }
        {  "_id" : "sharding02",  "host" : "sharding02/10.3.20.141:27017,10.3.20.142:27017,10.3.20.143:27017",  "state" : 1 }
  active mongoses:
        "3.6.6" : 3
  autosplit:
        Currently enabled: yes
  balancer:
        Currently enabled:  yes
        Currently running:  no
        Failed balancer rounds in last 5 attempts:  0
        Migration Results for the last 24 hours: 
                No recent migrations
  databases:
        {  "_id" : "config",  "primary" : "config",  "partitioned" : true }

五、sharding 集群测试

# mongo --host 10.3.20.14 --port 27018
MongoDB shell version v3.6.6
connecting to: mongodb://10.3.20.14:27018/
MongoDB server version: 3.6.6
mongos> show dbs
2018-07-18T17:40:02.938+0800 E QUERY    [thread1] Error: listDatabases failed:{
    "ok" : 0,
    "errmsg" : "not authorized on admin to execute command { listDatabases: 1.0, $clusterTime: { clusterTime: Timestamp(1531906797, 2), signature: { hash: BinData(0, 6FCC8A5814C82C67692A8AE43619C749DAD936D2), keyId: 6579439166424088595 } }, $db: \"admin\" }",
    "code" : 13,
    "codeName" : "Unauthorized",
    "$clusterTime" : {
        "clusterTime" : Timestamp(1531906797, 2),
        "signature" : {
            "hash" : BinData(0,"b8yKWBTILGdpKorkNhnHSdrZNtI="),
            "keyId" : NumberLong("6579439166424088595")
        }
    },
    "operationTime" : Timestamp(1531906797, 2)
} :
_getErrorWithCode@src/mongo/shell/utils.js:25:13
Mongo.prototype.getDBs@src/mongo/shell/mongo.js:65:1
shellHelper.show@src/mongo/shell/utils.js:849:19
shellHelper@src/mongo/shell/utils.js:739:15
@(shellhelp2):1:1
mongos> use admin
switched to db admin
mongos> db.auth('root','123456')
1
mongos> show dbs
admin   0.000GB
config  0.001GB
testdb  0.000GB

mongos> db.runCommand({enablesharding: "testdb"})
{
    "ok" : 1,
    "$clusterTime" : {
        "clusterTime" : Timestamp(1531904238, 9),
        "signature" : {
            "hash" : BinData(0,"vKr+hcrTWpHzUwTqvJJzV8OOFNs="),
            "keyId" : NumberLong("6579439166424088595")
        }
    },
    "operationTime" : Timestamp(1531904238, 9)
}
mongos> db.runCommand({shardcollection: "testdb.table1", key: {id: 1}})
{
    "collectionsharded" : "testdb.table1",
    "collectionUUID" : UUID("baec305a-3609-4a41-87dc-36c60dd840ae"),
    "ok" : 1,
    "$clusterTime" : {
        "clusterTime" : Timestamp(1531904291, 14),
        "signature" : {
            "hash" : BinData(0,"DgOlbRTK1vRlmPYaimfbYLB8GtU="),
            "keyId" : NumberLong("6579439166424088595")
        }
    },
    "operationTime" : Timestamp(1531904291, 14)
}

mongos> db.runCommand({"enablesharding" : "shardb"})
{
    "ok" : 1,
    "$clusterTime" : {
        "clusterTime" : Timestamp(1531907043, 6),
        "signature" : {
            "hash" : BinData(0,"fz2aCI/h/mej6FJptpndtZzb8FY="),
            "keyId" : NumberLong("6579439166424088595")
        }
    },
    "operationTime" : Timestamp(1531907043, 6)
}
mongos> db.runCommand({"shardcollection" : "shardb.coll",key : {_id: 1}})
{
    "collectionsharded" : "shardb.coll",
    "collectionUUID" : UUID("5a377dde-a98e-4362-95af-8f01d076c5bf"),
    "ok" : 1,
    "$clusterTime" : {
        "clusterTime" : Timestamp(1531907053, 13),
        "signature" : {
            "hash" : BinData(0,"/CyVOPY7x8ZkvlR/6rc+jJ7YetY="),
            "keyId" : NumberLong("6579439166424088595")
        }
    },
    "operationTime" : Timestamp(1531907053, 13)
}

mongos> for(var i=0;i<10000;i++){db.coll.insert({_id:i+1,content:'test'+i})}
WriteResult({ "nInserted" : 1 })
mongos> sh.status()
--- Sharding Status --- 
  sharding version: {
    "_id" : 1,
    "minCompatibleVersion" : 5,
    "currentVersion" : 6,
    "clusterId" : ObjectId("5b4edd10f9eb70d9ba075cb4")
  }
  shards:
        {  "_id" : "sharding01",  "host" : "sharding01/10.3.20.102:27017,10.3.20.105:27017,10.3.20.132:27017",  "state" : 1 }
        {  "_id" : "sharding02",  "host" : "sharding02/10.3.20.141:27017,10.3.20.142:27017,10.3.20.143:27017",  "state" : 1 }
  active mongoses:
        "3.6.6" : 3
  autosplit:
        Currently enabled: yes
  balancer:
        Currently enabled:  yes
        Currently running:  no
        Failed balancer rounds in last 5 attempts:  0
        Migration Results for the last 24 hours: 
                No recent migrations
  databases:
        {  "_id" : "config",  "primary" : "config",  "partitioned" : true }
                config.system.sessions
                        shard key: { "_id" : 1 }
                        unique: false
                        balancing: true
                        chunks:
                                sharding01  1
                        { "_id" : { "$minKey" : 1 } } -->> { "_id" : { "$maxKey" : 1 } } on : sharding01 Timestamp(1, 0) 
        {  "_id" : "shardb",  "primary" : "sharding01",  "partitioned" : true }
                shardb.coll
                        shard key: { "_id" : 1 }
                        unique: false
                        balancing: true
                        chunks:
                                sharding01  1
                        { "_id" : { "$minKey" : 1 } } -->> { "_id" : { "$maxKey" : 1 } } on : sharding01 Timestamp(1, 0) 
        {  "_id" : "testdb",  "primary" : "sharding02",  "partitioned" : true }
                testdb.table1
                        shard key: { "id" : 1 }
                        unique: false
                        balancing: true
                        chunks:
                                sharding02  1
                        { "id" : { "$minKey" : 1 } } -->> { "id" : { "$maxKey" : 1 } } on : sharding02 Timestamp(1, 0) 


mongos> for(var i=0;i<10000;i++){db.table1.insert({_id:i+1,content:'test'+i})}
WriteResult({ "nInserted" : 1 })
mongos> sh.status()
--- Sharding Status --- 
  sharding version: {
    "_id" : 1,
    "minCompatibleVersion" : 5,
    "currentVersion" : 6,
    "clusterId" : ObjectId("5b4edd10f9eb70d9ba075cb4")
  }
  shards:
        {  "_id" : "sharding01",  "host" : "sharding01/10.3.20.102:27017,10.3.20.105:27017,10.3.20.132:27017",  "state" : 1 }
        {  "_id" : "sharding02",  "host" : "sharding02/10.3.20.141:27017,10.3.20.142:27017,10.3.20.143:27017",  "state" : 1 }
  active mongoses:
        "3.6.6" : 3
  autosplit:
        Currently enabled: yes
  balancer:
        Currently enabled:  yes
        Currently running:  no
        Failed balancer rounds in last 5 attempts:  0
        Migration Results for the last 24 hours: 
                No recent migrations
  databases:
        {  "_id" : "config",  "primary" : "config",  "partitioned" : true }
                config.system.sessions
                        shard key: { "_id" : 1 }
                        unique: false
                        balancing: true
                        chunks:
                                sharding01  1
                        { "_id" : { "$minKey" : 1 } } -->> { "_id" : { "$maxKey" : 1 } } on : sharding01 Timestamp(1, 0) 
        {  "_id" : "shardb",  "primary" : "sharding01",  "partitioned" : true }
                shardb.coll
                        shard key: { "_id" : 1 }
                        unique: false
                        balancing: true
                        chunks:
                                sharding01  1
                        { "_id" : { "$minKey" : 1 } } -->> { "_id" : { "$maxKey" : 1 } } on : sharding01 Timestamp(1, 0) 
        {  "_id" : "testdb",  "primary" : "sharding02",  "partitioned" : true }
                testdb.table1
                        shard key: { "id" : 1 }
                        unique: false
                        balancing: true
                        chunks:
                                sharding02  1
                        { "id" : { "$minKey" : 1 } } -->> { "id" : { "$maxKey" : 1 } } on : sharding02 Timestamp(1, 0)
最后编辑于 ：
©著作权归作者所有,转载或内容合作请联系作者
  • 人面猴
    序言：七十年代末，一起剥皮案震惊了整个滨河市，随后出现的几起案子，更是在滨河造成了极大的恐慌，老刑警刘岩，带你破解...
    沈念sama阅读 206,968评论 6赞 482
  • 死咒
    序言：滨河连续发生了三起死亡事件，死亡现场离奇诡异，居然都是意外死亡，警方通过查阅死者的电脑和手机，发现死者居然都...
    沈念sama阅读 88,601评论 2赞 382
  • 救了他两次的神仙让他今天三更去死
    文/潘晓璐 我一进店门，熙熙楼的掌柜王于贵愁眉苦脸地迎上来，“玉大人，你说我怎么就摊上这事。” “怎么了？”我有些...
    开封第一讲书人阅读 153,220评论 0赞 344
  • 道士缉凶录：失踪的卖姜人
    文/不坏的土叔 我叫张陵，是天一观的道长。 经常有香客问我，道长，这世上最难降的妖魔是什么？ 我笑而不...
    开封第一讲书人阅读 55,416评论 1赞 279
  • 港岛之恋（遗憾婚礼）
    正文 为了忘掉前任，我火速办了婚礼，结果婚礼上，老公的妹妹穿的比我还像新娘。我一直安慰自己，他们只是感情好，可当我...
    茶点故事阅读 64,425评论 5赞 374
  • 恶毒庶女顶嫁案：这布局不是一般人想出来的
    文/花漫 我一把揭开白布。 她就那样静静地躺着，像睡着了一般。 火红的嫁衣衬着肌肤如雪。 梳的纹丝不乱的头发上，一...
    开封第一讲书人阅读 49,144评论 1赞 285
  • 城市分裂传说
    那天，我揣着相机与录音，去河边找鬼。 笑死，一个胖子当着我的面吹牛，可吹牛的内容都是我干的。 我是一名探鬼主播，决...
    沈念sama阅读 38,432评论 3赞 401
  • 双鸳鸯连环套：你想象不到人心有多黑
    文/苍兰香墨 我猛地睁开眼，长吁一口气：“原来是场噩梦啊……” “哼！你这毒妇竟也来了？” 一声冷哼从身侧响起，我...
    开封第一讲书人阅读 37,088评论 0赞 261
  • 万荣杀人案实录
    序言：老挝万荣一对情侣失踪，失踪者是张志新（化名）和其女友刘颖，没想到半个月后，有当地人在树林里发现了一具尸体，经...
    沈念sama阅读 43,586评论 1赞 300
  • 护林员之死
    正文 独居荒郊野岭守林人离奇死亡，尸身上长有42处带血的脓包…… 初始之章·张勋 以下内容为张勋视角 年9月15日...
    茶点故事阅读 36,028评论 2赞 325
  • 白月光启示录
    正文 我和宋清朗相恋三年，在试婚纱的时候发现自己被绿了。 大学时的朋友给我发了我未婚夫和他白月光在一起吃饭的照片。...
    茶点故事阅读 38,137评论 1赞 334
  • 活死人
    序言：一个原本活蹦乱跳的男人离奇死亡，死状恐怖，灵堂内的尸体忽然破棺而出，到底是诈尸还是另有隐情，我是刑警宁泽，带...
    沈念sama阅读 33,783评论 4赞 324
  • 日本核电站爆炸内幕
    正文 年R本政府宣布，位于F岛的核电站，受9级特大地震影响，放射性物质发生泄漏。R本人自食恶果不足惜，却给世界环境...
    茶点故事阅读 39,343评论 3赞 307
  • 男人毒药：我在死后第九天来索命
    文/蒙蒙 一、第九天 我趴在偏房一处隐蔽的房顶上张望。 院中可真热闹，春花似锦、人声如沸。这庄子的主人今日做“春日...
    开封第一讲书人阅读 30,333评论 0赞 19
  • 一桩弑父案，背后竟有这般阴谋
    文/苍兰香墨 我抬头看了看天上的太阳。三九已至，却和暖如春，着一层夹袄步出监牢的瞬间，已是汗流浃背。 一阵脚步声响...
    开封第一讲书人阅读 31,559评论 1赞 262
  • 情欲美人皮
    我被黑心中介骗来泰国打工， 没想到刚下飞机就差点儿被人妖公主榨干…… 1. 我叫王不留，地道东北人。 一个月前我还...
    沈念sama阅读 45,595评论 2赞 355
  • 代替公主和亲
    正文 我出身青楼，却偏偏与公主长得像，于是被迫代替她去往敌国和亲。 传闻我的和亲对象是个残疾皇子，可洞房花烛夜当晚...
    茶点故事阅读 42,901评论 2赞 345

推荐阅读更多精彩内容