Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Monitoring Sessions

Sponsor Percona Live Open Source Database Conference

Featured Database Monitoring Speakers


Database monitoring is used to observe changes in the database, as well as the performance and metrics around queries and resource usage. Monitoring information can be used to help improve database performance, and ultimately application performance.

Percona Live’s Database Monitoring track provides in-depth discussions on database monitoring can be used with IoT, cloud, big data and other important enterprise interests.

Below are the talks covering database monitoring at this year’s conference.

  • 1:30pm to 4:30pm
    Ballroom H
    • Operations
    Michael Coburn (Percona), Roma Novikov (Percona)
    This is a hands-on tutorial covering how to set up monitoring for MySQL database servers using the Percona Monitoring and Management (PMM) platform. PMM is an open-source collection of tools for managing and monitoring MySQL and MongoDB performance.
    MySQL Monitoring

11:30am to 12:20pm

  • 11:30am to 12:20pm
    Ballroom E
    • Developer
    Peter Zaitsev (Percona)
    In this talk, I will introduce Percona’s latest open source software tool: Percona Monitoring and Management (PMM). I will briefly discuss high-level aspects of monitoring we’ve found work well in practice at Percona, and then spend the rest of the time with an online demonstration of how to use this tool to identify common MySQL issues.
    MySQL Monitoring
  • 11:30am to 12:20pm
    Ballroom G
    • Operations
    Art van Scheppingen (Severalnines AB)
    To operate MongoDB efficiently, you need to have insight into database performance. And with that in mind, we’ll dive into monitoring in this talk. MongoDB offers many metrics through various status overviews and commands, but which ones really matter to you? How do you trend and alert on them?
    MongoDB Tools and Techniques Monitoring
  • 11:30am to 12:20pm
    Ballroom H
    • Operations
    Ben Mildren (DigitalOcean)
    Percona Monitoring and Management (PMM) is a wonderful solution, it aims to provide out of the box monitoring and management for your MySQL (and/or MongoDB) environment.
    MySQL Devops Monitoring
  • 1:20pm to 1:45pm
    Room 209
    • Operations
    Michael Coburn (Percona), Roma Novikov (Percona)
    Troubleshooting performance issues can be a bit tricky, especially when you’re given a broad statement that the database is slow. Learn to direct your attention to the correct moving pieces and fix what needs your attention. Learn how all this is done at Percona, what we monitor and track, and the tools we use.
    MySQL Tools and Techniques Monitoring
  • 2:20pm to 3:10pm
    Ballroom A
    • Business / Case Studies
    Jeremy Tinley (Etsy.com), John Cesario (Square, INC), Ryan Lowe (Square, Inc.)
    Capacity planning is hard. It’s even harder if you want to do it right. One of the industry’s dirty little secrets is that in today’s computing climate, there are few organizations for whom the benefits of formal and rigorous capacity planning outweigh the costs.
    Fundamentals Metrics Monitoring
  • 3:50pm to 4:40pm
    Ballroom H
    • Operations
    Kyle Hailey (Amazon)
    Today’s digital businesses depend more and more on databases in the cloud as a core foundation to their applications. Performance of mission-critical databases is crucial for the success of these businesses, yet businesses face challenges identifying database performance issues due to lack of visibility into database performance in the cloud.
    Optimization Data in the Cloud Monitoring

4:50pm to 5:15pm

  • 4:50pm to 5:15pm
    Ballroom E
    • Business / Case Studies
    Charity Majors (Honeycomb)
    Do you feel like you know everything going on in the fast-moving field of monitoring, instrumentation and observability? Of course you don't: nobody does! But here's where to start.
    Monitoring
  • 4:50pm to 5:15pm
    Ballroom F
    • Operations
    David Gildeh (Dataloop)
    At Dataloop.IO, we needed to adopt a new TSDB to hold billions of time series metrics for our SaaS monitoring tool. This talk will look into the performance, pros and cons of each of the top open-source TSDBs and why we decided to adopt Dalmatimer DB at Dataloop.IO.
    Devops Tools and Techniques Time Series

