I’m looking at installing Percona Monitoring and Management (PMM) to monitor my MySQL Databases. What does PMM use as it’s backend to store the data? (MySQL etc). At present we have various packages on our network used by different departments to monitor different areas of the business (e.g. zabbix to monitor the physical servers etc), and I am looking for something that I can implement for our databases as the company grows.
We also have an in house system that reads data from these different systems to provide a very high level output that is suitable for customer consumption. As a consequence I would need this system to be able to tap into the PMM data to pull out high level summaries. Ideally therefore it would be in a MySQL database.
PMM uses multiple databases to store data, however the two most important databases are Prometheus and MySQL. We use Prometheus to store the time series metrics data that powers our dashboards, and MySQL stores the Query Analytics data.
We don’t expose the MySQL port outside of the docker container, but you can do this when you start the instance with an additional -p 3306:3306, and configure a MySQL user in order to access the Query Analytics data.
Can you tell me which systems you expect will read into PMM? If it is an off the shelf product we might be able to look into some sort of integration, so that you don’t need to write all the lines of code yourself.