Configuration of Metricbeat For MySQL Server Monitoring

Configuration of Metricbeat For MySQL using Elasticsearch stack. This will provide you the information about system and services statistics. We can install and setup metricbeat configure elk dashboard. so

This can provide you system-level CPU usage, Memory usage, file system, disk I/O, and network I/O statistics. so

Check Out: How To Install ADB and Fastboot On Ubuntu 19.04/20.04

Configuration of Metricbeat For MySQL Server Monitoring:

I have created a database testing and user ‘MariaDB’ and assign permission on both the localhost and IP address of MySQL Server. so

Step 1: create database testing; s

install metricbeat

Now Create the user so

create user 'mariadb'@'' identified by 'mariadb';
create user 'mariadb'@'localhost' identified by 'mariadb';

You need to grant permission to the database. so

grant all privileges on testing to 'mariadb'@'localhost' identified by 'mariadb';
grant all privileges on testing to 'mariadb'@'' identified by 'mariadb';
flush privileges;

elk install metricbeat

Check Out:  How to Enable QR Code Generator On Microsoft Edge Browser

Check Permission 

select user,host from mysql.user;

metricbeat setup dashboard

Step 2: Download the Metricbeat on MySQL Server

curl -L -O

configure metricbeat elk

Step 3: Install Metricbeat 

yum install metricbeat-7.0.1-x86_64.rpm -y

Configure for Kibana and Elasticsearch here in this file vim metricbeat.yml

how to enable modules in metricbeat

Check Out: Install Open Source Kibana For Data Visualisation In Linux

Step 4: Now you have to enable the MySQL module

step to configure metricbeat with elasticsearch

metricbeat modules enable mysql

metricbeat setup template enabled

Step 5: Setup Metricbeat for MySQL

metricbeat setup

how to set up metricbeat

Enable and Start the Metricbeat Service.

systemctl start metricbeat && systemctl enable metricbeat

Check Out: Error Elastisearch Bootstrap Check Failed In Linux

As you can see Metricbeat is connected to Elasticsearch.

Step 6: Now check the data received on Kibana,

Click on Check data.

Step 7: Now Click on MySQL metrics Dashboard so

Everything is perfect and working fine. so

That’s it. configure metricbeat elk setup dashboard install

Share on:

I'm the founder of Curious Viral. I hope this blog will provide you complete information about Linux Technology & I would like to share my technical knowledge with you which I have learned during this period.

Other Posts You May Like...

Leave a comment