zabbix自定义监控

最新推荐文章于 2023-10-13 16:16:56 发布

w262

最新推荐文章于 2023-10-13 16:16:56 发布

阅读量341

点赞数

分类专栏：监控文章标签： zabbix mysql 数据库

本文链接：https://blog.csdn.net/weixin_72435491/article/details/126751800

版权

本文介绍了如何使用Zabbix自定义监控MySQL的主从状态和延迟。首先，配置MySQL主从，接着在从库安装zabbix_agentd。监控重点包括IO和SQL线程状态，通过配置监控脚本、添加监控项和触发器来实现。当MySQL延迟超过200秒时，系统将触发报警。

摘要由CSDN通过智能技术生成

自定义监控MySQL主从状态

首先得配置myslq主从，配置连接：mysql主从配置
然后在从库上，安装zabbix_agentd，安装连接：agintd安装

主从同步完成

//主库
[root@master ~]# systemctl enable --now mariadb
[root@master ~]# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 8
Server version: 10.3.28-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> set password = password('wjh123');
Query OK, 0 rows affected (0.003 sec)

MariaDB [(none)]> exit
Bye
[root@master ~]# mysql -uroot -pwjh123
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 9
Server version: 10.3.28-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>
iaDB [(none)]> grant replication slave on *.* to 'repl'@'192.168.137.133' identified by 'repl123';
   
Query OK, 0 rows affected (0.001 sec)

MariaDB [(none)]> quit

//添加这两行
[root@master ~]# vim /etc/my.cnf.d/mariadb-server.cnf 
log-bin=mysql_bin
server-id=10

//查看一下
[root@master ~]# systemctl restart mariadb.service 
[root@master ~]# mysql -uroot -pwjh123
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 9
Server version: 10.3.28-MariaDB-log MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for hel