MongoDB 是一个基于分布式文件存储的数据库。由 C++ 语言编写。旨在为 WEB 应用提供可扩展的高性能数据存储解决方案。
MongoDB 是一个介于关系数据库和非关系数据库之间的产品,是非关系数据库当中功能最丰富,最像关系数据库的。
一、如何移除分片
1、确认balancer已经开启
mongos> sh.getBalancerState()
true
2、移除分片
注:在admin db下执行命令。
mongos> use admin switched to db admin mongos> db.runCommand( { removeShard: "shard3" } ) { "msg" : "draining started successfully", "state" : "started", "shard" : "shard3", "ok" : 1 }
3、检查迁移的状态
同样执行
mongos> use admin switched to db admin mongos> db.runCommand( { removeShard: "shard3" } ) { "msg" : "draining ongoing", "state" : "ongoing", "remaining" : { "chunks" : NumberLong(3), "dbs" : NumberLong(0) }, "ok" : 1 }
remaining中的chunks表示还有多少数据块未迁移。
4、移除未分片数据
In a cluster, a database with unsharded collections stores those collections only on a single shard.
That shard becomes the primary shard for that database. (Different databases in a cluster can have different primary shards.)
WARNING
Do not perform this procedure until you have finished draining the shard.
1)To determine if the shard you are removing is the primary shard for any of the cluster's databases, issue one of the following methods:
sh.status()
db.printShardingStatus()
In the resulting document, the databases field lists each database and its primary shard.
For example, the following database field shows that the products database uses mongodb0 as the primary shard:
{ "_id" : "products", "partitioned" : true, "primary" : "mongodb0" }
2)To move a database to another shard, use the movePrimary command. For example, to migrate all remaining unsharded data from mongodb0 to mongodb1,
issue the following command:
use admin
db.runCommand( { movePrimary: "products", to: "mongodb1" }) --products为db name
This command does not return until MongoDB completes moving all data, which may take a long time.
The response from this command will resemble the following:
{ "primary" : "mongodb1", "ok" : 1 }
If you use the movePrimary command to move un-sharded collections, you must either restart all mongos instances,
or use the flushRouterConfig command on all mongos instances before writing any data to the cluster.
This action notifies the mongos of the new shard for the database.
If you do not update the mongos instances' metadata cache after using movePrimary, the mongos may not write data to the correct shard.
To recover, you must manually intervene.
根据上面所说,迁移非分片表 时 最好停机,在运行db.runCommand( { movePrimary: "products", to: "mongodb1" }) 命令完成之后,刷新所有mongos后(所有mongos上运行db.runCommand("flushRouterConfig")),再对外提供服务。当然也可以重新启动所有mongos实例 。
5、完成迁移
mongos> use admin switched to db admin mongos> db.runCommand( { removeShard: "shard3" } ) { "msg" : "removeshard completed successfully", "state" : "completed", "shard" : "shard3", "ok" : 1 }
如果state为 completed,表示已完成迁移。
二、添加分片
1、首先确认balancer已经开启
mongos> sh.getBalancerState()
true
2、执行添加分片的命令
如果出现以下错误,删除目标shard3上的test1数据库,再次执行命令
mongos> sh.addShard("shard3/192.168.137.138:27019") { "ok" : 0, "errmsg" : "can't add shard shard3/192.168.137.138:27019 because a local database 'test1' exists in another shard1:shard1/192.168.137.111:27017,192.168.137.75:27017" } mongos> sh.addShard("shard3/192.168.137.138:27019") { "shardAdded" : "shard3", "ok" : 1 }
最后运行sh.status()命令确认迁移是否成功,可能会花比较长的时间。
以上内容是给大家介绍了Mongodb 删除添加分片与非分片表维护的全部叙述,希望对大家有所帮助。
免责声明:本站资源来自互联网收集,仅供用于学习和交流,请遵循相关法律法规,本站一切资源不代表本站立场,如有侵权、后门、不妥请联系本站删除!
更新日志
- 群星《爱情101情歌101延续篇 牵动心灵的情歌》6CD[WAV+CUE][4.2G]
- 【原神】璃月特产“人间美味”绝云椒椒的收集(58)
- 无相之草BOSS怎么打?无相草打法攻略
- 须弥沙漠地灵龛在哪?地灵龛位置详细介绍
- 群星.2024-生活在别处的我电视原声带【环球】【FLAC分轨】
- 陈雷.1996-最佳男主角【金圆唱片】【WAV+CUE】
- 苏妙玲.2019-WAN【天娱传媒】【FLAC分轨】
- 完美的人 A Man In Full
- 我们的生物世界 Our Living World
- 雷普利 Ripley
- 燕云十六声卷二烈言所有宝箱位置一览
- 崩坏星穹铁道神秘人交给你的线索位置大全
- 少年西游记2众生轮回活动攻略 2个玩法解析
- 出发吧麦芬古遗迹上的幽影试炼怎么过 古遗迹上的幽影阵容打法攻略
- 出发吧麦芬三宝齐聚黄金船试炼怎么过 三宝齐聚黄金船阵容打法攻略