PMM monitoring MySQL

First, Pmm-server1. Installing Docker

yum install -y docker-io

2. Pull Pmm-server Image

docker pull percona/pmm-server:latest

3. Create a persistence container

docker create    -v /opt/prometheus/data    -v /opt/consul-data    -v /var/lib/mysql    -v /var/lib/grafana    --name pmm-data    percona/pmm-server:latest /bin/true

4. Start Pmm-server

docker run -d    -p 8888:80 \     #将docker的80端口映射到宿主机的8888端口   --volumes-from pmm-data    --name pmm-server    --restart always    percona/pmm-server:latest

View Run status

[[email protected] ~]# docker ps -aCONTAINER ID        IMAGE                       COMMAND                CREATED             STATUS              PORTS                           NAMES983cb32aa7ca        percona/pmm-server:latest   "/opt/entrypoint.sh"   4 days ago          Up 4 days           443/tcp, 0.0.0.0:8888->80/tcp   pmm-server          670aaeb497cf        percona/pmm-server:latest   "/bin/true"            4 days ago                                                              pmm-data    

5. Turn off anonymous login and adjust the time zone

[[email protected] docker]# docker exec -it pmm-server /bin/bash    #进入docker容器[[email protected] opt]# vi /etc/grafana/grafana.ini#################################### Anonymous Auth ##########################[auth.anonymous]# enable anonymous access#enabled = True[[email protected] opt]# cat /etc/localtime TZif2UTCTZif2UTCUTC0[[email protected] opt]# cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime cp: overwrite ‘/etc/localtime‘? y

6. Login Dashboard

In the browser, enter: xx.xx.xx.xx:8888

Second, Pmm-client1. Install Pmm-client on machines that need to be monitored

yum install http://www.percona.com/downloads/percona-release/redhat/0.1-6/percona-release-0.1-6.noarch.rpm   #配置percona源yum install pmm-client #安装pmm-client

2. Configure Pmm-server Address

--server followed by the address and port of Pmm-server
-C followed by the configuration file, the default configuration file is/usr/local/percona/pmm-client/pmm.yml

pmm-admin config --server xx.xx.xx.xx:8888 -c /usr/local/percona/pmm-client/pmm.yml             

The following is the contents of the configuration file

cat /usr/local/percona/pmm-client/pmm.ymlserver_address: xx.xx.xx.xx:8888client_address: xx.xx.xx.xxbind_address: xx.xx.xx.xxclient_name: monitor-node1

3. Adding Linux system monitoring

4. Add MySQL Monitor

To create a monitoring user in a MySQL instance:

GRANT SELECT, PROCESS, SUPER, REPLICATION CLIENT, RELOAD ON *.* TO ‘pmm‘@‘127.0.0.1‘ IDENTIFIED BY ‘pmm‘ WITH MAX_USER_CONNECTIONS 10;GRANT SELECT, UPDATE, DELETE, DROP ON performance_schema.* TO ‘pmm‘@‘127.0.0.1‘;

Add MySQL Monitor

pmm-admin add mysql --host 127.0.0.1 --user pmm --password pmm --port 3306 instance3306   ##此命令是监控MySQL实例状态以及慢查询分析，如果不想监控慢日志使用mysql:metrics即可

Iii. problems encountered in 1. Purge error

A machine offline, you need to clean the pmm-server in the data about this machine, the execution of purge command after the error

[[email protected] ~]# pmm-admin purge linux:metricspanic:interface conversion:interface {} is nil, not map[string] interface {}goroutine 1 [running]:github.com/percona/pmm-client/pmm. (*admin). Purgemetrics (0xbe4e60, 0x7ffc82a0674b, 0xd, 0xc4201f68b8, 0xc4201abb68, 0x7ff262)/tmp/go/src/github.com/percona/ pmm-client/pmm/main.go:427 +0x5a4main.glob. Func39 (0xbde460, 0xc4200a1730, 0x1, 0x1)/tmp/go/src/github.com/percona/pmm-client/pmm-admin.go:1179 + 0xd1github.com/percona/pmm-client/vendor/github.com/spf13/cobra. (*command). Execute (0xbde460, 0XC4200A16E0, 0x1, 0x1, 0xbde460, 0XC4200A16E0)/tmp/go/src/github.com/percona/ pmm-client/vendor/github.com/spf13/cobra/command.go:654 +0x2a2github.com/percona/pmm-client/vendor/github.com/ Spf13/cobra. (*command). Executec (0xbdeb20, 0xc4201abdd0, 0x49b302, 0x0)/tmp/go/src/github.com/percona/pmm-client/vendor/github.com/spf13/ cobra/command.go:729 +0x2d4github.com/percona/pmm-client/vendor/github.com/spf13/cobra. (*command). Execute (0xbdeB20, 0xc0263c, 0x92bf0f)/tmp/go/src/github.com/percona/pmm-client/vendor/github.com/spf13/cobra/command.go:688 + 0x2bmain.main ()/tmp/go/src/github.com/percona/pmm-client/pmm-admin.go:1398 +0X18DC

Suspected as a bug, the official table name will be fixed in a later version: https://jira.percona.com/browse/PMM-2894

2. _PMM System Summary Panel cannot display MySQL information summary

The error is as follows:

Server summary:mysql summary - Exit Status 1

Workaround: Soft-connect MySQL-related commands to/usr/bin/

ln -s /usr/local/mysql/bin/* /usr/bin/

Reference Address: https://www.percona.com/forums/questions-discussions/percona-monitoring-and-management/47268- Server-summary-mysql-summary-exit-status-1

PMM monitoring MySQL