5:15pm to 5:40pm

  • 5:15pm to 5:40pm
    Ballroom E
    • Business / Case Studies
    • Developer
    Baron Schwartz (VividCortex)
    In this talk you'll learn how we store and analyze time series data efficiently at VividCortex, using MySQL and Redis as a storage engine. VividCortex's time series workload presents interesting and unusual challenges that most conventional time series databases don't handle well, at a speed and volume that is also unusual.
    MySQL Time Series Metrics
  • 5:15pm to 5:40pm
    Room 204
    • Operations
    • Developer
    Jesse White (The OpenNMS Group Inc.)
    Today's datasets are growing at an exponential rate. Collection, storage, analysis, and reporting are becoming more challenging, and the results more valued. A decade ago, RRDTool's algorithms were well suited to our requirements, but they fall short of scaling to current demands.
    Time Series NoSQL Metrics
  • 1:00pm to 1:50pm
    Room 204
    • Developer
    Chris Larsen (Yahoo Inc.)
    This talk will cover the special case of time series data and the evolution of various schemas from RRD files to RDBMS schemas to NoSQL stores. Particularly we'll focus on why, as the amount of time series data grows and slicing the data by various dimensions becomes important, many users eschewed RDBMS for NoSQL or custom data layers.
    Other OSDB Time Series Metrics

4:30pm to 4:55pm

  • 4:30pm to 4:55pm
    Ballroom B
    • Developer
    Dmitry Andreev (Yandex LLC)
    ClickHouse is more than just a great «House» for analytics. It can also be used as data storage for Graphite. So, I will explain to you why we decided to try ClickHouse as time-series storage for Graphite despite other existing options (Whisper, Ceres, etc.) And we loved it. Still ClickHouse couldn’t provide for all needs of Graphite (for example, metric search).
    Other OSDB Optimization Time Series
  • 4:30pm to 4:55pm
    Room 210
    • Business / Case Studies
    Qiumin Xu (Samsung)
    The storage subsystem has undergone tremendous innovation in order to keep up with the ever-increasing demand for throughput. Non Volatile Memory Express (NVMe) based solid state devices are the latest development in this domain, delivering unprecedented performance in terms of latency and peak bandwidth.
    NoSQL Metrics Monitoring
  • 5:00pm to 5:25pm
    Room 204
    • Operations
    David Gildeh (Dataloop)
    A time-series database is a core component to building a monitoring service. Its needs to be: scalable to handle all of the data coming into the system, able to support complex queries for different data visualisations, and reliable enough to support our alerting services. For the past year we have been running DalmatinerDB in production.
    Devops Time Series Monitoring

11:00am to 11:50am

  • 11:00am to 11:50am
    Ballroom H
    • Operations
    Brett Bertocci (Sysdig)
    I hate to say it, but there’s a lot of bad advice out there on how to monitor your containers in production. In this talk I hope to add some much-needed clarity on how to best monitor containers to manage the health of your applications.
    Devops Metrics Monitoring
  • 11:00am to 11:50am
    Room 204
    • Operations
    • Developer
    Andrew Moore (Percona)
    Today we administer so much data. From traditional RDBMS and NoSQL data. Then there is all the data from stack traces, messages in log files, and that's before we start to consider all the noise that IoT presents to us. Join me as I show you how you can bring this all together with Elastic Stack.
    Tools and Techniques Monitoring

1:50pm to 2:40pm

  • 1:50pm to 2:40pm
    Ballroom C
    • Operations
    • Developer
    Dimitri KRAVTCHUK (Oracle)
    This session will be interesting to everyone looking for the latest news about MySQL Performance: - Overview of progress in MySQL Performance - The latest benchmark results obtained on the current MySQL dev version -vs- others - The latest improvements made in MySQL/InnoDB design, resolved contentions, new features and solutions - The latest findings in MySQL Performance tuning, workaround
    MySQL Tools and Techniques Monitoring
  • 1:50pm to 2:40pm
    Ballroom G
    • Developer
    Stefan Negrea (RedHat )
    Hawkular Metrics is a scalable, long-term, high performance storage engine for metric data. This session is an overview of the project that includes: history of the project, an overview of the Hawkular ecosystem, technical details of the project, developer features & APIs, and third party integrations.
    Tools and Techniques Time Series Metrics
  • 1:50pm to 2:40pm
    Room 203
    • Operations
    • Developer
    Björn Rabenstein (SoundCloud Ltd.)
    Prometheus is an open-source monitoring and alerting system that has quickly gained popularity over the last two years (which includes sophisticated monitoring of MySQL database servers). One of the components of Prometheus is a time-series database (TSDB) embedded into the monitoring server. The TSDB uses a highly domain-specific query language called PromQL.
    Other OSDB Time Series Metrics
  • 1:50pm to 2:40pm
    Room 209
    • Operations
    • Developer
    Janis Griffin (SolarWinds, Inc)
    MySQL query tuning is often more art than science and it can quickly eat up a lot of time.
    MySQL Optimization Monitoring
  • 3:00pm to 3:50pm
    Room 209
    • Operations
    • Wildcard
    Alawi Assaggaf (Fuze)
    Every DBA needs to be on top of the health status of all DB servers and their current configuration. However, there are many different solutions out there that are either costly, or simply do not provide all the options and features you are looking for.
    MySQL Metrics Monitoring