자체 호스팅 MySQL용 NRDOT 설치 및 구성

• Debian/Ubuntu 시스템의 경우 다음 명령을 실행하십시오.

  bash

  카피

  $
  NRDOT_VERSION=$(curl -s https://api.github.com/repos/newrelic/nrdot-collector-releases/releases/latest | grep '"tag_name":' | awk -F'"' '{print $4}') && curl -L "https://github.com/newrelic/nrdot-collector-releases/releases/download/${NRDOT_VERSION}/nrdot-collector_${NRDOT_VERSION}_linux_amd64.deb" --output nrdot-collector.deb && sudo dpkg -i nrdot-collector.deb

• RHEL/CentOS/OEL 시스템의 경우 다음 명령을 실행하십시오.

  bash

  카피

  $
  NRDOT_VERSION=$(curl -s https://api.github.com/repos/newrelic/nrdot-collector-releases/releases/latest | grep '"tag_name":' | awk -F'"' '{print $4}') && curl -L "https://github.com/newrelic/nrdot-collector-releases/releases/download/${NRDOT_VERSION}/nrdot-collector_${NRDOT_VERSION}_linux_x86_64.rpm" --output nrdot-collector.rpm && sudo rpm -ivh nrdot-collector.rpm

• Debian/Ubuntu 시스템의 경우 다음 명령을 실행하십시오.

  bash

  카피

  $
  NRDOT_VERSION=$(curl -s https://api.github.com/repos/newrelic/nrdot-collector-releases/releases/latest | grep '"tag_name":' | awk -F'"' '{print $4}') && curl -L "https://github.com/newrelic/nrdot-collector-releases/releases/download/${NRDOT_VERSION}/nrdot-collector_${NRDOT_VERSION}_linux_arm64.deb" --output nrdot-collector.deb && sudo dpkg -i nrdot-collector.deb

• RHEL/CentOS/OEL 시스템의 경우 다음 명령을 실행하십시오.

  bash

  카피

  $
  NRDOT_VERSION=$(curl -s https://api.github.com/repos/newrelic/nrdot-collector-releases/releases/latest | grep '"tag_name":' | awk -F'"' '{print $4}') && curl -L "https://github.com/newrelic/nrdot-collector-releases/releases/download/${NRDOT_VERSION}/nrdot-collector_${NRDOT_VERSION}_linux_arm64.rpm" --output nrdot-collector.rpm && sudo rpm -ivh nrdot-collector.rpm

이 설정은 nrmysql 수신기만을 사용한 필수 MySQL 모니터링에 중점을 둡니다.

1. 이름이 mysql-config.yaml인 설정 파일을 생성합니다:

   bash

   카피

   $
   sudo nano /etc/nrdot-collector/mysql-config.yaml

2. 이전 단계에서 생성한 mysql-config.yaml 파일에 다음 설정을 추가하십시오.

   receivers:
     nrmysql:
       endpoint: "<YOUR_DB_HOST>:<YOUR_DB_PORT>"
       transport: tcp
       username: "<YOUR_DB_USERNAME>"
       password: "<YOUR_DB_PASSWORD>"
       database: "<YOUR_DATABASE_NAME>"
       allow_native_passwords: true
       collection_interval: 10s
       initial_delay: 1s
       tls:
         insecure: false
         insecure_skip_verify: false
         # ca_file: /path/to/global-bundle.pem
       explain_mode: procedure
       statement_events:
         digest_text_limit: 4096
         time_limit: 24h
         limit: 500
       query_sample_collection:
         max_rows_per_query: 100
         allowed_comment_keys: [nr_service_guid]
       top_query_collection:
         lookback_time: 120
         max_query_sample_count: 5000
         top_query_count: 200
         collection_interval: 60s
         query_plan_cache_size: 1000
         query_plan_cache_ttl: 1h
         allowed_comment_keys: [nr_service_guid]
       events:
         db.server.query_sample:
           enabled: true
         db.server.top_query:
           enabled: true
   
   processors:
     batch:
     resource/mysql:
       attributes:
         - key: server.address
           value: "<YOUR_DB_HOST>"
           action: upsert
         - key: server.port
           value: <YOUR_DB_PORT>
           action: upsert
   
   exporters:
     otlp/newrelic:
       endpoint: "<YOUR_NEWRELIC_OTLP_ENDPOINT>"
       headers:
         api-key: "<YOUR_NEWRELIC_LICENSE_KEY>"
       compression: gzip
       retry_on_failure:
         enabled: true
         initial_interval: 5s
         max_interval: 30s
         max_elapsed_time: 300s
   
   service:
     pipelines:
       metrics:
         receivers: [nrmysql]
         processors: [resource/mysql, batch]
         exporters: [otlp/newrelic]
       logs:
         receivers: [nrmysql]
         processors: [resource/mysql, batch]
         exporters: [otlp/newrelic]

   카피

이 설정은 MySQL 데이터베이스 모니터링과 함께 호스트 수준 메트릭(CPU, 메모리, 디스크, 네트워크)을 추가합니다.

1. 이름이 mysql-config.yaml인 설정 파일을 생성합니다:

   bash

   카피

   $
   sudo nano /etc/nrdot-collector/mysql-config.yaml

2. 이전 단계에서 생성한 mysql-config.yaml 파일에 다음 설정을 추가하십시오.

   extensions:
     health_check:
   
   receivers:
     otlp:
       protocols:
         grpc:
         http:
   
     host_metrics:
       collection_interval: 30s
       scrapers:
         cpu:
           metrics:
             system.cpu.time:
               enabled: false
             system.cpu.utilization:
               enabled: true
         load:
         memory:
           metrics:
             system.memory.utilization:
               enabled: true
         paging:
           metrics:
             system.paging.utilization:
               enabled: false
             system.paging.faults:
               enabled: false
         filesystem:
           metrics:
             system.filesystem.utilization:
               enabled: true
         disk:
           metrics:
             system.disk.merged:
               enabled: false
             system.disk.pending_operations:
               enabled: false
             system.disk.weighted_io_time:
               enabled: false
         network:
           metrics:
             system.network.connections:
               enabled: false
         # Uncomment to enable process metrics, which can be noisy but valuable.
         # processes:
         # process:
         #  metrics:
         #    process.cpu.utilization:
         #      enabled: true
         #    process.cpu.time:
         #      enabled: false
   
     nrmysql:
       endpoint: "<YOUR_DB_HOST>:<YOUR_DB_PORT>"
       transport: tcp
       username: "<YOUR_DB_USERNAME>"
       password: "<YOUR_DB_PASSWORD>"
       database: "<YOUR_DATABASE_NAME>"
       allow_native_passwords: true
       collection_interval: 10s
       initial_delay: 1s
       tls:
         insecure: false
         insecure_skip_verify: false
         # Required for Amazon RDS/Aurora with SSL/TLS enforcement -- see
         # Prerequisites -> Network access -> Amazon RDS / Aurora for MySQL.
         # ca_file: /path/to/global-bundle.pem
       # "procedure" collects EXPLAIN plans for write statements (UPDATE/DELETE/INSERT/REPLACE)
       # without granting DML to the monitoring user, via a SQL SECURITY DEFINER procedure.
       # Falls back to "inline" (default) automatically if the procedure is absent for a schema.
       # Requires one-time setup per schema -- see Prerequisites -> DML query plan collection.
       explain_mode: procedure
       statement_events:
         digest_text_limit: 4096
         time_limit: 24h
         limit: 500
       query_sample_collection:
         max_rows_per_query: 100
         # APM-DB correlation: surfaces the nr_service_guid SQL comment tag (e.g. injected by
         # transaction_tracer.sql_metadata_comments in the Java agent) as db.query.comment_tags /
         # db.query.comment_tags.nr_service_guid. Empty list by default -- nothing is extracted
         # unless the key is explicitly allow-listed here.
         allowed_comment_keys: [nr_service_guid]
       top_query_collection:
         lookback_time: 120
         max_query_sample_count: 5000
         top_query_count: 200
         collection_interval: 60s
         query_plan_cache_size: 1000
         query_plan_cache_ttl: 1h
         allowed_comment_keys: [nr_service_guid]
       events:
         db.server.query_sample:
           enabled: true
         db.server.top_query:
           enabled: true
   
   processors:
     metrics_transform:
       transforms:
         - include: system.cpu.utilization
           action: update
           operations:
             - action: aggregate_labels
               label_set: [state]
               aggregation_type: mean
         - include: system.paging.operations
           action: update
           operations:
             - action: aggregate_labels
               label_set: [direction]
               aggregation_type: sum
   
     filter/exclude_cpu_utilization:
       metrics:
         datapoint:
           - 'metric.name == "system.cpu.utilization" and attributes["state"] == "interrupt"'
           - 'metric.name == "system.cpu.utilization" and attributes["state"] == "nice"'
           - 'metric.name == "system.cpu.utilization" and attributes["state"] == "softirq"'
   
     filter/exclude_memory_utilization:
       metrics:
         datapoint:
           - 'metric.name == "system.memory.utilization" and attributes["state"] == "slab_unreclaimable"'
           - 'metric.name == "system.memory.utilization" and attributes["state"] == "inactive"'
           - 'metric.name == "system.memory.utilization" and attributes["state"] == "cached"'
           - 'metric.name == "system.memory.utilization" and attributes["state"] == "buffered"'
           - 'metric.name == "system.memory.utilization" and attributes["state"] == "slab_reclaimable"'
   
     filter/exclude_memory_usage:
       metrics:
         datapoint:
           - 'metric.name == "system.memory.usage" and attributes["state"] == "slab_unreclaimable"'
           - 'metric.name == "system.memory.usage" and attributes["state"] == "inactive"'
   
     filter/exclude_filesystem_utilization:
       metrics:
         datapoint:
           - 'metric.name == "system.filesystem.utilization" and attributes["type"] == "squashfs"'
   
     filter/exclude_filesystem_usage:
       metrics:
         datapoint:
           - 'metric.name == "system.filesystem.usage" and attributes["type"] == "squashfs"'
           - 'metric.name == "system.filesystem.usage" and attributes["state"] == "reserved"'
   
     filter/exclude_filesystem_inodes_usage:
       metrics:
         datapoint:
           - 'metric.name == "system.filesystem.inodes.usage" and attributes["type"] == "squashfs"'
           - 'metric.name == "system.filesystem.inodes.usage" and attributes["state"] == "reserved"'
   
     filter/exclude_system_disk:
       metrics:
         datapoint:
           - 'metric.name == "system.disk.operations" and IsMatch(attributes["device"], "^loop.*") == true'
           - 'metric.name == "system.disk.merged" and IsMatch(attributes["device"], "^loop.*") == true'
           - 'metric.name == "system.disk.io" and IsMatch(attributes["device"], "^loop.*") == true'
           - 'metric.name == "system.disk.io_time" and IsMatch(attributes["device"], "^loop.*") == true'
           - 'metric.name == "system.disk.operation_time" and IsMatch(attributes["device"], "^loop.*") == true'
   
     filter/exclude_network:
       metrics:
         datapoint:
           - 'IsMatch(metric.name, "^system.network.*") == true and attributes["device"] == "lo"'
   
     attributes/exclude_system_paging:
       include:
         match_type: strict
         metric_names:
           - system.paging.operations
       actions:
         - key: type
           action: delete
   
     cumulative_to_delta:
   
     transform:
       trace_statements:
         - context: span
           statements:
             - truncate_all(span.attributes, 4095)
             - truncate_all(resource.attributes, 4095)
   
     transform/host:
       metric_statements:
         - context: metric
           statements:
             - set(metric.description, "")
             - set(metric.unit, "")
   
     # Static server.address/server.port, reusing the same <YOUR_DB_HOST>/<YOUR_DB_PORT>
     # values already set on the receiver's own `endpoint` field above -- nrmysqlreceiver
     # itself emits no server.address/server.port, only its own mysql.instance.endpoint
     # (a combined "host:port" string). Applies uniformly to both metrics and logs
     # pipelines since neither depends on how that string is derived.
     resource/mysql:
       attributes:
         - key: server.address
           value: "<YOUR_DB_HOST>"
           action: upsert
         - key: server.port
           value: <YOUR_DB_PORT>
           action: upsert
   
     batch:
   
     resource_detection:
       detectors: ["system"]
       system:
         hostname_sources: ["os"]
         resource_attributes:
           host.id:
             enabled: true
   
     resource_detection/cloud:
       detectors: ["gcp", "ec2", "azure"]
       timeout: 2s
       override: true
   
     resource_detection/env:
       detectors: ["env"]
       timeout: 2s
       override: true
   
   exporters:
     otlp/newrelic:
       endpoint: "<YOUR_NEWRELIC_OTLP_ENDPOINT>"
       headers:
         api-key: "<YOUR_NEWRELIC_LICENSE_KEY>"
       compression: gzip
       retry_on_failure:
         enabled: true
         initial_interval: 5s
         max_interval: 30s
         max_elapsed_time: 300s
   
   service:
     telemetry:
       metrics:
         level: none
   
     extensions: [health_check]
   
     pipelines:
       metrics/host:
         receivers: [host_metrics]
         processors:
           - metrics_transform
           - filter/exclude_cpu_utilization
           - filter/exclude_memory_utilization
           - filter/exclude_memory_usage
           - filter/exclude_filesystem_utilization
           - filter/exclude_filesystem_usage
           - filter/exclude_filesystem_inodes_usage
           - filter/exclude_system_disk
           - filter/exclude_network
           - attributes/exclude_system_paging
           - transform/host
           - resource_detection
           - resource_detection/cloud
           - resource_detection/env
           - cumulative_to_delta
           - batch
         exporters: [otlp/newrelic]
   
       metrics/mysql:
         receivers: [nrmysql]
         processors:
           - resource/mysql
           - resource_detection
           - resource_detection/cloud
           - resource_detection/env
           - batch
         exporters: [otlp/newrelic]
   
       logs/mysql:
         receivers: [nrmysql]
         processors:
           - resource/mysql
           - resource_detection
           - resource_detection/cloud
           - resource_detection/env
           - batch
         exporters: [otlp/newrelic]
   
       traces:
         receivers: [otlp]
         processors: [transform, resource_detection, resource_detection/cloud, resource_detection/env, batch]
         exporters: [otlp/newrelic]
   
       metrics:
         receivers: [otlp]
         processors: [resource_detection, resource_detection/cloud, resource_detection/env, batch]
         exporters: [otlp/newrelic]
   
       logs:
         receivers: [otlp]
         processors: [resource_detection, resource_detection/cloud, resource_detection/env, batch]
         exporters: [otlp/newrelic]

   카피