October 2018
Intermediate to advanced
250 pages
4h 54m
English
book
Database Benchmarking and Stress Testing: An Evidence-Based Approach to Decisions on Architecture and Technology
by Bert Scalzo
Overview
Provide evidence-based answers that can be measured and relied upon by your business. Database administrators will be able to make sound architectural decisions in a fast-changing landscape of virtualized servers and container-based solutions based on the empirical method presented in this book for answering “what if” questions about database performance.
Today’s database administrators face numerous questions such as:
- What if we consolidate databases using multitenant features?
- What if we virtualize database servers as Docker containers?
- What if we deploy the latest in NVMe flash disks to speed up IO access?
- Do features such as compression, partitioning, and in-memory OLTP earn back their price?
- What if we move our databases to the cloud?
As an administrator, do you know the answers or even how to test the assumptions?
Database Benchmarking and Stress Testing introduces you to database benchmarking using industry-standard test suites such as the TCP series of benchmarks, which are the same benchmarks that vendors rely upon. You’ll learn to run these industry-standard benchmarks and collect results to use in answering questions about the performance impact of architectural changes, technology changes, and even down to the brand of database software. You’ll learn to measure performance and predict the specific impact of changes to your environment. You’ll know the limitations of the benchmarks and the crucial difference between benchmarking and workload capture/reply.
What You'll Learn
- Understand the industry-standard database benchmarks, and when each is best used
- Prepare for a database benchmarking effort so reliable results can be achieved
- Perform database benchmarking for consolidation, virtualization, and cloud projects
- Recognize and avoid common mistakes in benchmarking database performance
- Measure and interpret results in a rational, concise manner for reliable comparisons
- Choose and provide advice on benchmarking tools based on their pros and cons
Who This Book Is For
Database administrators and professionals responsible for advising on architectural decisions such as whether to use cloud-based services, whether to consolidate and containerize, and who must make recommendations on storage or any other technology that impacts database performance
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.