6
Understanding Database Scalability
The chapter covers various topics related to database scalability. It begins by explaining what scalability is and why it is important for databases. It then discusses two main types of database scalability: horizontal and vertical scaling.
Horizontal scaling involves adding more servers to a database cluster to increase its processing power and storage capacity. The chapter explains the advantages and challenges of horizontal scaling and provides examples of how it can be implemented.
Vertical scaling, on the other hand, involves adding more resources to a single server, such as CPU, RAM, or storage. The chapter explains the pros and cons of vertical scaling and provides examples of how it can improve
Get Database Design and Modeling with PostgreSQL and MySQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
