去年的筆記，接著發(fā)

目前累計服務客戶上1000家，積累了豐富的產品開發(fā)及服務經驗。以網站設計水平和技術實力，樹立企業(yè)形象，為客戶提供網站制作、成都網站設計、網站策劃、網頁設計、網絡營銷、VI設計、網站改版、漏洞修補等服務。創(chuàng)新互聯始終以務實、誠信為根本，不斷創(chuàng)新和提高建站品質，通過對領先技術的掌握、對創(chuàng)意設計的研究、對客戶形象的視覺傳遞、對應用系統(tǒng)的結合，為客戶提供更好的一站式互聯網解決方案，攜手廣大客戶，共同發(fā)展進步。

一、如何移除分片

1、確認balancer已經開啟

mongos> sh.getBalancerState() true

2、移除分片

注：在admin db下執(zhí)行命令。

mongos> use admin switched to db admin mongos> db.runCommand( { removeShard: "shard3" } ) { "msg" : "draining started successfully", "state" : "started", "shard" : "shard3", "ok" : 1 }

3、檢查遷移的狀態(tài)

同樣執(zhí)行

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、執(zhí)行添加分片的命令

如果出現以下錯誤，刪除目標shard3上的test1數據庫，再次執(zhí)行命令

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()命令確認遷移是否成功，可能會花比較長的時間。

另外有需要云服務器可以了解下創(chuàng)新互聯cdcxhl.cn，海內外云服務器15元起步，三天無理由+7*72小時售后在線，公司持有idc許可證，提供“云服務器、裸金屬服務器、高防服務器、香港服務器、美國服務器、虛擬主機、免備案服務器”等云主機租用服務以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡單易用、服務可用性高、性價比高”等特點與優(yōu)勢，專為企業(yè)上云打造定制，能夠滿足用戶豐富、多元化的應用場景需求。

本文題目：Mongodb添加刪除分片與非分片表維護-創(chuàng)新互聯
新聞來源：http://weahome.cn/article/iiish.html