shards:
{ "_id" : "s0", "host" : "s0/localhost:37017,localhost:37018,localhost:37019" }
{ "_id" : "s1", "host" : "s1/localhost:47018,localhost:47019" }
{ "_id" : "s2", "host" : "s2/localhost:57017,localhost:57018,localhost:57019" }
active mongoses:
"3.2.5" : 1
现在,如果要将一个json导入到分片环境中,请按照以下步骤操作。
通过mongos连接到任意一个分片实例。 mongo --port 47018,这将使您进入mongos>提示符。
给出以下命令。
mongos> sh.enableSharding("sharddb"); { "ok" : 1 }
这个命令告诉MongoDB数据库"sharddb"可以进行分片。
> mongos> sh.shardCollection("sharddb.neighbourhoods",{"_id":1},true)
> {"collectionsharded" : "sharddb.neighbourhoods", "ok" : 1 }
一旦您指定了所有细节,请通过命令提示符执行以下mongoimport命令
> C:\Users\yc03ak1>mongoimport --db sharddb --collection
> "neighbourhoods" --drop --type json --host "localhost:47018" --file
> "c:\Users\yc03ak1\Desktop\neighborhoods.json"
> 2016-08-14T15:32:03.087-0700 connected to: localhost:47018
> 2016-08-14T15:32:03.091-0700 dropping: sharddb.neighbourhoods
> 2016-08-14T15:32:04.743-0700 imported 195 documents
这将在分片数据库中创建名为neighborhoods的集合,作为分片集合。
您可以通过以下方式检查分片集合:
mongos> sh.status();
--- Sharding Status ---
sharding version: {
"_id" : 1,
"minCompatibleVersion" : 5,
"currentVersion" : 6,
"clusterId" : ObjectId("57a8f3d77ce8ef0f68a210c9")
}
shards:
{ "_id" : "s0", "host" : "s0/localhost:37017,localhost:37018,localhost:37019" }
{ "_id" : "s1", "host" : "s1/localhost:47018,localhost:47019" }
{ "_id" : "s2", "host" : "s2/localhost:57017,localhost:57018,localhost:57019" }
active mongoses:
"3.2.5" : 1
balancer:
Currently enabled: yes
Currently running: no
Failed balancer rounds in last 5 attempts: 5
Last reported error: HostUnreachable
Time of Reported error: Thu Aug 11 2016 18:02:14 GMT-0700 (Pacific Standard Time)
Migration Results for the last 24 hours:
No recent migrations
databases:
{ "_id" : "projects", "primary" : "s1", "partitioned" : true }
projects.students
shard key: { "student_id" : 1 }
unique: false
balancing: true
chunks:
s0 1
s1 1
s2 1
{ "student_id" : { "$minKey" : 1 } } -->> { "student_id" : 1 } on : s2 Timestamp(3, 0)
{ "student_id" : 1 } -->> { "student_id" : 25 } on : s1 Timestamp(3, 1)
{ "student_id" : 25 } -->> { "student_id" : { "$maxKey" : 1 } } on : s0 Timestamp(2, 0)
{ "_id" : "test", "primary" : "s2", "partitioned" : true }
test.zipcodes
shard key: { "_id" : 1 }
unique: false
balancing: true
chunks:
s2 1
{ "_id" : { "$minKey" : 1 } } -->> { "_id" : { "$maxKey" : 1 } } on : s2 Timestamp(1, 0)
{ "_id" : "sharddb", "primary" : "s2", "partitioned" : true }
sharddb.neighbourhoods
shard key: { "_id" : 1 }
unique: true
balancing: true
chunks:
s2 1
{ "_id" : { "$minKey" : 1 } } -->> { "_id" : { "$maxKey" : 1 } } on : s2 Timestamp(1, 0)
mongos>
HTH..
mongos
实例,该实例从配置实例中读取信息以了解如何对您的集合进行分片,并且您必须通过--host
和适当的IP / DNS名称和端口将您的mongoimport
命令行指向此mongos
实例。 - DAXaholic