mysql 监控器_MySQL监控利器-PMM

本篇文章来简要介绍一下MySQL监控利器-PMM的部署过程。

环境：

主机名

IP

功能

系统

数据库版本

pmmclient

192.168.91.34

PMM-client(1.16.0)

RHEL7.4

MySQL5.7.26

pmmserver

192.168.91.35

PMM-server

RHEL7.4

部署：

server端：

[root@pmmserver ~]#yum -y install docker

[root@pmmserver ~]# systemctl start docker

[root@pmmserver ~]# systemctl enable docker

[root@pmmserver ~]# docker pull pmm-server

[root@pmmserver ~]# docker images

REPOSITORY                     TAG                 IMAGE ID            CREATED             SIZE

docker.io/percona/pmm-server   latest              cc8e60d34a15        7 weeks ago         1.2 GB

[root@pmmserver ~]# docker create -v /u02/monitor/prometheus/data -v /u02/monitor/consul-data -v /u02/monitor/lib/mysql -v /u02/monitor/lib/grafana --name pmm-data docker.io/percona/pmm-server:latest

[root@pmmserver ~]# docker run -d -p 80:80 -p 3000:3000 -p 13306:3306 --volumes-from pmm-data --name pmm-server --restart always docker.io/percona/pmm-server:latest

[root@pmmserver ~]# docker ps

CONTAINER ID        IMAGE                                 COMMAND                CREATED             STATUS              PORTS                                                                          NAMES

569aaaca23a1        docker.io/percona/pmm-server:latest   "/opt/entrypoint.sh"   21 hours ago        Up 21 hours         0.0.0.0:80->80/tcp, 0.0.0.0:3000->3000/tcp, 443/tcp, 0.0.0.0:13306->3306/tcp   pmm-server

访问server的IP地址就可以访问了(默认用户名密码：admin)

client端(被监控的服务器上)

[root@pmmclient soft]# ll pmm-client-1.16.0-1.el6.x86_64.rpm

-rw-r--r-- 1 root root 23057592 Dec 18 10:44 pmm-client-1.16.0-1.el6.x86_64.rpm

[root@pmmclient soft]# rpm -ivh pmm-client-1.16.0-1.el6.x86_64.rpm

[root@pmmclient soft]# pmm-admin --version

1.16.0

[root@pmmclient soft]# pmm-admin config --server 192.168.91.35

OK, PMM server is alive.

PMM Server      | 192.168.91.35

Client Name     | master

Client Address  | 192.168.91.34

pmm客户端监控MySQL到pmm服务器

[root@pmmclient soft]# mysql -uroot -pkavl7kAkkle!   建立监控用户

mysql> create user 'pmm_monitor'@'192.168.91.%' identified by 'kavl7kAkkle!';

Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on *.* to 'pmm_monitor'@'192.168.91.%';

Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

[root@pmmclient soft]# pmm-admin config --server 192.168.91.35

OK, PMM server is alive.

PMM Server      | 192.168.91.35

Client Name     | master

Client Address  | 192.168.91.34

[root@pmmclient soft]# pmm-admin add mysql --user pmm_monitor --password kavl7kAkkle! --host 192.168.91.34 --port 3306

[linux:metrics] OK, already monitoring this system.

[mysql:metrics] OK, now monitoring MySQL metrics using DSN pmm_monitor:***@tcp(192.168.91.34:3306)

[mysql:queries] OK, now monitoring MySQL queries from slowlog using DSN pmm_monitor:***@tcp(192.168.91.34:3306)

此时可以在web页面上查看：

如果对PMM有兴趣的朋友可以加博主QQ，大家相互学习相互成长。

QQ：1127000483