On this page本页内容
To list the databases that have sharding enabled, query the 要列出已启用分片的数据库,请查询databases
collection in the Config Database. config
数据库中的databases
集合。A database has sharding enabled if the value of the 如果partitioned
field is true
. partitioned
字段的值为true
,则数据库已启用分片。Connect 将mongosh
to a mongos
instance and run the following operation to get a full list of databases with sharding enabled:mongosh
连接到mongos
实例并运行以下操作,以获取启用了分片的数据库的完整列表:
use config db.databases.find( { "partitioned": true } )
You can use the following sequence of commands to return a list of all databases in the cluster:可以使用以下命令序列返回群集中所有数据库的列表:
use config db.databases.find()
If this returns the following result set:如果返回以下结果集:
{ "_id" : "test", "primary" : "shardB", "partitioned" : false } { "_id" : "animals", "primary" : "shardA", "partitioned" : true } { "_id" : "farms", "primary" : "shardA", "partitioned" : false }
Then sharding is only enabled for the 然后仅对animals
database.animals
数据库启用分片。
To list the current set of configured shards, use the 要列出当前配置的分片集,请使用listShards
command, as follows:listShards
命令,如下所示:
db.adminCommand( { listShards : 1 } )
To view cluster details, issue 要查看集群详细信息,请发出db.printShardingStatus()
or sh.status()
. db.printShardingStatus()
或sh.status()
。Both methods return the same output.这两种方法都返回相同的输出。
sh.status()
输出示例中sharding version
shards
mongod
instances used as shards in the cluster.mongod
实例的列表。databases
chunks
information for the foo
database displays how many chunks are on each shard and displays the range of each chunk.foo
数据库的chunks
信息显示每个分片上有多少块,并显示每个块的范围。--- Sharding Status --- sharding version: { "_id" : 1, "minCompatibleVersion" : 5, "currentVersion" : 6, "clusterId" : ObjectId("59a4443c3d38cd8a0b40316d") } shards: { "_id" : "shard0000", "host" : "m0.example.net:27018" } { "_id" : "shard0001", "host" : "m3.example2.net:27018" } { "_id" : "shard0002", "host" : "m2.example.net:27018" } active mongoses: "3.4.7" : 1 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: 1 : Success databases: { "_id" : "foo", "partitioned" : true, "primary" : "shard0000" } foo.contacts shard key: { "zip" : 1 } unique: false balancing: true chunks: shard0001 2 shard0002 3 shard0000 2 { "zip" : { "$minKey" : 1 } } -->> { "zip" : "56000" } on : shard0001 { "t" : 2, "i" : 0 } { "zip" : 56000 } -->> { "zip" : "56800" } on : shard0002 { "t" : 3, "i" : 4 } { "zip" : 56800 } -->> { "zip" : "57088" } on : shard0002 { "t" : 4, "i" : 2 } { "zip" : 57088 } -->> { "zip" : "57500" } on : shard0002 { "t" : 4, "i" : 3 } { "zip" : 57500 } -->> { "zip" : "58140" } on : shard0001 { "t" : 4, "i" : 0 } { "zip" : 58140 } -->> { "zip" : "59000" } on : shard0000 { "t" : 4, "i" : 1 } { "zip" : 59000 } -->> { "zip" : { "$maxKey" : 1 } } on : shard0000 { "t" : 3, "i" : 3 } { "_id" : "test", "partitioned" : false, "primary" : "shard0000" }