Proactive MySQL Monitoring

1 .Proactive MySQL Monitoring Diagnostics and Capacity Planning Peter Zaitsev CEO, Percona October 25, 2016 

2 .Many Sides of Monitoring Investigations and Capacity Planning Alerting (When Diagnostics (Finding (Preventing resource things get bad) Root Cause) exhaustion) 2 

3 .Alerting 

4 .Focus on Service vs Component Service Component • Web Site Overall • General Availability and • Single Web Server Performance • Remove from the service if • Redundancy Loss poor availability or • Other “global” issues ie correctness Performance • Immediate Action required 24/7 • Self Healing (especially cloud) • Automated Actions for Healing and Scaling • 24/7 optional 4 

5 .Proactive and Reactive Proactive Reactive • Needs attention to prevent future • When things are bad or problem problem eminent • Working Hours • 24/7/365 • Replication Capacity close to limit • Server Crashed • Will run of space in a week • Replication Broke • Backup is taking longer than • Servicing Queries Slowly desired • Backup Failed 5 

6 .Service Impacting and Operational Service Impacting Operational •Directly Impacting •Are backup being taken ? Application •Is configuration valid/secure ? •Service Down •Is replication running and •Service Slow up to date ? 6 

7 .Signal Versus Noise High Noise Alerting systems fail due to Human Psychology https://en.wikipedia.org/wiki/The_Boy_Who_Cried_Wolf 7 

8 .Learn More on Alerting Fantastic Alerting Philosophy •http://bit.ly/AlertingPhilosophy by Rob Ewaschuk 8 

9 .What do we use at Percona ? Working on next Percona Monitoring generation Alerting for Plugins (NAGIOS) Percona Monitoring and http://bit.ly/PerconaMP Management 9 

10 .Investigations and Diagnostics 

11 .What does MySQL do ? Responds Application Requests 11 

12 .Criteria Response (Available) Right Quickly (Correctness) (Performance) 12 

13 .Two Ways to Look Query Focused System Focus 13 

14 .Problem Caused By Hardware and Application MySQL Environment • Too many • Choosing Bad • CPU Queries Plan • Disk • Bad Queries • Contention • Memory Issues • Network • Locking 14 

15 .With this in mind we built PMM Percona Monitoring and Management http://bit.ly/GetPMM Query Analytics – Looking at the Queries Side Metrics – Looking at the Operating System and MySQL Side Built by using Best in class Open Source Components 100% Free and Open Source Available now as GA 15 

16 .Meet PMM Note: Name is futureproof, currently doing Monitoring not Management 16 

17 .Inside Percona Monitoring and Management 17 

18 .For the User ? Get Docker Container for “Server Part” Install the “Agent” on MySQL or MongoDB Servers Point the agent to the right server location 18 

19 .Our Grand for Plan for PMM To Become Open Source Monitoring and Management solution for MySQL and MongoDB Focus on Ease of use for Non-Experts But have depth for Experts to solve most complicated problems Actionable advice as automated as possible Work in and out of the Cloud Do not reinvent bicycle. Use Best in Class Open Source Components 19 

20 .Check it Out Live Demo is running at http://pmmdemo.percona.com 20 

21 .Lets Explore it Together! (Demo) 

22 .Thank You!