Filbeat configure in Elasticsearch

Configure Filebeat For MySQL Database Server In Elasticsearch ELK

Configure Filebeat For MySQL database for analysing the traffic, loads and read/write operation on the database. filebeat modules shows MySQL slow query and error data in kibana dashboard and also which user runs the queries on the database server..

You can also configure metric module to check queries runs on database server like select, update, delete and read/write I/O. 

Check Out : Error Can’t Run Elasticsearch As a Root User In Linux

Step 1 : Install Filebeat,

yum install filebeat-7.1.1-x86_64.rpm

Step 2 : Configure filebeat.yml

vim /etc/filebeat/filebeat.yml

Check Out : How To Install Logstash ELK Stack Using Repo On CentOS 7

Step 3 : Start and enable Service

systemctl start filebeat && systemctl enable filebeat

Step 5 : Enable MySQL Module

filebeat modules enable mysql

After enable module, you need to create a dashboard for MySQL

filebeat setup

Check Out : How To Install APM Server In Elasticsearch Elk Stack

Restart the filebeat service

systemctl restart filebeat

Step 6 : Now check on Kibana Data recieved,

Click on MySQL logs dashboard,

There much data in MySQL database So it’s showing nothing. Don’t worry this will show all the information in your database server.

You’re done

Sponsored

LEAVE A REPLY

Please enter your comment!
Please enter your name here

2 × three =