526互联

安装pmm(Percona Monitoring and Management)

发布时间 2023-06-15 14:16:16作者: slnngk

环境:
Os:Centos 7
pmm2

####################################服务端安装#######################
服务端安装我们这里使用docker的方式部署
一、server端部署：
1.监控机器安装docker：
ip:192.168.56.101
操作系统版本：
[root@localhost /]# cat /etc/centos-release
CentOS Linux release 7.5.1804 (Core)
安装:
[root@localhost /]#yum install -y docker

启动:
[root@localhost /]#systemctl start docker
[root@localhost /]#systemctl enable docker

 

2.拉取PMM服务器映像
[root@localhost /]# docker pull percona/pmm-server:2
Trying to pull repository docker.io/percona/pmm-server ...
2: Pulling from docker.io/percona/pmm-server
2d473b07cdd5: Pull complete
53d9fefd2a3f: Pull complete
Digest: sha256:b80df76e70255d8399e2cfdd37c7d493958e457ccb3bbc123e17efc985cd266b
Status: Downloaded newer image for docker.io/percona/pmm-server:2

 

3.创建一个PMM数据容器:
[root@localhost /]#docker create -v /opt/prometheus/data -v /opt/consul-data -v /var/lib/mysql -v /var/lib/grafana --name pmm-data percona/pmm-server:2 /bin/true


4.创建和运行 PMM Server Container:
[root@localhost /]#docker run -d -p 80:80 -p 443:443 --volumes-from pmm-data --name pmm-server --restart always percona/pmm-server:2

这里需要指定端口映射-p 443:443,pmm客户端需要改端口注册到pmm服务器


5. 查看 Docker 运行状态
[root@localhost /]# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
e18cf4366179 percona/pmm-server:2 "/opt/entrypoint.sh" 30 seconds ago Up 27 seconds (healthy) 0.0.0.0:80->80/tcp, 0.0.0.0:443->443/tcp pmm-server

 

6.登录
http://192.168.1.136:80
默认的账号密码为:admin/admin,初次登录修改密码,为这里修改为admin123

有些浏览器报如下的错误

If you're seeing this Grafana has failed to load its application files
1. This could be caused by your reverse proxy settings.
2. If you host grafana under subpath make sure your grafana.ini root_url setting includes subpath. If not using a reverse proxy make sure to set serve_from_sub_path to true.
3. If you have a local dev build make sure you build frontend using: yarn start, yarn start:hot, or yarn build
4. Sometimes restarting grafana-server can help
5. Check if you are using a non-supported browser. For more information, refer to the list of supported browsers.

 

#################################客户端安装######################
1.下载pmm-client
登录https://www.percona.com/downloads/pmm-client下载客户端
我这里下载的是pmm2-client-2.12.0-6.el7.x86_64.rpm
2.12版本之后的不提供centos6的安装包

 

2.安装
[root@cdc-henan-cdhworker01 soft]# rpm -ivh pmm2-client-2.12.0-6.el7.x86_64.rpm
centos 6的安装
rpm -ivh pmm2-client-2.12.0-6.el6.x86_64.rpm

 

3.这个时候有相应的命令了
[root@cdc-henan-cdhworker01 soft]# pmm-admin --version
ProjectName: pmm-admin
Version: 2.12.0
PMMVersion: 2.12.0
Timestamp: 2020-12-01 11:57:04 (UTC)
FullCommit: e81fe912b1029095f310945f831abc71c824e139

 

4.注册到server
[root@cdc-henan-cdhworker01 soft]# pmm-admin config --server-insecure-tls --server-url=https://admin:admin123@192.168.1.136:443
1)192.168.1.136 is the address of your PMM Server.
2)443是默认端口，如果之前docker安装server改了端口请仔细修改保证对应
3)admin/adminPassword 是登录PMM Server页面的用户名密码


5.mysql创建监控用户
grant select,process,super,replication client, reload on *.* to 'pmm'@'%' identified by 'mysql';


6.添加mysql实例
[root@cdc-henan-cdhworker01 soft]# pmm-admin add mysql --username pmm --password 'mysql' mysql-192.168.1.197_3306 192.168.1.197:3306
MySQL Service added.
Service ID : /service_id/76579b88-4947-4916-87fd-964fd4e6ceee
Service name: mysql-192.168.1.197_3306

Table statistics collection disabled (the limit is 1000, the actual table count is 2466).

 

7.查看状态

pmm-admin list
pmm-admin status

 

[root@dev-env-22 soft]# pmm-admin list
Service type                Service name                        Address and port       Service ID
MySQL                       mysql-192.168.1.22_3306             192.168.1.22:3306      /service_id/7038ae6c-7d44-4c67-9b2e-5f345af984a5

Agent type                  Status     Metrics Mode   Agent ID                                      Service ID
pmm_agent                   Connected    /agent_id/80fa91ee-300f-4a54-8352-faffea65ca55  
node_exporter               Running    push  /agent_id/c6a3061f-6bea-4b68-9b92-f43364451e6c  
mysqld_exporter             Running    push  /agent_id/45508fb2-2242-4c86-b861-2d23aa21e25b /service_id/7038ae6c-7d44-4c67-9b2e-5f345af984a5 
mysql_slowlog_agent         Running      /agent_id/8253c94c-04be-4908-b424-4d5826ab4c0d /service_id/7038ae6c-7d44-4c67-9b2e-5f345af984a5 
vmagent                     Running    push  /agent_id/410b0748-8260-4ea2-af0e-bf8d8c1c5839

[root@dev-env-22 soft]# pmm-admin status
Agent ID: /agent_id/80fa91ee-300f-4a54-8352-faffea65ca55
Node ID : /node_id/d01f7d5b-8cb4-4c60-9633-2fd4c81f29d9

PMM Server:
        URL    : https://192.168.1.136:443/
        Version: 2.37.1

PMM Client:
        Connected        : true
        Time drift       : -4.526555ms
        Latency          : 575.663μs
        pmm-admin version: 2.12.0
        pmm-agent version: 2.12.0
Agents:
        /agent_id/410b0748-8260-4ea2-af0e-bf8d8c1c5839 vmagent Running
        /agent_id/45508fb2-2242-4c86-b861-2d23aa21e25b mysqld_exporter Running
        /agent_id/8253c94c-04be-4908-b424-4d5826ab4c0d mysql_slowlog_agent Running
        /agent_id/c6a3061f-6bea-4b68-9b92-f43364451e6c node_exporter Running