Cockroach Labs Estate economics What idle nodes, provisioned bytes and peak-sized bills cost, worked out from your estate.
  1. Nodes 67 baseline
  2. Avg CPU utilization 15.0% idle hardware
  3. Storage provisioned 300 GB 50 GB 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.

Deployment model
Separate clusters One Private Host Cluster
5 standalone clusters, 67 nodes in totalcluster-0112% CPU15 nodescluster-027% CPU13 nodescluster-0326% CPU13 nodescluster-0420% CPU13 nodescluster-0510% CPU13 nodesEstate before consolidation5 separate clusters of around 13 nodes each, 67 nodes in total, averaging 15.0% CPU utilization.
15%Average CPUAverage CPU CPU utilization15.0% of provisioned CPU is in use.

67 nodes running 80 vCPU of actual work.

The arithmetic, in full
StepWorkingResult
Provisioned today5 clusters totalling 67 nodes (drawn around 13, 13 to 15) x 8 vCPU536 vCPU
Mean demand536 vCPU x 15.0% estate average utilization (per-cluster 6.5% to 26.1%, sd 7.0%)80 vCPU
Aggregate peak80.4 vCPU x (1 + (2.23 - 1) / sqrt(5)), a pooled peak-to-mean of 1.549125 vCPU
Consolidated, sized once for the peakmax(3, ceil(124.6 vCPU / (8 vCPU x 37.5% target))) = max(3, ceil(41.52)); the mean sits well under that peak42 nodes, averaging 23.9%
Auto-scaled through the daythe pool follows the pooled curve in whole nodes, 30 minutes behind it, holding its size for 2 hours before shrinking29 nodes on average, at 34.7% CPU
Utilization across the day23.0% to 41.7% 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 peak23.0%-41.7%

Assumptions

  • 8 vCPU per node. Standalone clusters are drawn around 13 nodes, snapped to an odd number for quorum and held between 3 and 15; in this estate they run 13 to 15, a 0.8-node standard deviation, for 67 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 6.5% to 26.1%, a 7.0-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 42 at peak.
  • The auto-scaler sizes for what it saw 30 minutes ago and waits 2 hours before shrinking, so the pool averages 34.7% 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.