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.
2. Vertical scaling :
Vertical scaling means we scale by adding more computing power like CPU and RAM to an existing machine.
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. |
Article Tags :
Recommended Articles