MySQL/MariaDB monitor using Zabbix

Loading

If you are using Zabbix centralized monitoring server and want to monitor your all host MySQL then you should follow below steps. This is really an easy job. First of all, go to your Zabbix configuration folder, that is /etc/zabbix. create a file in this directory named “.my.cnf” (without the colon) open the .my.cnf file…

Delete OLD data from Zabbix database

Loading

If you are using Zabbix for a long time, then you might notice that the database size of Zabbix is increasing every day. Then you should delete the old data from the database. login to the MySQL. Select your database (Which is used for zabbix) Run below commands (Please change the interval day as your requirement) DELETE…

Adding new Linux host in zabbix server

Loading

Assume that you have 2 Linux servers, one is having zabbix-server (192.168.0.1) and another is having zabbix-agent (192.168.0.2). In agent server Zabbix Agent is required to install on all remote systems needs to monitor through Zabbix server. The Zabbix Agent collects resource utilization and applications data on the client system and provides such information to…

Zabbix installation on Ubuntu 16.04 LTS

Loading

Here is the complete guide of how to install Zabbix centralized monitoring Server in Ubuntu 16.04. I will install this with MySQL 5.7 and PHP 7.1. I Hope you would like this. Run the following commands for update all the repository and upgrade the installed package: Repository update: # apt update -y # apt upgrade…