Skip to content
Related Articles

Related Articles

Save Article
Improve Article
Save Article
Like Article

Difference between scaling horizontally and vertically for databases

  • Last Updated : 23 Jun, 2021

Scaling :
It can be outlined as changing the size of something, for instance scaling the business. It is even same within the context of databases.

There are two types of scaling :

1. Horizontal scaling :
Horizontal scaling means we scale by adding additional machines to our existing bunch of resources.
 

Horizontal scaling

2. Vertical scaling :
Vertical scaling means we scale by adding more computing power like CPU and RAM to an existing machine.
 

Vertical scaling

Difference between scaling horizontally and vertically for databases :



Horizontal scaling

Vertical scaling

Horizontal scaling is difficult to implement.Vertical scaling easy to implement.
In Horizontal scaling the databases at each node or site only contains part of the data.Vertical scaling means we scale by adding more computing power like CPU and RAM to an existing machine.
Scaling can be done with less downtime.Vertical scaling involve more downtime.
More concurrency.Less concurrency when compared to Horizontal scaling.
Data sharing is complex.Data sharing is easy.
Horizontal scaling is more reliable.Less reliable when compared to Horizontal scaling.
Horizontal scaling is very costly.Vertical scaling is cheaper.
It is also known as scale out.It is also known as scale up.
More easy to upgrade in the future.Upgradation in future is not so easy.
Consumes more power.Consume less power.

 

My Personal Notes arrow_drop_up
Recommended Articles
Page :