I installed the server and registered my first client, but I’m having problems finding/understanding the setup moving forward. For example, after registering the client, I see OS metrics, but not MySQL metrics. I can create an instance, using the UI which will report the database info, but I now have 2 instances within the UI. Is there a way to add the MySQL credentials to the pmm client yaml, or is it standard to have 2 instances, one for OS metrics, the other Database? Is there a comprehensive how-to document someplace?
Hi @bdees , welcome to the Percona forums!
I find the quickstart guide to be very helpful in terms of setting up hosts and clients such as MySQL:
First create a user in MySQL to be used for monitoring:
CREATE USER 'pmm'@'localhost' IDENTIFIED BY 'pass' WITH MAX_USER_CONNECTIONS 10;
GRANT SELECT, PROCESS, SUPER, REPLICATION CLIENT, RELOAD, BACKUP_ADMIN ON *.* TO 'pmm'@'localhost';
Then add the MySQL instance to PMM using
pmm-admin command line interface:
sudo pmm-admin add mysql --username=pmm --password=<password> --query-source=perfschema
See the full list of options available - for example I recommend you include the optional flags
--replication-set as it improves the usefulness of some dashboards when you have many MySQL instances: