CentOS8系统Skywalking9监控MySQL8

（01）
#more dock-compose.yml
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:boco1234@(192.168.100.201: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:
- 55678

（02）
#more otel-collector-config.yaml
receivers:
prometheus:
config:
scrape_configs:
- job_name: ‘mysql-monitoring’
scrape_interval: 5s
static_configs:
- targets: [‘mysql-exporter:9104’]
labels:
host_name: boco201
processors:
batch:

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

（03）
#docker compose -f ./dock-compose.yml up -d
WARN[0000] /usr/share/skywalking9.7.0/config/dock-compose.yml: version is obsolete
[+] Running 8/8
✔ otel-collector Pulled 19.2s
✔ 4c75b05145f9 Pull complete 3.6s
✔ b110427d6a1c Pull complete 12.8s
✔ 533c18546c82 Pull complete 5.3s
✔ mysqld-exporter Pulled 9.5s
✔ 009932687766 Pull complete 2.7s
✔ ff9264fbb6f4 Pull complete 2.6s
✔ 1516dd896e5e Pull complete 4.4s
[+] Running 3/3
✔ Network config_default Created 0.1s
✔ Container otel-collector Started 0.1s
✔ Container mysqld-exporter Started

（04）业务侧启动
#java -javaagent:skywalking-agent.jar -Dskywalking.agent.service_name=XZF-TEST -Dskywalking.collector.backend_service=192.168.100.202:11800 -jar /usr/share/skywalking9.7.0/agent/skywalking-agent.jar

（05）
微服务
认证中心
#java -javaagent:/usr/share/skywalking9.7.0/agent/skywalking-agent.jar -DSW_AGENT_NAME=cloud-authcenter -DSW_AGENT_COLLECTOR_BACKEND_SERVICES=192.168.100.202:11800
网关
#java -javaagent:/usr/share/skywalking9.7.0/agent/skywalking-agent.jar -DSW_AGENT_NAME=cloud-gateway -DSW_AGENT_COLLECTOR_BACKEND_SERVICES=192.168.100.202:11800
业务
#java -javaagent:/usr/share/skywalking9.7.0/agent/skywalking-agent.jar -DSW_AGENT_NAME=cloud-yewu -DSW_AGENT_COLLECTOR_BACKEND_SERVICES=192.168.100.202:11800

-javaagent： 指定skywalking中的agent中的skywalking-agent.jar的路径
-Dskywalking.agent.service_name： 指定在skywalking中的服务名称，一般是微服务的spring.application.name
-Dskywalking.collector.backend_service： 指定oap服务绑定的地址，并且oap服务默认的端口是11800

（06）样例
java -jar -javaagent:/usr/share/skywalking9.7.0/agent/skywalking-agent.jar -DSW_AGENT_NAME=Zabbix-Test -DSW_AGENT_COLLECTOR_BACKEND_SERVICES=192.168.100.202:11800