使用Metricbeat 模块mysql,可以直接从 MySQL 服务器提取内部指标。通过kibana面板的引导直接下载配置就可,但是如果要监测insert/update语句的数量还需要修改mysql.yml文件。
- 下载并安装 Metricbeat
curl -L -O https://artifacts.elastic.co/downloads/beats/metricbeat/metricbeat-7.4.0-x86_64.rpm
sudo rpm -vi metricbeat-7.4.0-x86_64.rpm
- 编辑配置
vim /etc/metricbeat/metricbeat.yml
output.elasticsearch:
hosts: ["localhost:8090"]
setup.kibana:
host: "<localhost:8080>"
** 修改过默认端口
- 启用和配置 mysql 模块
(修改相关配置)
vim /etc/metricbeat/modules.d/mysql.yml
hosts: ["tcp(172.16.90.180:3306)/"]
# Username of hosts. Empty by default.
username: root
# Password of hosts. Empty by default.
password: secret
sudo metricbeat modules enable mysql
- 启动 Metricbeat
sudo metricbeat setup
sudo service metricbeat start