How to Monitor MySQL or MariaDB Using Netdata in Linux

Netdata: A powerful tool to easily monitor the performance of MySQL databases on Linux systems

Netdata is a free and open source real-time system performance and health monitoring application suitable for Unix-like systems such as Linux, FreeBSD and macOS. It collects and visualizes various metrics, allowing you to monitor the system's operation in real time. Netdata supports a variety of plug-ins that can monitor the current system status, running applications and services, such as MySQL database servers, etc.

This article will guide you on how to use Netdata to monitor the performance of MySQL database servers on RHEL-based distributions. After reading, you will be able to visually monitor the bandwidth, query, handler, lock, problem, temporary files, connections, binlog and threading metrics of the MySQL database server through Netdata's web interface.

Step 1: Install MySQL database server in Linux system

If you haven't installed MySQL or MariaDB on your RHEL-based distribution, install one of them before setting up Netdata monitoring.

Install MySQL database server:

 sudo yum localinstall https://dev.mysql.com/get/mysql80-community-release-el9-1.noarch.rpm
sudo yum install mysql-community-server -y
sudo systemctl start mysqld
sudo systemctl enable mysqld
sudo grep 'temporary password' /var/log/mysqld.log
sudo mysql_secure_installation

Install the MariaDB database server:

 sudo yum install mariadb-server -y
sudo systemctl start mariadb
sudo systemctl enable mariadb
sudo mysql_secure_installation

In order to collect performance statistics from the MySQL/MariaDB database server, Netdata needs to connect to the database server. Therefore, create a database user named "netdata" that allows it to connect to the database server without a password on the local host.

 mysql -u root -p
CREATE USER 'netdata'@'localhost';
GRANT USAGE on *.* to 'netdata'@'localhost';
FLUSH PRIVILEGES;
exit;

Step 2: Install Netdata to monitor MySQL performance

Netdata developers provide a single-line startup script that facilitates you to install Netdata from the source tree of the GitHub repository. The script downloads another script for detecting Linux distributions; installs the system packages required to build Netdata; then downloads the latest Netdata source code tree; and finally builds and installs Netdata on your system.

The following command will start the startup script and install the packages required for all Netdata plugins (including MySQL/MariaDB plugins):

 wget -O /tmp/netdata-kickstart.sh https://get.netdata.cloud/kickstart.sh && sh /tmp/netdata-kickstart.sh

If you are not managing the system as root, you will be prompted for the user password of the sudo command, and you will also need to confirm some functions by pressing Enter.

After the script completes the build and installation of Netdata, you can start the Netdata service and make it automatically start when the system starts:

 sudo systemctl start netdata
sudo systemctl enable netdata

Netdata listens to port 19999 by default, which you will use to access the Web UI. Therefore, please open this port on the system firewall:

 sudo firewall-cmd --permanent --add-port=19999/tcp
sudo firewall-cmd --reload

Step 3: Configure Netdata to monitor MySQL/MariaDB

The default configuration is sufficient to start monitoring your MySQL/MariaDB database server. If you have read the documentation and have made any changes to the above files, you will need to restart the Netdata service for the changes to take effect:

 sudo systemctl restart netdata

Next, open a web browser and access the Netdata Web UI using any of the following URLs:

 <code>http://domain_name:19999或http://SERVER_IP:19999</code>

In the Netdata dashboard, search for "MySQL local" in the list of plugins on the right, and click it to start monitoring your MySQL/MariaDB server. You will be able to view bandwidth, queries, handlers, locks, and Galera (if applicable) visual data as shown in the following image:

Netdata GitHub repository : https://www.php.cn/link/a6424579bdf800415424996ec6d18dac

Summary: This article describes how to use Netdata to monitor the performance of MySQL/MariaDB database servers on RedHat-based systems. If you have any questions, please leave a message in the comment section.

The above is the detailed content of How to Monitor MySQL or MariaDB Using Netdata in Linux. For more information, please follow other related articles on the PHP Chinese website!