ubuntu pmm安装配置监控MySQL

1. PMM 的 SERVER端需要有DOCKER支持,安装DOCKER:

root@ubuntu:~# apt-get install docker.io
root@ubuntu:~# service docker status
docker start/running, process 2746

2. 创建数据容器:

root@ubuntu:~# docker create    -v /opt/prometheus/data    -v /opt/consul-data    -v /var/lib/mysql    -v /var/lib/grafana    --name pmm-data    percona/pmm-server:1.1.2 /bin/true
Unable to find image 'percona/pmm-server:1.1.2' locally
1.0.7: Pulling from percona/pmm-server
7e671841de32: Pull complete 
67282acf791c: Pull complete 
7b74716dd91c: Pull complete 
c43b458dbeb1: Pull complete 
9ba8cf8f5164: Pull complete 
2a4fcb055224: Pull complete 
eb3887a931e5: Pull complete 
e9d1a8cff0ad: Pull complete 
451f471aafac: Pull complete 
015ab4ad0316: Pull complete 
8fd288f53199: Pull complete 
02f3bb9387ba: Pull complete 
3aa1a10c3417: Pull complete 
7c167ae7a6a7: Pull complete 
7c167ae7a6a7: Pulling fs layer 
bb04ed60c038: Already exists 
0812a82a4eba: Already exists 
f6662ef795ac: Already exists 
39a955bdc1e1: Already exists 
348ae5f2350a: Already exists 
d61c7e9067e9: Already exists 
78a58c16256c: Already exists 
4dd18e76374e: Already exists 
dba2d32d5bd1: Already exists 
977d24c6a914: Already exists 
642e729d446f: Already exists 
Digest: sha256:2c980ce9c1b5218592b61c4fc2ea8552798ce9cbb870be0faa42b430f715770b
Status: Downloaded newer image for percona/pmm-server:1.1.2
e3fb255bb95b2a89f7f935f53d4f94cf218324a8d8ad836bd5788929ba540970

这里的下载可谓是一波三折,  下载了两天才下载下来,不停的失败,不停的重启下载, 那么我们换一个环境去安装是否是又要下载一次?  答案是否定的,  docker为用户提供了镜像导出导入功能:

2.1 将下载的镜像保存为文件:

root@ubuntu:~# docker images
REPOSITORY           TAG                 IMAGE ID            CREATED             VIRTUAL SIZE
percona/pmm-server   1.1.2               6a00bad79251        4 weeks ago         1.12 GB
root@ubuntu:~# docker save -o pmm1.1.2.tar percona/pmm-server 
root@ubuntu:~# ls -ltrh
total 1.1G
-rw-r--r-- 1 root root 1.1G May  4 11:54 pmm1.1.2.tar

2.2 导入文件:

root@ubuntu:~# docker load < pmm1.1.2.tar 
root@ubuntu:~# docker images
REPOSITORY           TAG                 IMAGE ID            CREATED             VIRTUAL SIZE
percona/pmm-server   1.1.2               6a00bad79251        4 weeks ago         1.12 GB

2.3 创建数据容器:

root@ubuntu:/var/lib/docker# docker create    -v /opt/prometheus/data    -v /opt/consul-data    -v /var/lib/mysql    -v /var/lib/grafana    --name pmm-data    percona/pmm-server:1.1.2 /bin/true
75843b84aafe561fdf7fa8934c11f2b8998bdd719cb38e753a695e950e3bc470

2.4 运行数据容器,在启动时注意名字, 不要重复:

root@ubuntu:/var/lib/docker# docker run -d       -p 80:80       --volumes-from pmm-data       --name pmm-server_t       --restart always       percona/pmm-server:1.1.2
66060b025cdd8c0d299ba320a281a9ae73613095f1e8300069168fef0bb4c243
root@ubuntu:/var/lib/docker# docker ps
CONTAINER ID        IMAGE                      COMMAND                CREATED             STATUS              PORTS                         NAMES
66060b025cdd        percona/pmm-server:1.1.2   "/opt/entrypoint.sh"   22 seconds ago      Up 5 seconds        0.0.0.0:80->80/tcp, 443/tcp   pmm-server_t     

 

3. 运行PMM SERVER:

root@ubuntu:~# docker run -d \
>       -p 80:80 \
>       --volumes-from pmm-data \
>       --name pmm-server \
>       --restart always \
>       percona/pmm-server:1.1.2
59a3dbd69635a0b3ca21a20c5cbdd7894816fe5d5db8c2163fe93496520737c9

4. 查看DOCKER运行状态:

root@ubuntu:~# docker ps
CONTAINER ID        IMAGE                      COMMAND                CREATED             STATUS              PORTS                         NAMES
59a3dbd69635        percona/pmm-server:1.1.2   "/opt/entrypoint.sh"   27 seconds ago      Up 25 seconds       0.0.0.0:80->80/tcp, 443/tcp   pmm-server

  

访问页面测试:


5. 客户端安装PMM-CLIENT:

https://www.percona.com/downloads/pmm-client/pmm-client-1.1.2/binary/debian/trusty/x86_64/pmm-client_1.1.2-1.trusty_amd64.deb
dpkg -i pmm-client_1.1.2-1.trusty_amd64.deb

 数据库授权:

mysql> grant process,super,select on *.* to monitor@'192.168.137.%' identified by 'monitor_2017';
Query OK, 0 rows affected (1.50 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.03 sec)

6. 在PMM SERVER端添加MYSQL主机:

 

pmm-admin add mysql --user monitor --password monitor_2017 --host 192.168.137.9 --port 3306
[linux:metrics] OK, already monitoring this system.
[mysql:metrics] OK, now monitoring MySQL metrics using DSN monitor:***@tcp(192.168.137.9:3306)
[mysql:queries] OK, now monitoring MySQL queries from slowlog using DSN monitor:***@tcp(192.168.137.9:3306)

 

root@ubuntu:~# pmm-admin list
pmm-admin 1.1.2

PMM Server      | 192.168.137.9 
Client Name     | ubuntu
Client Address  | 192.168.137.9 
Service Manager | linux-upstart

-------------- ------- ----------- -------- ------------------------------------ ------------------------------------------
SERVICE TYPE   NAME    LOCAL PORT  RUNNING  DATA SOURCE                          OPTIONS                                   
-------------- ------- ----------- -------- ------------------------------------ ------------------------------------------
mysql:queries  ubuntu  -           YES      monitor:***@tcp(192.168.137.9:3306)  query_source=slowlog, query_examples=true 
linux:metrics  ubuntu  42000       YES      -                                                                              
mysql:metrics  ubuntu  42002       YES      monitor:***@tcp(192.168.137.9:3306)                                          

完成安装配置, 可以去检查监控项了。

 

posted @ 2017-05-04 15:22 SMALL-D 阅读(...) 评论(...) 编辑 收藏