Files

217 lines
9.8 KiB
Bash

#!/bin/bash
################################################################################
# ChocoMae 24/7 모니터링 스크립트
# 목적: 1주일 동안 WEB(Apache), WAS(PHP), DB(MariaDB)의 주요 지표 수집
# 모니터링 주기: 1분 간격
# 데이터 저장: CSV 포맷 (일별 파일, 7일 자동 rotation)
# 설치: crontab -e에 추가
# 0 0 * * * /path/to/chocomae-24h-monitoring.sh (또는 시작 명령어로 직접 실행)
################################################################################
# ============================================================================
# 설정
# ============================================================================
MONITOR_DIR="/home/ubuntu/chocomae-monitoring"
LOG_RETENTION_DAYS=7
INTERVAL=60 # 1분 간격
TIMESTAMP_FORMAT="%Y-%m-%d %H:%M:%S"
# 프로세스 이름
APACHE_PROCESS="apache2"
PHP_PROCESS="php-fpm"
MARIADB_PROCESS="mariadb"
# ============================================================================
# 초기 설정
# ============================================================================
mkdir -p "$MONITOR_DIR"
cd "$MONITOR_DIR" || exit 1
# 로그 파일 이름 (일별)
LOG_FILE="$MONITOR_DIR/chocomae-$(date +%Y%m%d).log"
# 헤더 작성 (파일이 없으면)
if [[ ! -f "$LOG_FILE" ]]; then
echo "timestamp,apache_cpu,apache_mem,apache_conn_count,php_cpu,php_mem,php_conn_count,mariadb_cpu,mariadb_mem,mariadb_conn_current,mariadb_conn_max,mariadb_threads_running,disk_root_usage_percent,disk_root_free_gb,disk_io_read_mb_s,disk_io_write_mb_s,apache_busy_workers,apache_idle_workers,apache_ka_connections,apache_total_accesses,system_cpu_usage_percent,system_mem_usage_percent,system_mem_free_gb,mariadb_slow_queries" > "$LOG_FILE"
fi
# ============================================================================
# 함수: 오래된 로그 파일 삭제
# ============================================================================
cleanup_old_logs() {
find "$MONITOR_DIR" -name "chocomae-????????.log" -type f -mtime +$LOG_RETENTION_DAYS -delete 2>/dev/null
}
# ============================================================================
# 함수: Apache 메트릭 수집
# ============================================================================
get_apache_metrics() {
local apache_status
apache_status=$(curl -s http://localhost/server-status?auto 2>/dev/null)
# CPU 사용량 (%)
local apache_cpu=$(ps aux | grep -E "[a]pache|[h]ttpd" | awk '{sum+=$3} END {print (NR>1 ? sum/(NR-1) : 0)}')
# 메모리 사용량 (MB)
local apache_mem=$(ps aux | grep -E "[a]pache|[h]ttpd" | awk '{sum+=$6} END {printf "%.0f", (sum>0 ? sum/1024 : 0)}')
# Connection 수
local apache_conn_count=$(echo "$apache_status" | grep -c "^ConproxiedRequests\|^Total Accesses" || echo "0")
# Busy/Idle workers, Keep-Alive connections
local busy_workers=$(echo "$apache_status" | awk -F': ' '/^BusyWorkers/{print $2}' || echo "0")
local idle_workers=$(echo "$apache_status" | awk -F': ' '/^IdleWorkers/{print $2}' || echo "0")
# Scoreboard 분석 (K: keep-alive)
local scoreboard=$(echo "$apache_status" | awk -F': ' '/^Scoreboard/{print $2}')
local ka_connections=$(echo "$scoreboard" | tr -cd 'K' | wc -c)
# Total Accesses
local total_accesses=$(echo "$apache_status" | awk -F': ' '/^Total Accesses/{print $2}' || echo "0")
echo "$apache_cpu|$apache_mem|$apache_conn_count|$busy_workers|$idle_workers|$ka_connections|$total_accesses"
}
# ============================================================================
# 함수: PHP-FPM 메트릭 수집
# ============================================================================
get_php_metrics() {
# CPU 사용량 (%)
local php_cpu=$(ps aux | grep -E "[p]hp-fpm" | awk '{sum+=$3} END {print (NR>1 ? sum/(NR-1) : 0)}')
# 메모리 사용량 (MB)
local php_mem=$(ps aux | grep -E "[p]hp-fpm" | awk '{sum+=$6} END {printf "%.0f", (sum>0 ? sum/1024 : 0)}')
# Connection 수 (PHP 프로세스 수)
local php_conn_count=$(ps aux | grep -c "[p]hp-fpm" || echo "0")
echo "$php_cpu|$php_mem|$php_conn_count"
}
# ============================================================================
# 함수: MariaDB 메트릭 수집
# ============================================================================
get_mariadb_metrics() {
# CPU 사용량 (%)
local mariadb_cpu=$(ps aux | grep -E "[m]ariadb|[m]ysqld" | grep -v grep | awk '{sum+=$3} END {print (NR>0 ? sum : 0)}')
# 메모리 사용량 (MB)
local mariadb_mem=$(ps aux | grep -E "[m]ariadb|[m]ysqld" | grep -v grep | awk '{sum+=$6} END {printf "%.0f", (sum>0 ? sum/1024 : 0)}')
# MariaDB 연결 관련 정보
local db_info=$(sudo -n /usr/bin/mariadb -N -B -e "SHOW GLOBAL STATUS WHERE Variable_name IN ('Threads_connected','Max_used_connections','Threads_running','Slow_queries')" 2>/dev/null | \
awk 'NR==1{threads=$2} NR==2{max=$2} NR==3{running=$2} NR==4{slow=$2} END{printf "%s|%s|%s|%s", (threads?threads:"0"), (max?max:"0"), (running?running:"0"), (slow?slow:"0")}')
echo "$mariadb_cpu|$mariadb_mem|$db_info"
}
# ============================================================================
# 함수: DISK 메트릭 수집
# ============================================================================
get_disk_metrics() {
# 루트 파티션 사용률 (%)
local disk_usage=$(df -h / | awk 'NR==2 {print $5}' | tr -d '%')
# 루트 파티션 여유 공간 (GB)
local disk_free=$(df -h / | awk 'NR==2 {print $4}' | tr -d 'G')
# DISK IO (iostat 이용, 대략값)
# 주의: iostat이 없으면 설치 필요 (apt-get install sysstat)
local io_stats=$(iostat -dx 1 2 2>/dev/null | tail -1 | awk '{printf "%.2f|%.2f", $6, $7}')
if [[ -z "$io_stats" ]]; then
io_stats="0.00|0.00"
fi
echo "$disk_usage|$disk_free|$io_stats"
}
# ============================================================================
# 함수: 시스템 전체 메트릭 수집
# ============================================================================
get_system_metrics() {
# CPU 사용률 (%)
local cpu_usage=$(top -bn1 | grep "Cpu(s)" | awk '{print 100-$8}')
# 메모리 사용률 (%)
local mem_info=$(free | awk '/^Mem:/ {printf "%.1f|%.2f", ($3/$2)*100, $7/1024/1024}')
echo "$cpu_usage|$mem_info"
}
# ============================================================================
# 메인 루프
# ============================================================================
main() {
while true; do
# 현재 시간
local timestamp=$(date +"$TIMESTAMP_FORMAT")
# 각 메트릭 수집
local apache_metrics=$(get_apache_metrics)
local php_metrics=$(get_php_metrics)
local mariadb_metrics=$(get_mariadb_metrics)
local disk_metrics=$(get_disk_metrics)
local system_metrics=$(get_system_metrics)
# IFS를 |로 설정하여 파싱
IFS='|' read -r apache_cpu apache_mem apache_conn apache_busy apache_idle apache_ka apache_accesses <<< "$apache_metrics"
IFS='|' read -r php_cpu php_mem php_conn <<< "$php_metrics"
IFS='|' read -r mariadb_cpu mariadb_mem mariadb_threads mariadb_max mariadb_running mariadb_slow <<< "$mariadb_metrics"
IFS='|' read -r disk_usage disk_free disk_read disk_write <<< "$disk_metrics"
IFS='|' read -r sys_cpu sys_mem mem_free <<< "$system_metrics"
# 기본값 설정
apache_cpu=${apache_cpu:-0}
apache_mem=${apache_mem:-0}
apache_conn=${apache_conn:-0}
php_cpu=${php_cpu:-0}
php_mem=${php_mem:-0}
php_conn=${php_conn:-0}
mariadb_cpu=${mariadb_cpu:-0}
mariadb_mem=${mariadb_mem:-0}
mariadb_threads=${mariadb_threads:-0}
mariadb_max=${mariadb_max:-0}
mariadb_running=${mariadb_running:-0}
mariadb_slow=${mariadb_slow:-0}
disk_usage=${disk_usage:-0}
disk_free=${disk_free:-0}
disk_read=${disk_read:-0}
disk_write=${disk_write:-0}
apache_busy=${apache_busy:-0}
apache_idle=${apache_idle:-0}
apache_ka=${apache_ka:-0}
apache_accesses=${apache_accesses:-0}
sys_cpu=${sys_cpu:-0}
sys_mem=${sys_mem:-0}
mem_free=${mem_free:-0}
# CSV 형식으로 로그 기록
echo "$timestamp,$apache_cpu,$apache_mem,$apache_conn,$php_cpu,$php_mem,$php_conn,$mariadb_cpu,$mariadb_mem,$mariadb_threads,$mariadb_max,$mariadb_running,$disk_usage,$disk_free,$disk_read,$disk_write,$apache_busy,$apache_idle,$apache_ka,$apache_accesses,$sys_cpu,$sys_mem,$mem_free,$mariadb_slow" >> "$LOG_FILE"
# 오래된 로그 정리 (1시간마다)
if (( $(date +%M) == 0 )); then
cleanup_old_logs
fi
# 다음 날짜로 넘어가면 새 로그 파일 생성
local new_log_file="$MONITOR_DIR/chocomae-$(date +%Y%m%d).log"
if [[ "$new_log_file" != "$LOG_FILE" ]]; then
LOG_FILE="$new_log_file"
echo "timestamp,apache_cpu,apache_mem,apache_conn_count,php_cpu,php_mem,php_conn_count,mariadb_cpu,mariadb_mem,mariadb_conn_current,mariadb_conn_max,mariadb_threads_running,disk_root_usage_percent,disk_root_free_gb,disk_io_read_mb_s,disk_io_write_mb_s,apache_busy_workers,apache_idle_workers,apache_ka_connections,apache_total_accesses,system_cpu_usage_percent,system_mem_usage_percent,system_mem_free_gb,mariadb_slow_queries" > "$LOG_FILE"
fi
# 대기
sleep $INTERVAL
done
}
# ============================================================================
# 스크립트 시작
# ============================================================================
echo "[$(date +'%Y-%m-%d %H:%M:%S')] ChocoMae 24/7 모니터링 시작"
echo "모니터링 주기: ${INTERVAL}초"
echo "데이터 저장 위치: $MONITOR_DIR"
echo "데이터 보관 기간: ${LOG_RETENTION_DAYS}일"
main