# Cassandra日常巡检脚本

LOG_FILE=”/cassandra/logs/inspection_$(date +%Y%m%d).log”
REPORT_FILE=”/cassandra/reports/inspection_report_$(date +%Y%m%d).txt”

log() {
echo “[$(date ‘+%Y-%m-%d %H:%M:%S’)] $1” | tee -a ${LOG_FILE}
}

report() {
echo “$1” >> ${REPORT_FILE}
}

check_system_status() {
log “检查系统状态…”
report “=== 系统状态检查 ===”

report “CPU使用率:”
top -bn1 | grep “Cpu(s)” | awk ‘{print ” 使用率: ” 100-$8 “%”}’ >> ${REPORT_FILE}

report “内存使用:”
free -h | grep “Mem:” | awk ‘{print ” 总量: “$2”, 已用: “$3”, 可用: “$4}’ >> ${REPORT_FILE}

report “磁盘使用:”
df -h | grep “/cassandra” >> ${REPORT_FILE}
}

check_cassandra_status() {
log “检查Cassandra状态…”
report “=== Cassandra状态检查 ===”

report “集群状态:”
nodetool status >> ${REPORT_FILE}

report “节点信息:”
nodetool info >> ${REPORT_FILE}
}

check_data_status() {
log “检查数据状态…”
report “=== 数据状态检查 ===”

report “表统计:”
nodetool tablestats >> ${REPORT_FILE}

report “数据分布:”
nodetool ring >> ${REPORT_FILE}
}

check_performance() {
log “检查性能指标…”
report “=== 性能指标检查 ===”

report “线程池状态:”
nodetool tpstats >> ${REPORT_FILE}

report “压缩状态:”
nodetool compactionstats >> ${REPORT_FILE}
}

main() {
log “=== 开始日常巡检 ===”

mkdir -p $(dirname ${REPORT_FILE})
report “Cassandra日常巡检报告 – $(date ‘+%Y-%m-%d %H:%M:%S’)” > ${REPORT_FILE}
report “” >> ${REPORT_FILE}

check_system_status
check_cassandra_status
check_data_status
check_performance

log “巡检报告已生成: ${REPORT_FILE}”
log “=== 日常巡检完成 ===”
}

main