Cost Benefit Analyses

Which database sharding approach is best?

Both horizontal sharding and vertical sharding involve adding resources to our computing infrastructure; our business stakeholders must decide which is suitable for our organization. For our organization and business to grow, prevent downtime, and reduce latency, we must scale our resources accordingly. We can scale these resources through a combination of adjustments to CPU, physical memory requirements, hard disk adjustments, and network bandwidth.

The following sections explain the pros and cons of no-sharding vs. sharding.