Database Performance at Scale

A Practical Guide


Database Performance at Scale
Database Performance at Scale
CC BY

Book Details

Authors Felipe Cardeneti Mendes, Piotr Sarna, Pavel Emelyanov, Cynthia Dunlop
Publisher Apress
Published 2023
Edition 1st
Paperback 254 pages
Language English
ISBN-13 9781484297100, 9781484297117
ISBN-10 1484297105, 1484297113
License Creative Commons Attribution

Book Description

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.

- 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


This book is available under a Creative Commons Attribution license (CC BY), which means that you are free to copy, distribute, and modify it, as long as you give appropriate credit to the original author.

If you enjoyed the book and would like to support the author, you can purchase a printed copy (hardcover or paperback) from official retailers.

Download and Read Links

Share this Book

[localhost]# find . -name "*Similar_Books*"


A Practical Guide to Cloud Migration

Cloud Google

Why do enterprises feel daunted when undertaking a large-scale cloud transformation? A move to the cloud usually offers substantial rewards. Once companies make this transition, they unlock new business opportunities that fundamentally change the way they work. With this report, members of the Google team will show you how to navigate the cultural

Presto: The Definitive Guide

SQL

Perform fast interactive analytics against different data sources using the Presto high-performance, distributed SQL query engine. With this practical guide, you'll learn how to conduct analytics on data where it lives, whether it's Hive, Cassandra, a relational database, or a proprietary data store. Analysts, software engineers, and production eng

AI for Mass-Scale Code Refactoring and Analysis

Analysis

As the software development landscape evolves, the challenge of managing and refactoring extensive code bases becomes increasingly complex. AI methods of code refactoring, while effective for smaller scales, can falter under the weight of mass-scale operations. The need for efficiency, accuracy, and consistency is more critical than ever. This key

Reactive Microsystems

If you want your application to provide millisecond response times and close to 100% uptime, traditional architectures with single SQL databases and thread-per-request models simply cannot compete with microservices. This report discusses strategies and techniques for building scalable and resilient microservices, and helps you work your way throug

A Practical Guide to TPM 2.0

Security

A Practical Guide to TPM 2.0: Using the Trusted Platform Module in the New Age of Security is a straight-forward primer for developers. It shows security and TPM concepts, demonstrating their use in real applications that the reader can try out. Simply put, this book is designed to empower and excite the programming community to go out and do cool

Effective AWK Programming, 5th Edition

AWK

When processing text files, the awk language is ideal for handling data extraction, reporting, and data-reformatting jobs. This practical guide serves as both a reference and tutorial for POSIX-standard awk and for the GNU implementation, called gawk. This book is useful for novices and awk experts alike. In this thoroughly revised 5th edition, aut