Getting Started with PMM2

Hi,

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?

Thanks,

Bryan

1 Like

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 --environment and --replication-set as it improves the usefulness of some dashboards when you have many MySQL instances:

2 Likes

Thanks! I’ll try that.

1 Like