.NET Architecture & System Design Interview Question #52
How can a relational database be scaled vertically?
Database Scaling, Partitioning, NoSQL & Data Consistency Mid-Level Intermediate
Quick Interview Answer
Vertical database scaling increases the capacity of one database server by adding CPU, memory, faster storage, or higher network capacity.
Detailed Explanation
Vertical database scaling increases the capacity of one database server by adding CPU, memory, faster storage, or higher network capacity.
It is operationally simple and often the first scaling step, but a single machine has practical and financial limits. Vertical scaling also does not by itself remove a single point of failure, so high-availability requirements must be addressed separately.
Code Example
Database Server
8 CPU / 32 GB RAM
|
v
32 CPU / 128 GB RAM