Scalability of database and how it helps improve performance

Asked By ave broers 70 points N/A Posted on - 11/20/2014

What is meant by scalability of a database? What is the difference between a read heavy system and a write heavy system? What is vertical scaling? How is it different from horizontal scaling .If you have a ready heavy system, which one is the preferred mode of scaling: vertical or horizontal?

• Status: Open
• Question Views: 480
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Database

Answered By Hamthler itali 0 points N/A #151778

Scalability of database and how it helps improve performance

HELLO

 

Scalability:-

 

Scalability means that the growth of the system and increasing the volume of the system. 

Scalability is applied for the Suitable ,Efficient and large amount of the data/situations.

Scalability is increase the performance of the system 

There is two ways of Scalability to achieved

1 Vertical 

2 Horizontal 

 

Vertical scaling:-

 

Vertical scaling means that adding/including of hardware like RAM(Random access memory), Processor and load balancer .

Which can helps to get incoming calls from the different servers. Which are based on the routing algorithm. 

Using the vertical scaling to handle more load as load can shared across the servers.

 

Different from horizontal scaling and preferred scaling mode:-

 

         In the horizontal scaling can be adding of more machine into our pool recourse where vertical scaling adding more power likes CPU, RAM.

Horizontal scaling is based on the partition of the data every node contains only the related of the data. But in vertical scaling is often limited to the capacity for single machine and its involve the downtime comes with upper limit. Examples of horizontal scaling

Cassandra,MongoDB

examples of vertical scaling

MySQL-Amazon RDS

About Hamthler itali

Questions
0

Answers
100

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 02/17/2015
• Question Category: Database