zabbix之自定义监控MySQL主从状态和延迟

Gin—L

已于 2022-09-08 03:10:47 修改

阅读量304

点赞数 1

文章标签： mysql zabbix 数据库

于 2022-09-08 03:08:28 首次发布

本文链接：https://blog.csdn.net/m0_72898391/article/details/126756673

版权

本文详细介绍了如何使用Zabbix监控MySQL主从状态，包括安装配置MariaDB主从、编写监控脚本、在Zabbix web界面添加监控项和触发器，并通过设置0延迟触发器验证配置准确性。

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

环境：

监控端 192.168.79.130 zabbix_servre zabbix_agent
Mysql从库 192.168.79.131 zabbix_agent mariadb
Mysql主库 192.168.79.132 mariadb

1监控MySQL主从状态

1-1安装Mariadb配置主从

部署主库

//安装mariadb
[root@localhost ~]# dnf -y install mariadb*

//安装后启动并设为开机自启
[root@localhost ~]# systemctl enable --now mariadb

//初始状态的mariadb无密码，登录后第一件事修改root用户的密码
[root@localhost ~]# 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('123456!');
Query OK, 0 rows affected (0.001 sec)

MariaDB [(none)]> quit
Bye

//在主库创建一个用于同步的账户授权给从库使用
[root@localhost ~]# mysql -uroot -p123456!
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)]> grant replication slave on *.* to 'repl'@'192.168.79.131' identified by 'repl123!';
Query OK, 0 rows affected (0.000 sec)

MariaDB [(none)]> flush privileges;
Query OK, 0 rows affected (0.000 sec)

MariaDB [(none)]> quit
Bye

//在该配置文件的[mysqld]后面添加这两行
[root@localhost ~]# vim /etc/my.cnf.d/mariadb-server.cnf
[mysqld]
................
log-bin = mys