Zabbix监控mysql主从

最新推荐文章于 2024-07-15 11:48:23 发布

" vivian

最新推荐文章于 2024-07-15 11:48:23 发布

阅读量638

点赞数

文章标签： zabbix mysql linux

本文链接：https://blog.csdn.net/m0_56681539/article/details/126764732

版权

本文详细介绍了如何部署MySQL主从架构，并利用Zabbix进行监控。首先，在CentOS8系统上安装并配置MariaDB，然后设置主从同步。接着在slave主机安装Zabbix-agent，配置监控项和触发器。最后，通过模拟主从关闭和开启验证Zabbix的告警功能，确保能够监控主从延迟。

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

1、部署mysql主从，使用mariadb进行操作，将server、agent ，master、slave主机的/etc/hosts文件全部设置为

192.168.253.139  server.example.com server
192.168.253.140  agent1.example.com agent
192.168.253.129  master.example.com master
192.168.253.130  slave.example.com  slave

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

[root@129-master yum.repos.d]# wget -O /etc/yum.repos.d/CentOS-Base.repo https://mirrors.aliyun.com/repo/Centos-vault-8.5.2111.repo
[root@129-master yum.repos.d]# sed -i -e '/mirrors.cloud.aliyuncs.com/d' -e '/mirrors.aliyuncs.com/d' 
[root@129-master yum.repos.d]# cd
[root@129-master ~]# yum -y install mariadb-server mariadb
[root@129-master ~]# systemctl restart mariadb
[root@129-master ~]# systemctl enable mariadb
Created symlink /etc/systemd/system/mysql.service → /usr/lib/systemd/system/mariadb.service.
Created symlink /etc/systemd/system/mysqld.service → /usr/lib/systemd/system/mariadb.service.
Created symlink /etc/systemd/system/multi-user.target.wants/mariadb.service → /usr/lib/systemd/system/

[root@130-slave ~]# wget -O /etc/yum.repos.d/CentOS-Base.repo https://mirrors.aliyun.com/repo/Centos-vault-8.5.2111.repo
[root@130-slave ~]# sed -i -e '/mirrors.cloud.aliyuncs.com/d' -e '/mirrors.aliyuncs.com/d' /etc/yum.repos.d/Ce
[root@130-slave ~]# yum -y install mariadb-server mariadb
[root@130-slave ~]# systemctl restart mariadb
[root@130-slave ~]# systemctl enable mariadb
Created symlink /etc/systemd/system/mysql.service → /usr/lib/systemd/system/mariadb.service.
Created symlink /etc/systemd/system/mysqld.service → /usr/lib/systemd/system/mariadb.service.
Created symlink /etc/systemd/system/multi