微服务链路追踪 Skywalking MySQL 持久化配置

最新推荐文章于 2024-10-28 23:28:30 发布

Flying9001

最新推荐文章于 2024-10-28 23:28:30 发布

阅读量1.3k

点赞数

分类专栏： Java 文章标签： spring boot skywalking 链路追踪 spring cloud

本文链接：https://blog.csdn.net/Mrqiang9001/article/details/121497592

版权

Java 专栏收录该内容

119 篇文章 12 订阅

订阅专栏

文章目录

1 准备工作

Spring Cloud Alibaba 2.X 简易集成 Skywalking 实现微服务链路追踪

2 配置文件

Skywalking OAP 服务配置:

${skywalkingPath}/config/application.yml

storage:
  selector: ${SW_STORAGE:mysql}

将默认的持久化方式 h2 改为 mysql

  mysql:
    properties:
      jdbcUrl: ${SW_JDBC_URL:"jdbc:mysql://127.0.0.1:3306/skywalking?useUnicode=true&characterEncoding=utf8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=GMT%2b8&useSSL=true&allowMultiQueries=true&autoReconnect=true&nullCatalogMeansCurrent=true&nullCatalogMeansCurrent=true"}
      dataSource.user: ${SW_DATA_SOURCE_USER:devUser}
      dataSource.password: ${SW_DATA_SOURCE_PASSWORD:yourPassword}
      dataSource.cachePrepStmts: ${SW_DATA_SOURCE_CACHE_PREP_STMTS:true}
      dataSource.prepStmtCacheSize: ${SW_DATA_SOURCE_PREP_STMT_CACHE_SQL_SIZE:250}
      dataSource.prepStmtCacheSqlLimit: ${SW_DATA_SOURCE_PREP_STMT_CACHE_SQL_LIMIT:2048}
      dataSource.useServerPrepStmts: ${SW_DATA_SOURCE_USE_SERVER_PREP_STMTS:true}
    metadataQueryMaxSize: ${SW_STORAGE_MYSQL_QUERY_MAX_SIZE:5000}
    maxSizeOfArrayColumn: ${SW_STORAGE_MAX_SIZE_OF_ARRAY_COLUMN:20}
    numOfSearchableValuesPerTag: ${SW_STORAGE_NUM_OF_SEARCHABLE_VALUES_PER_TAG:2}