Difference between scaling horizontally and vertically for databases
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 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.|