#!/bin/bash
# zabbix_cleanup.sh - Zabbix数据库清理脚本

DB_USER="zabbix"
DB_PASS="your_password"
DB_NAME="zabbix"

# 保留天数
HISTORY_DAYS=7
TRENDS_DAYS=30

# 清理历史数据
echo "清理${HISTORY_DAYS}天前的历史数据..."
mysql -u "$DB_USER" -p"$DB_PASS" "$DB_NAME" << EOF
DELETE FROM history WHERE clock < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL ${HISTORY_DAYS} DAY));
DELETE FROM history_str WHERE clock < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL ${HISTORY_DAYS} DAY));
DELETE FROM history_text WHERE clock < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL ${HISTORY_DAYS} DAY));
DELETE FROM history_log WHERE clock < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL ${HISTORY_DAYS} DAY));
OPTIMIZE TABLE history, history_str, history_text, history_log;
EOF

# 清理趋势数据
echo "清理${TRENDS_DAYS}天前的趋势数据..."
mysql -u "$DB_USER" -p"$DB_PASS" "$DB_NAME" << EOF
DELETE FROM trends WHERE clock < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL ${TRENDS_DAYS} DAY));
DELETE FROM trends_uint WHERE clock < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL ${TRENDS_DAYS} DAY));
OPTIMIZE TABLE trends, trends_uint;
EOF

echo "清理完成"

# /etc/sysctl.conf
fs.file-max = 65535
net.core.somaxconn = 1024
net.ipv4.tcp_max_syn_backlog = 2048
net.ipv4.tcp_fin_timeout = 30
net.ipv4.tcp_keepalive_time = 300
net.ipv4.tcp_keepalive_probes = 5
net.ipv4.tcp_keepalive_intvl = 15

# 应用配置
sysctl -p

# 设置文件描述符限制
# /etc/security/limits.conf
zabbix soft nofile 65535
zabbix hard nofile 65535

#!/bin/bash
# zabbix_template_sync.sh - 模板同步脚本

TEMPLATE_DIR="/etc/zabbix/templates"
ZABBIX_URL="http://zabbix-server/zabbix"
ZABBIX_USER="Admin"
ZABBIX_PASS="zabbix"

# 导入模板
import_template() {
    local template_file="$1"
    local template_name=$(basename "$template_file" .xml)
    
    echo "导入模板: $template_name"
    
    curl -X POST "$ZABBIX_URL/api_jsonrpc.php" \
        -H "Content-Type: application/json" \
        -d "{
            \"jsonrpc\": \"2.0\",
            \"method\": \"configuration.import\",
            \"params\": {
                \"format\": \"xml\",
                \"source\": \"$(cat "$template_file" | sed 's/"/\\"/g')\",
                \"rules\": {
                    \"templates\": {
                        \"createMissing\": true,
                        \"updateExisting\": true
                    }
                }
            },
            \"id\": 1,
            \"auth\": \"$(get_auth_token)\"
        }"
}

# 获取认证令牌
get_auth_token() {
    curl -s -X POST "$ZABBIX_URL/api_jsonrpc.php" \
        -H "Content-Type: application/json" \
        -d "{
            \"jsonrpc\": \"2.0\",
            \"method\": \"user.login\",
            \"params\": {
                \"user\": \"$ZABBIX_USER\",
                \"password\": \"$ZABBIX_PASS\"
            },
            \"id\": 1
        }" | jq -r '.result'
}

# 同步所有模板
for template in "$TEMPLATE_DIR"/*.xml; do
    import_template "$template"
done

echo "模板同步完成"

#!/bin/bash
# zabbix_alert_suppress.sh - 告警抑制脚本

# 告警抑制配置
SUPPRESS_RULES=("高可用集群|备节点状态异常" "服务器|磁盘空间警告")

# 检查告警是否需要抑制
check_suppress() {
    local alert_subject="$1"
    local alert_message="$2"
    
    for rule in "${SUPPRESS_RULES[@]}"; do
        local pattern=$(echo "$rule" | cut -d'|' -f1)
        local message_pattern=$(echo "$rule" | cut -d'|' -f2)
        
        if echo "$alert_subject" | grep -q "$pattern" && \
           echo "$alert_message" | grep -q "$message_pattern"; then
            echo "告警已抑制: $alert_subject"
            return 1
        fi
    done
    
    return 0
}

# 主函数
main() {
    local subject="$1"
    local message="$2"
    
    if check_suppress "$subject" "$message"; then
        # 发送告警
        send_alert "$subject" "$message"
    fi
}

# 发送告警函数
send_alert() {
    local subject="$1"
    local message="$2"
    
    # 这里实现具体的告警发送逻辑
    echo "发送告警: $subject"
    # 邮件、短信、电话等通知方式
}

# 执行主函数
main "$@"

#!/bin/bash
# zabbix_monitor_setup.sh - 监控项配置脚本

HOSTNAME="$1"

# 基础监控项
BASE_ITEMS=("system.cpu.util[,avg1]","vm.memory.size[used]","vfs.fs.size[/,used]","net.if.in[eth0,bytes]")

# 应用监控项
APP_ITEMS=("mysql.status[Threads_connected]","nginx.stat[connections,active]")

# 添加监控项
add_item() {
    local host="$1"
    local key="$2"
    local name="$3"
    
    echo "添加监控项: $name ($key)"
    
    # 使用Zabbix API添加监控项
    # 这里实现具体的API调用
}

# 主函数
main() {
    echo "为主机 $HOSTNAME 配置监控项"
    
    # 添加基础监控项
    for item in "${BASE_ITEMS[@]}"; do
        key=$(echo "$item" | cut -d',' -f1)
        name=$(echo "$item" | cut -d',' -f2)
        add_item "$HOSTNAME" "$key" "$name"
    done
    
    # 添加应用监控项
    for item in "${APP_ITEMS[@]}"; do
        key=$(echo "$item" | cut -d',' -f1)
        name=$(echo "$item" | cut -d',' -f2)
        add_item "$HOSTNAME" "$key" "$name"
    done
    
    echo "监控项配置完成"
}

# 执行主函数
main "$HOSTNAME"

#!/bin/bash
# zabbix_ha_setup.sh - Zabbix高可用部署脚本

# 节点配置
NODE1="192.168.1.10"
NODE2="192.168.1.11"
VIP="192.168.1.100"

# 安装Keepalived
install_keepalived() {
    yum install -y keepalived
    
    # 配置Keepalived
    cat > /etc/keepalived/keepalived.conf << EOF
vrrp_instance VI_1 {
    state MASTER
    interface eth0
    virtual_router_id 51
    priority 100
    advert_int 1
    authentication {
        auth_type PASS
        auth_pass zabbix_ha
    }
    virtual_ipaddress {
        $VIP
    }
}
EOF
    
    systemctl enable keepalived
    systemctl start keepalived
}

# 配置MySQL主从复制
configure_mysql_replication() {
    # 主库配置
    cat > /etc/my.cnf.d/replication.cnf << EOF
[mysqld]
server-id = 1
log-bin = mysql-bin
binlog-format = ROW
EOF
    
    # 从库配置
    # 这里实现从库配置
    
    # 初始化复制
    # 这里实现复制初始化
}

# 配置Zabbix Server
configure_zabbix_server() {
    # 配置文件修改
    sed -i "s/DBHost=.*/DBHost=$VIP/" /etc/zabbix/zabbix_server.conf
    
    systemctl enable zabbix-server
    systemctl start zabbix-server
}

