Mysql监控系统PMM

pmm install

# docker install 

curl -sSL https://get.daocloud.io/docker | sh


# 创建PMM数据容器

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

# 创建PMM服务器容器, 同时设置登录用户名(SERVER_USER)和密码(SERVER_PASSWORD), 根据需要进行修改. 默认使用80端口, 如果需要可以更改.

docker run -d -p 80:80 \
  --volumes-from pmm-data \
  --name pmm-server \
  -e SERVER_USER=admin \
  -e SERVER_PASSWORD=JF*(Sd)D8iaDLdc \
  --restart always \
  percona/pmm-server:latest

# timezone

docker cp /etc/localtime pmm-server:/etc/localtime

#  percona repo

sudo yum install http://www.percona.com/downloads/percona-release/redhat/0.1-6/percona-release-0.1-6.noarch.rpm

# pmm-client

sudo yum install pmm-client

# pmm-client connect server

pmm-admin config --server 127.0.0.1:80 --server-password JF*(Sd)D8iaDLdc --server-user admin

# monitor DB

pmm-admin add mysql --user root --password gtl1023 --host 10.138.0.24 instances-falcondb