canal mysql mongodb_使用Percona2监控MongoDB,MySQL

1. server端

下载镜像:

[root@hlet-prod-k8s-rancher ~]# docker pull percona/pmm-server:2 # 下载镜像

Pulling from percona/pmm-server

524b0c1e57f8: Pull complete

e69c94edc13d: Pull complete

Digest: sha256:799651e0715f106a92632072eb34a350a2f25630622dda0680987fa13b4fd396

Status: Downloaded newer image for percona/pmm-server:2

docker.io/percona/pmm-server:2

查看端口,由于80,443端口已经被占用,这里使用8080,8443端口

[root@hlet-prod-k8s-rancher ~]# netstat -nptl

Active Internet connections (only servers)

Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name

tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 1765/sshd

tcp 0 0 127.0.0.1:40450 0.0.0.0:* LISTEN 20377/node

tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN 1/systemd

tcp6 0 0 :::5557 :::* LISTEN 25413/docker-proxy

tcp6 0 0 :::22 :::* LISTEN 1765/sshd

tcp6 0 0 :::443 :::* LISTEN 10107/docker-proxy

tcp6 0 0 :::8001 :::* LISTEN 25577/docker-proxy

tcp6 0 0 :::111 :::* LISTEN 1499/rpcbind

tcp6 0 0 :::80 :::* LISTEN 10122/docker-proxy

创建数据卷

[root@hlet-prod-k8s-rancher ~]# docker create \

\> -v /srv \

\> --name pmm-data \

\> percona/pmm-server:2 /bin/true

f6f0d8e27098e376f9156711c5eb3db77049a4c18f7a30a546be6ab4ec381305 # 创建数据卷

运行server的镜像并挂载数据卷

[root@hlet-prod-k8s-rancher ~]# docker run -d \

\> -p 8080:80 \

\> -p 8443:443 \

\> --volumes-from pmm-data \

\> --name pmm-server \

\> --restart always \

\> percona/pmm-server:2

7b2ed49138407e75962e0a56a573e83882cc4f72636a107d1f28e70b0895e1d9 # 运行pmm server并挂载数据卷

查看是否部署成功:

[root@hlet-prod-k8s-rancher ~]# docker ps

CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES

7b2ed4913840 percona/pmm-server:2 "/opt/entrypoint.sh" 16 seconds ago Up 16 seconds (healthy) 0.0.0.0:8080->80/tcp, 0.0.0.0:8443->443/tcp pmm-server

047eac0cc3e4 rancher/rancher:v2.4.5 "entrypoint.sh" 2 weeks ago Up 2 weeks 0.0.0.0:80->80/tcp, 0.0.0.0:443->443/tcp unruffled_tesla

b956d530ede2 styletang/rocketmq-console-ng "sh -c 'java $JAVA_O…" 2 weeks ago Up 2 weeks 0.0.0.0:8001->8080/tcp reverent_ellis

434ae88e371d 10.1.99.42/monitor/rocketmq-exporter:latest "java -jar quickstar…" 2 weeks ago Up 2 weeks 0.0.0.0:5557->5557/tcp relaxed_kalam

尝试访问:

[root@hlet-prod-k8s-rancher ~]# curl --insecure https://10.1.99.50:8443/swagger/ # 测试服务是否启动完成

初始化server:

访问http://10.1.99.50:8080/graph/ 或者https://10.1.99.50:8443/graph/,默认初始用户名和密码均为admin,登陆后会要求重置密码

2.client端

2.1 安装

这里我们MongoDB和mysql的服务器都是基于centos的,yum或rpm方式选一种即可

yum方式安装:

yum install -y https://repo.percona.com/yum/percona-release-latest.noarch.rpm

yum install pmm2-client -y

如果下载太慢的话,也可以直接下载rpm包来安装,地址:

https://repo.percona.com/yum/release/2/RPMS/x86_64/pmm2-client-2.8.0-6.el7.x86_64.rpm

rpm方式安装:

rpm -ivh /home/pmm2-client-2.8.0-6.el7.x86_64.rpm

2.2 初始化

向PMM server注册当前节点:

这里url需要根据情况填写自己初始化的PMM server的密码

pmm-admin config --server-insecure-tls --server-url=https://admin:'yourpassword'@10.1.99.50:8443

如果想在注册的时候需要指定node name,可以参考

Positional arguments:

[] Node address (autodetected default: 10.1.30.35)

[] Node type, one of: generic, container (default: generic)

[] Node name (autodetected default: localhost.localdomai