开发者

How to change the shard key

I Know that impo开发者_如何学Gossible to change shard key. But, when I set incorrect shard key, How to change that?


dump the collection you sharded.. import it again.. set the new shard key.


dump collection

mongodump --host <hostname> --port <port> --collection <collection_name> --db <db_name>

open mongos and drop database or collection(If you had more than 1 collection)

mongo --host <hostname> --port <port>
show dbs
use <db_name>
db.dropDatabase() //it's only if you hade ONE database in db
exit

import database

mongorestore --host <hostname> --port <port> --collection <collection_name> --db <db_name> <path to <collection_name>.bson>

open mongos and shard

mongo --host <hostname> --port <port>
sh.status() (only to understand what is happen)
sh.enableSharding("<db_name>")
sh.shardCollection("<db_name>.<collection_name>",<shard key>,<option>)

something like that p.s. You must had index in collection for shard key. Search: "ensureIndex()"


Thank you for your process

I'm working with MongoDB 3.0 and :

  1. mongoimport is not the tool to import db dumped with mongodump.
  2. It is mongorestore which work fine with exactly the same arguments

Regards


It is very simple, use remove + insert instead of update.

var buf = db.col.findOne({'_id': ObjectId(<id>)});
buf['key'] = 'new key';
db.col.remove({'_id': ObjectId(<id>)});
db.col.insert(buf); //_id does not change!
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