Скачать или смотреть How to install and configure PMM | MySQL Replication Course

MySQL Replication Full Course only at $12.99 :
https://www.udemy.com/course/mysql-re...

Setting up PMM Server
Install docker
Run PMM Server as a Docker image
Setting up PMM Clients
pmm-admin config
adding a new monitoring instance

SHOW VARIABLES LIKE 'performance_schema';

select * from performance_schema.setup_consumers;

SET GLOBAL innodb_monitor_enable=all

CREATE USER 'pmm'@'%' IDENTIFIED WITH mysql_native_password by 'Welc0me1!';
Grant All privileges on . TO 'pmm'@'%';

pmm-admin config --server-insecure-tls --server-url=https://admin:[email protected]:443 192.168.70.10

pmm-admin add mysql mysql1 --query-source=perfschema --username=pmm --password=Welc0me1!

Please Follow me on Social Media
Linkedin:   / mughees-ahmed-oracle-mysql-dba-287214122  
Twitter:   / mughees52  
Facebook:   / mughees52