What’s the difference between horizontally and vertically scaling a database?

1137310 pts.
Tags:
Database
MySQL
NoSQL
I'm working with two different databases (NoSQL and MySQL) and we're looking to measure the scalability of each database. What's the difference between vertically and horizontally scaling each one? I would appreciate any help.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.
Hi,
Horizontal scaling:- Scale by adding more machines into your pool of resource. In a database world  horizontal scaling is often based on partitioning of the data i.e. each node contains only part of data. With horizontal-scaling it is often easier to scale dynamically by adding more machines into the existing pool. A good example of horizontal scaling  is Cassandra, MangoDB..

Vertical scaling:- Scale by adding more power (CPU, RAM) to existing machine. In this scaling the data exist on a single node and sacling is done through multi-core i.e. spreading the load b/w the CPU & RAM resource of the machine.Vertical-scaling is often limited to the capacity of a single machine, scaling beyond that capacity often involves downtime and comes with an upper limit. A Good example of vertical scaling is My SQL.  

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: