zabbix监控主从和延迟

Glume_007

已于 2022-09-07 15:12:51 修改

阅读量1k

点赞数

文章标签： zabbix 服务器数据库

于 2022-09-07 15:12:12 首次发布

本文链接：https://blog.csdn.net/m0_59004799/article/details/126741585

版权

文章目录

一、Zabbix监控mysql主从

1、部署mysql主从，使用mariadb进行操作

192.168.244.142  master.example.com  master
192.168.244.143 slave.example.com  slave

2、将server、agent1、master、slave主机的/etc/hosts文件全部设置为

192.168.244.139  server.example.com server
192.168.244.141  agent1.example.com agent1
192.168.244.142  master.example.com master
192.168.244.143  slave.example.com  slave

3、master和slave为centos8的操作系统，将centos8的安装源下载下来，然后两台主机都安装mariadb mariadb-server

[root@slave yum.repos.d]# dnf -y install mariadb mariadb-server
[root@master yum.repos.d]# dnf -y install mariadb mariadb-server
systemctl restart mariadb;systemctl enable mariadb

4、两台主机都初始化mysql数据库

mysql_secure_installation

5、修改数据库配置文件，然后两台主机都重启mariadb服务

[root@master ~]# cat /etc/my.cnf
#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
[mysqld]
log_bin=mysql-bin
server_id=20
[root@master ~]# systemctl restart mariadb.service 

[root@slave ~]# cat /etc/my.cnf
#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
[mysqld]
log_bin=mysql-bin
server_id=30
[root@slave ~]# systemctl restart mariadb.service

6、进入数据库配置主从

master:
[root@master ~]# mysql -uroot -p1
MariaDB [(none)]> grant replication slave on *.* to 'user'@'slave' identified by '1';
Query OK, 0 rows affected (0.000 sec)

MariaDB [(none)]> grant all privileges  on *.* to root@'%' identified by "redhat";
Query OK, 0 rows affected (0.000 sec)

slave:
MariaDB [(none)]> grant all privileges  on *.* to root@'%' identified by "1";
Query OK, 0 rows affected (0.001 sec)

MariaDB [(none)]> change master to master_host='master',master_user='user',master_password='1';
Query OK, 0 rows affected (0.003 sec)

MariaDB [(none)]> start slave;
Query OK, 0 rows affected (0.004 sec)
MariaDB [(none)]> show slave status\G;

              Slave_IO_Running: Connecting
             Slave_SQL_Running: Ye