Open In App

Difference between scaling horizontally and vertically for databases

Last Updated : 23 Jun, 2021
Improve
Improve
Like Article
Like
Save
Share
Report

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.

 


Like Article
Suggest improvement
Share your thoughts in the comments

Similar Reads