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. |
Share your thoughts in the comments
Please Login to comment...