Skip to content
高进波的博客

Mysql监控

MySQL Enterprise Monitor（MEM）

  • 官网地址：https://edelivery.oracle.com/
  • 服务端
    • 安装依赖：apt install libaio-dev libtinfo-dev -y
    • 建立软链接：ln -s /usr/lib/x86_64-linux-gnu/libtinfo.so.6.1 /usr/lib/x86_64-linux-gnu/libtinfo.so.5
    • 解压文件：unzip V1044688-01.zip
    • 安装：./mysqlmonitor-8.0.39.1555-linux-x86_64-installer.bin --mode text
    • 查看状态：/opt/mysql/enterprise/monitor/mysqlmonitorctl.sh status
    • 访问地址：https://192.168.21.204:18443/
  • 监控方式
    1. 通过agent
    2. 通过账号密码，远程连接
    • 说明：监控RDS数据不完整，没有SUPER权限，很多界面无数据
  • 删除
    • 执行：/opt/mysql/enterprise/monitor/uninstall
  • agent安装
    • 解压：unzip V1044691-01.zip
    • 安装：./mysqlmonitoragent-8.0.39.1555-linux-x86-64bit-installer.bin --mode text
    • 安装过程输入：
      • “主机名称或 IP 地址 []: 192.168.21.204
      • Tomcat SSL 端口 [18443]:
      • Agent 用户名称 [agent]:
      • Agent 密码”
    • 参考文档：http://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-agent-rights.html
  • 手动建立账号
    • 账号1：
create user 'agent_user'@'%' identified by 'gaojinbo.com';
GRANT SELECT, CREATE USER, REPLICATION CLIENT, SHOW DATABASES, SUPER, DROP, PROCESS
  ON *.*
  TO  'agent_user'@'%';
GRANT CREATE, DROP, INSERT
  ON mysql.*
  TO  'agent_user'@'%';
  • 账号2：
create user 'agent2'@'%' identified by 'gaojinbo.com';
GRANT SELECT, SHOW DATABASES, EXECUTE, SHOW VIEW ON *.* TO 'agent2'@'%';
GRANT UPDATE ON `performance_schema`.`threads` TO 'agent2'@'%';
  • 账号3：
create user 'agent'@'%' identified by 'gaojinbo.com';
GRANT SELECT, PROCESS, SHOW DATABASES, EXECUTE, REPLICATION CLIENT, SHOW VIEW ON *.* TO 'agent'@'%';
 GRANT UPDATE ON `performance_schema`.`threads` TO 'agent'@'%';
  • 查看权限：show grants for agent2@'%';
  • agent相关操作
    • 启动：/etc/init.d/mysql-monitor-agent start
    • 查看状态：/etc/init.d/mysql-monitor-agent status
    • 删除：/opt/mysql/enterprise/agent/uninstall
  • 支持系统
    • ubuntu24.04
    • debian10

Percona Monitoring and Management（PMM）

Terminal window
wget -c https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb
sudo dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb
sudo apt-get update
sudo apt-get install pmm2-client -y
  • centos/rhel：
Terminal window
yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm
yum install pmm2-client -y
  • 连接到服务端
    • 执行：pmm-admin config --server-insecure-tls --server-url=https://admin:gaojinbo.com@192.168.21.195
  • 建立账号并连接到服务端
    • 建立账号：
CREATE USER 'pmm'@'%' IDENTIFIED BY 'gaojinbo.com' WITH MAX_USER_CONNECTIONS 10;
GRANT SELECT, PROCESS, SUPER, REPLICATION CLIENT, RELOAD ON *.* TO 'pmm'@'%';
  • 添加监控：pmm-admin add mysql --username=pmm --password=gaojinbo.com --query-source=perfschema
  • 列出监控：pmm-admin list
  • 查看状态：pmm-admin status