部署环境: Centos7.6 Zabbix4.4.0 部署前环境准备或清理: 关闭SeLinux vi/etc/selinux/config SELINUX=disabled yumremovemariadb rm-rf/etc/my.cnf rm-rf/var/lib/mysql/ 一.zabbix监控主机的安装 1、安装apache yuminstall-yhttpd httpd服务开机进行自启 systemctlenablehttpd Createdsymlinkfrom/etc/sy

1.误删除,如上图数据 2.马上进入mysql,输入以下命令,重新创建新的日志文件mysql-bin.000002,则误删的记录就保留在旧日志文件mysql-bin.000001中,如下图 mysql>FLUSHLOGS; cp/app/mysql/data/mysql-bin.000001/opt/tmp 3.cd/opt/tmp,用mysqlbinlog导出相应误删的时间段内的删除记录

下载:zabbix-releaseforUbuntu18 wgethttps://repo.zabbix.com/zabbix/4.2/ubuntu/pool/main/z/zabbix-release/zabbix-release_4.2-2%2Bbionic_all.deb sudoaptinstall./zabbix-release_4.2-2+bionic_all.deb sudoaptupdate sudoaptinstallzabbix-server-mysqlzabbix-frontend-phpzabbix-agent vi/etc/apache2/conf-en

备份及清理shell文件: vi/app/backup/backupmysql.sh #!/bin/sh currdir=`pwd` backupdir=$currdir/dump_his currdate=`date+%Y%m%d` echo"`date+%c`BACKUPBEGIN...">>backup.log; mysqldump--skip-lock-tables--single-transaction--flush-logs--hex-blob--master-data=2-hIPaddress-P3306-uroot