思路
基础环境及软件
- centos7
- filebeat
- logstash
- elasticsearch
- python
- elastalert
部署
filebeat 相关配置
使用filebeat自带mysql模板
filebeat.config.modules:
# Glob pattern for configuration loading
path: ${path.config}/modules.d/*.yml
# Set to true to enable config reloading
reload.enabled: true
对应如上修改就是将上一行修改false 为 true
修改对应路径下的 /etc/filebeat/modules.d/mysql.yml.disabled 为 mysql.yml
添加mysql 慢日志路径
slowlog:
enabled: true
# Set custom paths for the log files. If left empty,
# Filebeat will choose the paths depending on your OS.
var.paths: ["/root/slow-queries.log"]
logstash 相关配置
日志结构:
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 2678308 Schema: express QC_hit: No
# Query_time: 11.785439 Lock_time