Table of Contents

모니터링 적용 과정

도커 컴포즈 파일에 prometheus, grafana, exporter 컨테이너를 추가한다

version: '3.2'

services:
  mysql:
    hostname: mysql
    image: ziontkim0510/mysql-server:1.2
    ports:
      - 3306:3306
    environment:
      MYSQL_USER: root
      MYSQL_ROOT_HOST: "%%"
      MYSQL_DATABASE: test
      MYSQL_ROOT_PASSWORD: passwd
    command: mysqld
      --server-id=1234
      --max-binlog-size=4096
      --binlog-format=ROW
      --log-bin=bin-log
      --sync-binlog=1
      --binlog-rows-query-log-events=ON
    volumes:
      - ./dataset:/var/lib/mysql-files

  mysqld-exporter:
    hostname: mysqld-exporter
    image: prom/mysqld-exporter
    ports:
      - 9104:9104
    environment:
      DATA_SOURCE_NAME: root:passwd@(mysql:3306)/

  prometheus:
    hostname: prometheus
    image: prom/prometheus
    ports:
      - 9090:9090
    volumes:
      - ./monitoring/prometheus.yml:/etc/prometheus/prometheus.yml

  grafana:
    hostname: grafana
    image: grafana/grafana
    ports:
      - 3000:3000

prometheus.yml 파일을 작성한다

프로메테우스가 메트릭을 읽어오도록 잡을 생성한다

global:
  scrape_interval: 15s
  scrape_timeout: 10s
  evaluation_interval: 15s

scrape_configs:
- job_name: prometheus
  metrics_path: /metrics
  static_configs:
  - targets:
    - localhost:9090

- job_name: mysql
  metrics_path: /metrics
  static_configs:
  - targets:
    - mysqld-exporter:9104