Mysql Highmem Hyperdisk Balanced Performance Sizing

What the solution is

This architecture combines a memory-optimized high-memory (highmem) instance shape with Google Cloud Hyperdisk Balanced storage. A highmem machine type provides approximately 8 GB of RAM per vCPU, allowing large memory allocations without over-provisioning unneeded vCPUs. Hyperdisk Balanced offers flexible, decoupled provisioning of IOPS and throughput independently from storage capacity.

How it meets the requirements

• High read QPS & low read latency: Sizing the VM so that the ~110 GB working set fits completely into the MySQL InnoDB buffer pool ensures that steady-state read queries are served directly from RAM rather than disk, eliminating disk I/O bottlenecks.
• Optimized compute cost: By selecting a highmem instance shape, you achieve a high RAM-to-vCPU ratio. This avoids paying for excess vCPUs that would remain idle under low CPU utilization per query.
• Cost-effective write performance: Hyperdisk Balanced allows you to provision exactly the IOPS and throughput required for write transactions (redo logs and table flushes) without paying for unneeded disk capacity.

Key advantages and capabilities

• Decoupled performance scaling: Hyperdisk Balanced lets administrators scale provisioned IOPS and throughput on-demand as transaction volume grows.
• Sub-millisecond memory latency: Serving hot reads out of the memory buffer pool delivers microsecond-level query latencies.
• High durability: Hyperdisk Balanced provides greater than 99.999% durability against hardware failures and data corruption.
• Half-duplex awareness: Optimizing reads to stay in memory preserves the VM's combined read/write storage IOPS limit exclusively for write operations.

Why this is optimal

Serving reads out of RAM is dramatically faster and more cost-effective than provisioning ultra-high IOPS disk tiers to serve read queries from persistent storage. Pairing a highmem VM with Hyperdisk Balanced achieves maximum read performance at the lowest total cost of ownership.