Название: Database Performance at Scale: A Practical Guide
Автор: Felipe Cardeneti Mendes, Piotr Sarna, Pavel Emelyanov
Издательство: Apress
Год: 2023
Страниц: 270
Язык: английский
Формат: pdf (true), epub
Размер: 12.2 MB

Discover critical considerations and best practices for improving database performance based on what has worked, and failed, across thousands of teams and use cases in the field. This book provides practical guidance for understanding the database-related opportunities, trade-offs, and traps you might encounter while trying to optimize data-intensive applications for high throughput and low latency. Whether you are building a new system from the ground up or trying to optimize an existing use case for increased demand, this book covers the essentials.

The book begins with a look at the many factors impacting database performance at the extreme scale that today’s game changing applications face—or at least hope to achieve. You’ll gain insight into the performance impact of both technical and business requirements, and how those should influence your decisions around database infrastructure and topology. The authors share an inside perspective on often-overlooked engineering details that could be constraining—or helping—your team’s database performance. The book also covers benchmarking and monitoring practices by which to measure and validate the outcomes from the decisions that you make.
The ultimate goal of the book is to help you discover new ways to optimize database performance for your team’s specific use cases, requirements, and expectations.

What You Will Learn
Understand often overlooked factors that impact database performance at scale
Recognize data-related performance and scalability challenges associated with your project
Select a database architecture that’s suited to your workloads, use cases, and requirements
Avoid common mistakes that could impede your long-term agility and growth
Jumpstart teamwide adoption of best practices for optimizing database performance at scale

Who This Book Is For
Individuals and teams looking to optimize distributed database performance for an existing project or to begin a new performance-sensitive project with a solid and scalable foundation. This will likely include software architects, database architects, and senior software engineers who are either experiencing or anticipating pain related to database latency and/or throughput.

You are most likely:
• Experiencing or anticipating some pain related to database latency and/or throughput
• Working primarily on a use case with terabytes to petabytes of raw (unreplicated) data, over 10K operations per second, and with P99 latencies measured in milliseconds
• At least somewhat familiar with scalable distributed databases such as Apache Cassandra, ScyllaDB, Amazon DynamoDB, Google Cloud Bigtable, CockroachDB, and so on
• A software architect, database architect, software engineer, VP of engineering, or technical CTO/founder working with a data-intensive application

What This Book Is NOT:
A few things that this book is not attempting to be:
• A reference for infrastructure engineers building databases. We focus on people working with a database.
• A “definitive guide” to distributed databases, NoSQL, or data-intensive applications. We focus on the top database considerations most critical to performance.
• A guide on how to configure, work with, optimize, or tune any specific database. We focus on broader strategies you can “port” across databases.