The first time Baron Schwartz tried to monitor a database, he was overwhelmed. There were hundreds of variables to monitor as well as lots of Nagios check scripts that each had dozens of checks. He wasn’t sure what alerts to set up, so he set up too many and got a bunch of noise as a result. A couple of years later, Baron returned to that company and found all those alerts still in place, still spamming everyone, but the company had just filtered every alert to the trash.
Join Baron to discover how he learned to do monitoring better, so you won’t make the same mistakes he did. Any sophisticated system like a database has many more instrumentation points than you should actively monitor. The trick is approaching it with a sound monitoring framework in mind. Baron shares the framework he’s developed over many years, which breaks monitoring into a holistic approach that’s easy to understand and makes it obvious what kinds of data are useful for what purposes.
You’ll learn the seven golden signals (yes, seven and not four), how workload and resource performance are complementary and necessary for a complete understanding of database health and performance, and how to monitor technology-specific “sharp edges.” You’ll also see how these concepts work with a few databases, including MySQL, PostgreSQL, and MongoDB.
Baron Schwartz is the founder and CTO of VividCortex, the best way to see what your production database servers are doing. Baron has written a lot of open source software and several books, including High Performance MySQL. He’s focused his career on learning and teaching about performance and observability of systems generally, including the view that teams are systems and culture influences their performance, and databases specifically.
©2018, O'Reilly Media, Inc. • (800) 889-8969 or (707) 827-7019 • Monday-Friday 7:30am-5pm PT • All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners. • firstname.lastname@example.org