# 主函数
main() {
    echo "开始部署Zabbix高可用架构"
    
    # 安装Keepalived
    install_keepalived
    
    # 配置MySQL主从复制
    configure_mysql_replication
    
    # 配置Zabbix Server
    configure_zabbix_server
    
    echo "Zabbix高可用架构部署完成"
}

# 执行主函数
main

#!/bin/bash
# zabbix_maintenance.sh - Zabbix日常维护脚本

# 日志配置
LOG_FILE="/var/log/zabbix/maintenance.log"

# 日志函数
log() {
    local level="$1"
    local message="$2"
    local timestamp="$(date '+%Y-%m-%d %H:%M:%S')"
    echo "[$timestamp] [$level] $message" >> "$LOG_FILE"
    echo "[$level] $message"
}

# 数据库清理
cleanup_database() {
    log "INFO" "开始数据库清理"
    
    # 调用清理脚本
    /opt/scripts/zabbix_cleanup.sh
    
    log "INFO" "数据库清理完成"
}

# 日志轮换
rotate_logs() {
    log "INFO" "开始日志轮换"
    
    # 轮换Zabbix日志
    logrotate -f /etc/logrotate.d/zabbix
    
    log "INFO" "日志轮换完成"
}

# 配置备份
backup_config() {
    log "INFO" "开始配置备份"
    
    local backup_dir="/backup/zabbix/$(date '+%Y%m%d')"
    mkdir -p "$backup_dir"
    
    # 备份配置文件
    cp -r /etc/zabbix/ "$backup_dir/"
    
    # 备份数据库
    mysqldump -u zabbix -p'password' zabbix > "$backup_dir/zabbix.sql"
    
    log "INFO" "配置备份完成: $backup_dir"
}

# 性能检查
check_performance() {
    log "INFO" "开始性能检查"
    
    # 检查Zabbix Server状态
    systemctl status zabbix-server
    
    # 检查数据库状态
    mysql -u zabbix -p'password' -e "SHOW GLOBAL STATUS LIKE 'Threads%'"
    
    # 检查系统负载
    uptime
    
    log "INFO" "性能检查完成"
}

# 主函数
main() {
    log "INFO" "开始Zabbix日常维护"
    
    cleanup_database
    rotate_logs
    backup_config
    check_performance
    
    log "INFO" "Zabbix日常维护完成"
}

# 执行主函数
main

#!/bin/bash
# zabbix_config_management.sh - 配置管理脚本

# 配置仓库
CONFIG_REPO="git@github.com:your-org/zabbix-config.git"
CONFIG_DIR="/etc/zabbix"

# 同步配置
sync_config() {
    echo "同步配置从Git仓库"
    
    cd "$CONFIG_DIR"
    git pull
    
    echo "配置同步完成"
}

# 提交配置
commit_config() {
    local commit_message="$1"
    
    echo "提交配置到Git仓库"
    
    cd "$CONFIG_DIR"
    git add .
    git commit -m "$commit_message"
    git push
    
    echo "配置提交完成"
}

# 回滚配置
rollback_config() {
    local commit_hash="$1"
    
    echo "回滚配置到: $commit_hash"
    
    cd "$CONFIG_DIR"
    git reset --hard "$commit_hash"
    
    echo "配置回滚完成"
}

# 主函数
main() {
    case "$1" in
        "sync")
            sync_config
            ;;
        "commit")
            commit_config "$2"
            ;;
        "rollback")
            rollback_config "$2"
            ;;
        *)
            echo "用法: $0 {sync|commit|rollback}"
            ;;
    esac
}

# 执行主函数
main "$@"