What does scaling mean in database?

What makes a database scalable?

What Makes a Scalable Database? Database scalability is a concept in analytics database design that emphasizes the capability of a database to handle growth in the amount of data and users. In the modern applications sphere, two types of workloads have emerged – namely analytical and transactional workloads.

When should you scale a database?

Indications of the Need for Scale A primary (and sometimes painful) indication that scaling your database tier is overdue is user complaints. If you are already at the point where your user experience is adversely affected by slow performance or, worse, by outright service outages, you must respond very quickly indeed.

What is SQL scaling?

Horizontal and vertical scaling Horizontal scaling refers to adding or removing databases in order to adjust capacity or overall performance, also called "scaling out". Sharding, in which data is partitioned across a collection of identically structured databases, is a common way to implement horizontal scaling.

What are the types of database scalability?

There are two broad categories for scaling database systems: vertical scaling and horizontal scaling. Vertical scaling, also known as scaling up, is the process of adding resources, such as memory or more powerful CPUs to an existing server. Removing memory or changing to a less powerful CPU is known as scaling down.