Database Performance at Scale: A Practical Guide

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 open access 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.

這本開放存取的書籍提供了實用的指導，以了解在嘗試為高吞吐量和低延遲優化數據密集型應用程序時可能遇到的與數據庫相關的機會、權衡和陷阱。無論您是從頭開始建立一個新系統還是優化現有用例以應對增加的需求，本書都涵蓋了基本知識。

本書首先探討了影響當今具有改變遊戲規則的應用程序所面臨的極端規模的數據庫性能的眾多因素。您將瞭解技術和業務需求對性能的影響，以及這些因素應該如何影響您對數據庫基礎設施和拓撲的決策。作者們分享了一些常常被忽視的工程細節，這些細節可能限制或幫助您的團隊的數據庫性能。本書還介紹了基準測試和監控實踐，以衡量和驗證您所做決策的結果。

本書的最終目標是幫助您發現針對團隊特定的用例、需求和期望優化數據庫性能的新方法。

您將學到什麼：
- 瞭解常常被忽視的影響數據庫性能的因素
- 認識與項目相關的數據相關性能和可擴展性挑戰
- 選擇適合您的工作負載、用例和需求的數據庫架構
- 避免可能阻礙您長期靈活性和增長的常見錯誤
- 推動團隊廣泛採用優化大規模數據庫性能的最佳實踐

本書適合對現有項目進行分佈式數據庫性能優化，或者以堅實且可擴展的基礎開始一個新的性能敏感項目的個人和團隊。這可能包括軟件架構師、數據庫架構師和高級軟件工程師，他們可能正在經歷或預期與數據庫延遲和/或吞吐量相關的困擾。

Felipe Cardeneti Mendes is an IT specialist with years of experience on distributed systems and open source technologies. He has co-authored three Linux books and is a frequent speaker at public events and conferences to promote open source technologies. At ScyllaDB, he works as a Solution Architect.

Piotr Sarna is a software engineer who is keen on open-source projects and the Rust and C++ languages. He previously developed an open-source distributed file system and had a brief adventure with the Linux kernel during an apprenticeship at Samsung Electronics. He's also a long-time contributor and maintainer of ScyllaDB, as well as libSQL. Piotr graduated from University of Warsaw with an MSc in Computer Science.

Pavel "Xemul" Emelyanov is an ex-Linux kernel hacker now speeding up row cache, tweaking the IO scheduler, and helping to pay back technical debt for component interdependencies. He is a Principal Engineer at ScyllaDB.

Cynthia Dunlop is a technology writer who specializes in application development. She has co-authored four books and hundreds of articles on everything from C/C++ memory error detection to continuous testing and DevOps. Cynthia holds a bachelor's degree from UCLA and a master's degree from Washington State University.

Felipe Cardeneti Mendes 是一位擁有多年分散式系統和開源技術經驗的 IT 專家。他共同撰寫了三本 Linux 書籍，並經常在公開活動和會議上演講，以推廣開源技術。在 ScyllaDB，他擔任解決方案架構師的職位。

Piotr Sarna 是一位熱衷於開源項目、Rust 和 C++ 語言的軟體工程師。他之前開發了一個開源分散式檔案系統，在三星電子的學徒期間也曾經涉足 Linux 內核。他也是 ScyllaDB 和 libSQL 的長期貢獻者和維護者。Piotr 畢業於華沙大學，獲得計算機科學碩士學位。

Pavel 'Xemul' Emelyanov 是一位前 Linux 內核黑客，現在加速行緩存、調整 IO 調度器，並幫助償還組件相互依賴的技術債務。他是 ScyllaDB 的首席工程師。

Cynthia Dunlop 是一位專注於應用程式開發的技術作家。她共同撰寫了四本書籍，以及數百篇關於從 C/C++ 記憶體錯誤偵測到持續測試和 DevOps 的文章。Cynthia 擁有加州大學洛杉磯分校的學士學位和華盛頓州立大學的碩士學位。