# MongoDB教育訓練-20211223-03

vertical scaling 垂直擴展(升級到某個程度，會很貴並有極限)

horizontal sacling 水平擴展 (比較省成本)

[![image-1640242289465.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/WNPaHJCxNDV7y5ek-image-1640242289465.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/WNPaHJCxNDV7y5ek-image-1640242289465.png)

沒有一定要shard(如果資料不多不需要，管理複雜度高)

[![image-1640242412103.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/9wbUHEyWdAtGiHWa-image-1640242412103.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/9wbUHEyWdAtGiHWa-image-1640242412103.png)

[![image-1640242564943.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/k4B2vYQF9vFVLMHI-image-1640242564943.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/k4B2vYQF9vFVLMHI-image-1640242564943.png)

- why learn about sharding now?
- you might not need to shard for years
- but decisions you make about schema design befoe that matter
- start planning for sharding on day one

[![image-1640242581364.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/lwlqelUGcUlyNd54-image-1640242581364.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/lwlqelUGcUlyNd54-image-1640242581364.png)

[![image-1640242682522.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/nbXWY4DLAOypwauJ-image-1640242682522.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/nbXWY4DLAOypwauJ-image-1640242682522.png)

[![image-1640242841645.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/WA1BuRXuhph6yNSj-image-1640242841645.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/WA1BuRXuhph6yNSj-image-1640242841645.png)

mongos 屏蔽所有細節

[![image-1640242859417.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/4pjQ98bgVwvRhQhI-image-1640242859417.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/4pjQ98bgVwvRhQhI-image-1640242859417.png)

configuration server 決定資料分布

[![image-1640242920382.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/8vpdhQPhwezSA16S-image-1640242920382.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/8vpdhQPhwezSA16S-image-1640242920382.png)

[![image-1640242991219.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/udIFf8TK6WQ86Vat-image-1640242991219.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/udIFf8TK6WQ86Vat-image-1640242991219.png)

[![image-1640243006562.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/TciPkWgEPCb2dWeW-image-1640243006562.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/TciPkWgEPCb2dWeW-image-1640243006562.png)

[![image-1640243117106.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/eJGjPxByWF0mq62G-image-1640243117106.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/eJGjPxByWF0mq62G-image-1640243117106.png)

修改分片鍵

[![image-1640243247361.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/9t1Rsl2zJwqR6fvs-image-1640243247361.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/9t1Rsl2zJwqR6fvs-image-1640243247361.png)

選擇分片鍵原則

shard keys 不一定是要一樣的，重複的不可超過64MB

[![image-1640243397277.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/yJvQFYh4JP9ch7gx-image-1640243397277.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/yJvQFYh4JP9ch7gx-image-1640243397277.png)

[![image-1640243910637.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/pXt9gNUTgm7f9JOY-image-1640243910637.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/pXt9gNUTgm7f9JOY-image-1640243910637.png)

[![image-1640243925444.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/9ORq0VI5ydsIsIEs-image-1640243925444.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/9ORq0VI5ydsIsIEs-image-1640243925444.png)

[![image-1640244070167.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/ti8OKD2bA7Om04oj-image-1640244070167.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/ti8OKD2bA7Om04oj-image-1640244070167.png)

[![image-1640244228199.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/RGrDhrhpMgfLQqdY-image-1640244228199.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/RGrDhrhpMgfLQqdY-image-1640244228199.png)

[![image-1640244431054.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/m3MrqhOquZ4HBcS1-image-1640244431054.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/m3MrqhOquZ4HBcS1-image-1640244431054.png)

[![image-1640245827455.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/EvsLc9SiqIkkdFmv-image-1640245827455.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/EvsLc9SiqIkkdFmv-image-1640245827455.png)

[![image-1640246122904.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/aF9XYZxnA83gyNy7-image-1640246122904.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/aF9XYZxnA83gyNy7-image-1640246122904.png)

[![image-1640246580335.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/3vkpAb7OMpoNmKs1-image-1640246580335.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/3vkpAb7OMpoNmKs1-image-1640246580335.png)

[![image-1640246143964.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/6bGqPLLgJrVFwyv6-image-1640246143964.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/6bGqPLLgJrVFwyv6-image-1640246143964.png)

[![image-1640246907569.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/6n07LgrqZTiv1aXi-image-1640246907569.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/6n07LgrqZTiv1aXi-image-1640246907569.png)

#### 預分片

[![image-1640247049023.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/1XBWLTnq72Gwwj38-image-1640247049023.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/1XBWLTnq72Gwwj38-image-1640247049023.png)

範例 1000億筆資料

[![image-1640247152836.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/FJ9Mgvm0w06JRLp6-image-1640247152836.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/FJ9Mgvm0w06JRLp6-image-1640247152836.png)

ＹＣＳＢ壓測工具

[![image-1640247396813.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/MX2RzMWGwFipMVK8-image-1640247396813.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/MX2RzMWGwFipMVK8-image-1640247396813.png)

[![image-1640247645818.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/I4xvjQ0YY6zvvmfU-image-1640247645818.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/I4xvjQ0YY6zvvmfU-image-1640247645818.png)

[![image-1640247664050.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/8byDycHQAHcmPwcA-image-1640247664050.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/8byDycHQAHcmPwcA-image-1640247664050.png)

[![image-1640247809556.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/4Y3SYEpqiGFJixD1-image-1640247809556.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/4Y3SYEpqiGFJixD1-image-1640247809556.png)

primary shared 最忙

[![image-1640247884753.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/7PxUBnmsctBGBQMm-image-1640247884753.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/7PxUBnmsctBGBQMm-image-1640247884753.png)

完全停止

[![image-1640248229678.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/2fxzL3fhexEFquxI-image-1640248229678.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/2fxzL3fhexEFquxI-image-1640248229678.png)

[![image-1640248345321.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/vLTpEPOwoTqLepl9-image-1640248345321.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/vLTpEPOwoTqLepl9-image-1640248345321.png)

分散多筆sharding ，利用換取ＣＰＵ計算

[![image-1640248651952.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/PlArjNlZLfbdB1gX-image-1640248651952.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/PlArjNlZLfbdB1gX-image-1640248651952.png)