How to setup mysql & Apache Monitor Netdata

Netdata is a free open source, simple and scalable, real-time system performance and health monitoring application for Unix-like systems such as Linux, FreeBSD and MacOS. It gathers various metrics and visualizes them, allowing you to watch operations on your system. It supports various plugins for monitoring current system status, running applications, and services such as MySQL/MariaDB database server, plus lots more.

Mysql Monitoring

Enable Plugin /etc/netdata/charts.d.conf

mysql=force

add /etc/netdata/python.d/mysql.conf

tcp:
name: ‘local’
host: ‘127.0.0.1’
port: ‘3306’
user: ‘user DB’
pass: ‘pass DB’

Add line /etc/netdata/charts.d/mysql.conf

mysql_cmds[MY_A]=”/usr/bin/mysql”
mysql_opts[MY_A]=”-h localhost -uUSERDB -pPASSDB”

APACHE Monitoring

Aktifkan mod status apache2

cek curl “http://127.0.0.1/server-status?auto”

jika error

“Command ‘curl’ not found, but can be installed with:”

apt install curl

Enable plugin in /etc/netdata/charts.d.conf

apache=force

localhost:
name : ‘local’
url : ‘http://localhost/server-status?auto’

localipv4:
name : ‘local’
url : ‘http://127.0.0.1/server-status?auto’

add line /etc/netdata/charts.d/apache.conf

apache_update_every=10

apache_priority=60000

Restart Service Netdata

Posted on: December 13, 2018, by :