Simple Filebeat module for parsing ProxySQL logs and ship them to ElasticSearch
How to use:
- Copy module (
proxysql
folder from this repository) to the/usr/share/filebeat/module
folder - Create a file
/etc/filebeat/modules.d/proxysql.yml
with content:
# Module: proxysql
# Docs: https://github.com/altuhovsu/filebeat-proxysql-module
- module: proxysql
# Error logs
error:
enabled: true
# Set custom paths for the log files. If left empty,
# Filebeat will choose the paths depending on your OS.
#var.paths:
- systemctl restart filebeat
- Check in the Kibana Discover for
event.module :"proxysql"
Notes:
- Lines like
[INFO]
andClosing unhealthy client connection
will be ignored (exclude_lines: ['.*\[INFO\].*', '.*Closing unhealthy client connection.*']
) - default log file path:
/var/lib/proxysql/proxysql.log
To Do:
- Create a proper module structure (like described in the guide https://www.elastic.co/guide/en/beats/devguide/current/filebeat-modules-devguide.html)
- Create a Kibana dashboard
- Submit everything to the main repository https://github.com/elastic/beats