Mykola joined Percona in 2016 as a release engineer. He has been developing monitoring systems since 2004, and has been working as Release Engineer/Release Manager/DevOps for ten years.
Recently, Mykola achieved an AWS Certified Solutions Architect (Professional) authentication.
Percona Monitoring and Management (PMM) is a free and open-source solution for managing and monitoring MySQL and MongoDB performance. It provides accurate per-second analysis for MySQL and MongoDB servers, which allows you to tune the database as efficiently as possible.
This session will also be a review of internal PMM architecture, an overview of all components, and the communications between them.
Troubleshooting the database-related problems turns out to be not a simple task even if you run your database on-premise. And performance debug can become a nightmare when you run it as a managed service in AWS/GCP/Azure, because you have no access to the underlying OS, and series of DB metrics gathered by your monitoring solution is the only subject you have to explore.
The talk will make an overview of a monitoring possibilities available for MySQL/PostgreSQL managed database in case of AWS, GCP, and Azure cloud providers. We will review what monitoring data can be gathered, speak about data granularity, and discuss ways to export these metrics to Prometheus for their simplified representation and wide/complex troubleshooting analysis of the whole instance.