Cockroach Labs Estate economics What idle nodes, provisioned bytes and peak-sized bills cost, worked out from your estate.

Estate summary

  1. Nodes 898 baseline
  2. Avg CPU utilization 15.0% idle hardware
  3. Storage provisioned 6.0 TB 1.0 TB of data
  4. Est. monthly saving 0%

Step 1 of 8 - Virtualization

You're running an estate, not a cluster

Every cluster below was sized for its own peak, so every one of them idles.

100 standalone clusters, 898 nodes in totalcluster-0110% CPU11 nodescluster-025% CPU9 nodescluster-0321% CPU7 nodescluster-0416% CPU7 nodescluster-058% CPU9 nodescluster-0614% CPU13 nodescluster-0710% CPU5 nodescluster-0817% CPU9 nodescluster-0914% CPU9 nodescluster-1012% CPU9 nodescluster-119% CPU11 nodescluster-1218% CPU7 nodescluster-1319% CPU7 nodescluster-1424% CPU9 nodescluster-1512% CPU9 nodescluster-1613% CPU9 nodescluster-1717% CPU9 nodescluster-1823% CPU9 nodescluster-1913% CPU11 nodescluster-2014% CPU9 nodescluster-2112% CPU13 nodescluster-2216% CPU9 nodescluster-2319% CPU11 nodescluster-2415% CPU13 nodescluster-2518% CPU7 nodescluster-2617% CPU9 nodescluster-2711% CPU7 nodescluster-2827% CPU9 nodescluster-2912% CPU9 nodescluster-3023% CPU9 nodescluster-3120% CPU7 nodescluster-321% CPU11 nodescluster-3315% CPU11 nodescluster-349% CPU11 nodescluster-3517% CPU7 nodescluster-3614% CPU11 nodescluster-3715% CPU11 nodescluster-3814% CPU9 nodescluster-3915% CPU7 nodescluster-4028% CPU7 nodescluster-418% CPU11 nodescluster-4214% CPU9 nodescluster-4322% CPU9 nodescluster-4414% CPU9 nodescluster-4513% CPU9 nodescluster-4610% CPU11 nodescluster-4713% CPU5 nodescluster-4820% CPU11 nodescluster-4911% CPU7 nodescluster-5010% CPU13 nodescluster-5120% CPU11 nodescluster-5215% CPU9 nodescluster-5312% CPU11 nodescluster-546% CPU9 nodescluster-5516% CPU7 nodescluster-5614% CPU9 nodescluster-5712% CPU11 nodescluster-5822% CPU13 nodescluster-596% CPU9 nodescluster-6015% CPU11 nodescluster-6116% CPU7 nodescluster-6218% CPU9 nodescluster-6321% CPU11 nodescluster-6413% CPU9 nodescluster-6521% CPU7 nodescluster-6621% CPU7 nodescluster-6726% CPU9 nodescluster-6811% CPU7 nodescluster-6915% CPU11 nodescluster-7015% CPU9 nodescluster-7124% CPU9 nodescluster-7210% CPU11 nodescluster-7310% CPU9 nodescluster-7413% CPU11 nodescluster-7514% CPU11 nodescluster-7619% CPU7 nodescluster-776% CPU9 nodescluster-789% CPU9 nodescluster-799% CPU5 nodescluster-809% CPU11 nodescluster-8123% CPU9 nodescluster-8214% CPU9 nodescluster-8315% CPU7 nodescluster-8410% CPU9 nodescluster-8527% CPU9 nodescluster-8622% CPU9 nodescluster-8718% CPU7 nodescluster-8817% CPU7 nodescluster-8914% CPU5 nodescluster-9022% CPU9 nodescluster-9119% CPU7 nodescluster-9218% CPU7 nodescluster-9310% CPU9 nodescluster-9411% CPU7 nodescluster-9515% CPU7 nodescluster-9612% CPU9 nodescluster-9723% CPU9 nodescluster-9811% CPU7 nodescluster-9918% CPU13 nodescluster-10016% CPU5 nodesEstate before consolidation100 separate clusters of around 9 nodes each, 898 nodes in total, averaging 15.0% CPU utilization.
15%Average CPUAverage CPU CPU utilization15.0% of provisioned CPU is in use.

898 nodes running 1,078 vCPU of actual work.

The arithmetic, in full
StepWorkingResult
Provisioned today100 clusters totalling 898 nodes (drawn around 9, 5 to 13) x 8 vCPU7184 vCPU
Mean demand7184 vCPU x 15.0% estate average utilization (per-cluster 0.5% to 27.7%, sd 5.3%)1078 vCPU
Aggregate peak1077.6 vCPU x (1 + (2.23 - 1) / sqrt(100)), a pooled peak-to-mean of 1.1231210 vCPU
Consolidated, sized once for the peakmax(3, ceil(1209.9 vCPU / (8 vCPU x 37.5% target))) = max(3, ceil(403.31)); the mean sits well under that peak404 nodes, averaging 33.3%
Auto-scaled through the daythe pool follows the pooled curve in whole nodes, 30 minutes behind it, holding its size for 2 hours before shrinking365 nodes on average, at 36.9% CPU
Utilization across the day33.7% to 38.4% against a 37.5% setpoint: the pool runs hot while it's a bucket behind a rise, and cool while the cooldown is still holding capacity after a peak33.7%-38.4%

Assumptions

  • 8 vCPU per node. Standalone clusters are drawn around 9 nodes, snapped to an odd number for quorum and held between 3 and 15; in this estate they run 5 to 13, a 1.9-node standard deviation, for 898 nodes in total.
  • Each standalone cluster's CPU is a draw from a normal distribution centred on 15.0% and held between 0% and 100%; in this estate they run 0.5% to 27.7%, a 5.3-point standard deviation. The published band is 10-15% today against a 30-45% auto-scaled target, and this Private Host Cluster is set to 37.5%.
  • The Private Host Cluster floors at 3 nodes and must reach 404 at peak.
  • The auto-scaler sizes for what it saw 30 minutes ago and waits 2 hours before shrinking, so the pool averages 36.9% rather than sitting on its 37.5% setpoint.
  • Workloads are independent; consolidation moves where work runs, not how much there is.
What a virtual cluster gives an app team

Its own connection string, databases, schemas, users, roles and backups, and no visibility into the Private Host Cluster or any other virtual cluster.