zabbix5.0升级6.0 基于Ubuntu2004系统并实现高可用

CSDN官方 你们真不会以为自己的文章编辑器好用吧？
简直是一坨屎

建议直接阅读原文：>>>>>>>   Docshttps://dlk2qiw7lh.feishu.cn/docx/FY4hdJLtJoPNVGxRYEJcjShEnmb

部署zabbix5.0 
下载地址:
https://repo.zabbix.com/zabbix/5.0/ubuntu/pool/main/z/zabbix-release/
[图片]
zabbix-1 操作(部署zabbix)
1. 在192.168.3.172上安装Zabbix 5.0
1.1 更新系统并安装依赖
apt update
apt install -y wget gnupg2

1.2 添加Zabbix存储库
wget https://repo.zabbix.com/zabbix/5.0/ubuntu/pool/main/z/zabbix-release/zabbix-release_5.0-1+focal_all.deb
dpkg -i zabbix-release_5.0-1+focal_all.deb
apt update

1.3 安装Zabbix服务器、前端和代理，中文包 php7.4环境
apt install -y zabbix-agent zabbix-server-mysql zabbix-frontend-php zabbix-agent language-pack-zh-hans zabbix-apache-conf zabbix-get

1.4 安装和配置MySQL数据库
apt install -y mysql-server
mysql_secure_installation

进入MySQL控制台并创建数据库和用户：
mysql -uroot -p
CREATE DATABASE zabbix CHARACTER SET utf8 COLLATE utf8_bin;
CREATE USER 'zabbix'@'localhost' IDENTIFIED BY 'zabbix123';
CREATE USER 'zabbix'@'127.0.0.1' IDENTIFIED BY 'zabbix123';
CREATE USER 'zabbix'@'192.168.3.%' IDENTIFIED BY 'zabbix123';
GRANT ALL PRIVILEGES ON zabbix.* TO 'zabbix'@'localhost';
GRANT ALL PRIVILEGES ON zabbix.* TO 'zabbix'@'127.0.0.1';
GRANT ALL PRIVILEGES ON zabbix.* TO 'zabbix'@'192.168.3.%';
GRANT PROCESS ON *.* TO 'zabbix'@'localhost'; 
set global log_bin_trust_function_creators = 1;
FLUSH PRIVILEGES;
EXIT;

允许被远程连接
sed -i.bak 's/^bind-address/#bind-address/' /etc/mysql/mysql.conf.d/mysqld.cnf
systemctl restart mysql

1.5 导入初始架构和数据
zcat /usr/share/doc/zabbix-server-mysql*/create.sql.gz | mysql -uzabbix -pzabbix123 zabbix

导入数据后，官方建议禁止log_bin_trust_function_creators，启用该选项允许用户创建或修改存储函数和触发器，这可能带来潜在的安全风险
命令:
mysql -uroot -p
SET GLOBAL log_bin_trust_function_creators = 0;
QUIT;

1.6 配置Zabbix服务器
sed -i.bak 's/^# DBPassword=.*/DBPassword=zabbix123/' /etc/zabbix/zabbix_server.conf

1.7 php环境时区修改
echo 'date.timezone = "Asia/Shanghai"' >>/etc/php/7.4/apache2/php.ini
systemctl restart apache2

1.8 解决字体乱码
apt-get install -y ttf-wqy-microhei
cp /usr/share/fonts/truetype/wqy/wqy-microhei.ttc /usr/share/zabbix/assets/fonts/graphfont.ttf

1.9 启动并启用Zabbix服务
systemctl restart zabbix-server zabbix-agent apache2
systemctl enable zabbix-server zabbix-agent apache2

2 设置Zabbix前端
在浏览器中访问 http://192.168.3.172/zabbix，按照页面提示完成安装。

访问zabbix页面开始安装:
注意环境检测必须都是ok不然无法安装
[图片]

[图片]
[图片]
[图片]

添加监控
前提是要安装zabbix_get工具和测试命令
root@zabbix-1:~# apt install -y zabbix-get sysstat
root@zabbix-1:~#vim /etc/zabbix/zabbix_agentd.conf
调整配置允许取值:
Server=127.0.0.1,192.168.3.172
ServerActive=127.0.0.1,192.168.3.172

检查
root@zabbix-2:~# egrep '^Server=|^ServerActive=' /etc/zabbix/zabbix_agentd.conf
Server=127.0.0.1,192.168.3.172
ServerActive=127.0.0.1,192.168.3.172

直接命令替换
sed -i.bak 's#^Server=.*#Server=127.0.0.1,192.168.3.172#g' /etc/zabbix/zabbix_agentd.conf
sed -i 's#^ServerActive=.*#ServerActive=127.0.0.1,192.168.3.172#g' /etc/zabbix/zabbix_agentd.conf
systemctl restart zabbix-agent.service

添加tps自定义监控
cd /etc/zabbix/zabbix_agentd.d
echo 'UserParameter=tps,iostat | awk "/^sda/{print \$2}"' > ./leilei.conf
cat ./leilei.conf
systemctl restart zabbix-agent.service

安装命令工具
root@zabbix-1:~#  apt install sysstat
root@zabbix-1:~# zabbix_get -s 192.168.3.172 -k "tps"
50.51
web页面添加tps监控
[图片]
添加后，过段时间通过最新数据来查询是否拿到了数据，也可以手动测试获取
[图片]

备份mysql并升级zabbix
# 创建备份目录
mkdir -p /opt/zabbix_5.0_backup/mysql

升级前备份数据库：

#完整备份
mysqldump -uzabbix -pzabbix123 zabbix > /opt/zabbix_5.0_backup/zabbi