【Skywalking】Skywalking9.3监控MySQL

最新推荐文章于 2024-07-01 18:37:58 发布

猿仁

最新推荐文章于 2024-07-01 18:37:58 发布

阅读量2.6k

点赞数

分类专栏： Skywalking系列文章标签： skywalking

本文链接：https://blog.csdn.net/qq_45518774/article/details/128890803

版权

Skywalking系列专栏收录该内容

3 篇文章 0 订阅

订阅专栏

开始语

🖋️创建监控用户

🖋️创建docker-compose.yml文件

🖋️创建otel-collector-config.yaml文件

🖋️docker-compose部署

😎查看结果

通过springboot项目，再切换一个数据库，再来查看sw的页面将会出现两个数据库

点击进入详情页

结束语

点击此处前往 >>> Docker部署Skywalking9.3👈

开始语

一位普通的程序员，慢慢在努力变强！

🖋️创建监控用户

# 登录MySQL
mysql -uroot -p
》》》 输入密码

mysql> use mysql
Database changed
mysql> CREATE USER 'mysql_exporter'@'%' IDENTIFIED BY 'mysql_exporter_ROOT_123';
Query OK, 0 rows affected (0.01 sec)
mysql> GRANT PROCESS, REPLICATION CLIENT ON *.* TO 'mysql_exporter'@'%';
Query OK, 0 rows affected (0.01 sec)

mysql> GRANT SELECT ON performance_schema.* TO 'mysql_exporter'@'%';
Query OK, 0 rows affected (0.01 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

🖋️创建docker-compose.yml文件

cat > docker-compose.yml <<-EOF    
version: '3.8'
services:

  mysqld-exporter:
    image: prom/mysqld-exporter:v0.14.0
    container_name: mysqld-exporter
    ports:
      - 9104:9104
    environment:
      - DATA_SOURCE_NAME=mysql_exporter:mysql_exporter_ROOT_123@(ip:3306)/
      - TZ=Asia/Shanghai

  otel-collector:
    image: otel/opentelemetry-collector:0.50.0
    container_name: otel-collector
    command: [ "--config=/etc/otel-collector-config.yaml" ]
    volumes:
      - ./otel-collector-config.yaml:/etc/otel-collector-config.yaml
    expose:
      - 5567
EOF

🖋️创建otel-collector-config.yaml文件

cat > otel-collector-config.yaml <<-EOF
receivers:
  prometheus:
    config:
     scrape_configs:
       - job_name: 'mysql-monitoring'
         scrape_interval: 5s
         static_configs:
           - targets: ['ip:9104']
             labels:
               host_name: prometheus-mysql5.7
processors:
  batch:

exporters:
  otlp:
    endpoint: ip:11800
    tls:
      insecure: true
service:
  pipelines:
    metrics:
      receivers:
      - prometheus
      processors:
      - batch
      exporters:
      - otlp
      
EOF

温馨提示：上面两个yml文件必须放置在同一个目录中