Monitoraggio di mysql con Zabbix: Difference between revisions
Jump to navigation
Jump to search
Created page with "* Sul server Zabbix, aggiungere il template Template DB MySQL * Sulla macchina da monitorare, creare l'utente di monitoraggio: mysql -u root create user 'zabbix_agent'@'..." |
mNo edit summary |
||
| Line 44: | Line 44: | ||
=Riferimenti= | =Riferimenti= | ||
[http://yallalabs.com/linux/how-to-monitor-mysqlmariadb-using-zabbix-server/ How to Monitor MYSQL/MariaDB Using Zabbix Server - YallaLabs] | *[http://yallalabs.com/linux/how-to-monitor-mysqlmariadb-using-zabbix-server/ How to Monitor MYSQL/MariaDB Using Zabbix Server - YallaLabs] | ||
[https://stackoverflow.com/questions/34805211/monitoring-mysql-with-zabbix-agent Monitoring MySQl with Zabbix Agent - Stack Overflow] | *[https://stackoverflow.com/questions/34805211/monitoring-mysql-with-zabbix-agent Monitoring MySQl with Zabbix Agent - Stack Overflow] | ||
Revision as of 14:27, 3 September 2018
- Sul server Zabbix, aggiungere il template
Template DB MySQL
- Sulla macchina da monitorare, creare l'utente di monitoraggio:
mysql -u root
create user 'zabbix_agent'@'localhost' IDENTIFIED BY 'Password';
GRANT USAGE ON *.* TO 'zabbix_agent'@'localhost' IDENTIFIED BY 'Password';
flush privileges;
exit
- Creare il file .my.cnf coi dettagli di login:
mkdir -p /var/lib/zabbix chown zabbix:zabbix /var/lib/zabbix
cd /var/lib/zabbix/ sudoedit .my.cnf
[mysql] user=zabbix_agent password=Password [mysqladmin] user=zabbix_agent password=Password
- impostare le permission
chown zabbix:zabbix .my.cnf chmod 0644 .my.cbnf
- Verificare la connessione come zabbix agent:
echo "show databases;" | sudo -u zabbix mysql
Database information_schema
- Verificare che i trigger siano abilitati e non Unsupported