1k 2k 3k

mtojek · mtojek · commit 6a87a93620f8 · 2024-03-13T15:15:12.000+01:00
diff --git a/docs/admin/architectures/1k-users.md b/docs/admin/architectures/1k-users.md
@@ -44,4 +44,6 @@ tech startups, educational units, or small to mid-sized enterprises.
 
 ### Database nodes
 
-TODO
+| Users       | Node capacity       | Replicas | Storage | GCP                | AWS           | Azure             |
+| ----------- | ------------------- | -------- | ------- | ------------------ | ------------- | ----------------- |
+| Up to 1,000 | 2 vCPU, 8 GB memory | 1        | 512 GB  | `db-custom-2-7680` | `db.t3.large` | `Standard_D2s_v3` |
diff --git a/docs/admin/architectures/2k-users.md b/docs/admin/architectures/2k-users.md
@@ -49,4 +49,11 @@ enabling it for deployment reliability.
 
 ### Database nodes
 
-TODO
+| Users       | Node capacity        | Replicas | Storage | GCP                 | AWS            | Azure             |
+| ----------- | -------------------- | -------- | ------- | ------------------- | -------------- | ----------------- |
+| Up to 2,000 | 4 vCPU, 16 GB memory | 1        | 1 TB    | `db-custom-4-15360` | `db.t3.xlarge` | `Standard_D4s_v3` |
+
+**Footnotes**:
+
+- Consider adding more replicas if the workspace activity is higher than 500
+  workspace builds per day.
diff --git a/docs/admin/architectures/3k-users.md b/docs/admin/architectures/3k-users.md
@@ -46,4 +46,11 @@ purposes.
 
 ### Database nodes
 
-TODO
+| Users       | Node capacity        | Replicas | Storage | GCP                 | AWS             | Azure             |
+| ----------- | -------------------- | -------- | ------- | ------------------- | --------------- | ----------------- |
+| Up to 3,000 | 8 vCPU, 32 GB memory | 2        | 1.5 TB  | `db-custom-8-30720` | `db.t3.2xlarge` | `Standard_D8s_v3` |
+
+**Footnotes**:
+
+- Consider adding more replicas if the workspace activity is higher than 1500
+  workspace builds per day.
diff --git a/docs/admin/architectures/index.md b/docs/admin/architectures/index.md
@@ -316,6 +316,8 @@ considerations:
   Coder deployment with less than 1000 users, and low activity level (30% active
   users). This capacity should be sufficient to support 100 external
   provisioners.
+- Storage size depends on user activity, workspace builds, log verbosity,
+  overhead on database encryption, etc.
 - Allocate an additional CPU core to the database instance for every 1000 active
   users.
 - Enable _High Availability_ mode for database engine for large scale
diff --git a/docs/admin/scale.md b/docs/admin/scale.md
@@ -111,7 +111,7 @@ For example, to support 120 concurrent workspace builds:
 | Kubernetes (GKE) | 3 cores   | 12 GB     | 1              | db-f1-micro      | 200   | 3                 | 200 simulated                         | `v0.24.1`     | Jun 26, 2023 |
 | Kubernetes (GKE) | 4 cores   | 8 GB      | 1              | db-custom-1-3840 | 1500  | 20                | 1,500 simulated                       | `v0.24.1`     | Jun 27, 2023 |
 | Kubernetes (GKE) | 2 cores   | 4 GB      | 1              | db-custom-1-3840 | 500   | 20                | 500 simulated                         | `v0.27.2`     | Jul 27, 2023 |
-| Kubernetes (GKE) | 2 cores   | 4 GB      | 2              | db-custom-2-7680 | 1000  | 20                | 1000 simulated                        | `v2.2.1`      | Oct 9, 2023  |
+| Kubernetes (GKE) | 2 cores   | 8 GB      | 2              | db-custom-2-7680 | 1000  | 20                | 1000 simulated                        | `v2.2.1`      | Oct 9, 2023  |
 
 > Note: a simulated connection reads and writes random data at 40KB/s per
 > connection.
