Mid SQL

Horizontal Scaling (Scaling Out):?

  • Horizontal scaling involves adding more database servers to distribute the

load, typically using replication, sharding, or clustering.

  • Advantages: It can handle much larger datasets and traffic since the

workload is distributed across multiple servers.

  • Disadvantages: More complex to implement and maintain, requires

specialized techniques like load balancing and data partitioning.

More from SQL Server Tutorial

All questions for this course