Spring Cloud Sleuth 服务跟踪 将跟踪信息存储到数据库
参见上一篇博客:Spring Cloud Sleuth 服务跟踪
主要在跟踪服务上配置:
在数据库创建数据库表:(可不创建,在classpath中添加对应的sql文件也可,有效率问题,详细上面链接文章)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 | CREATE TABLE IF NOT EXISTS zipkin_spans ( `trace_id_high` BIGINT NOT NULL DEFAULT 0 COMMENT 'If non zero, this means the trace uses 128 bit traceIds instead of 64 bit' , `trace_id` BIGINT NOT NULL, `id` BIGINT NOT NULL, `name` VARCHAR( 255 ) NOT NULL, `parent_id` BIGINT, `debug` BIT( 1 ), `start_ts` BIGINT COMMENT 'Span.timestamp(): epoch micros used for endTs query and to implement TTL' , `duration` BIGINT COMMENT 'Span.duration(): micros used for minDuration and maxDuration query' ) ENGINE=InnoDB ROW_FORMAT=COMPRESSED CHARACTER SET=utf8 COLLATE utf8_general_ci; ALTER TABLE zipkin_spans ADD UNIQUE KEY(`trace_id_high`, `trace_id`, `id`) COMMENT 'ignore insert on duplicate' ; ALTER TABLE zipkin_spans ADD INDEX(`trace_id_high`, `trace_id`, `id`) COMMENT 'for joining with zipkin_annotations' ; ALTER TABLE zipkin_spans ADD INDEX(`trace_id_high`, `trace_id`) COMMENT 'for getTracesByIds' ; ALTER TABLE zipkin_spans ADD INDEX(`name`) COMMENT 'for getTraces and getSpanNames' ; ALTER TABLE zipkin_spans ADD INDEX(`start_ts`) COMMENT 'for getTraces ordering and range' ; CREATE TABLE IF NOT EXISTS zipkin_annotations ( `trace_id_high` BIGINT NOT NULL DEFAULT 0 COMMENT 'If non zero, this means the trace uses 128 bit traceIds instead of 64 bit' , `trace_id` BIGINT NOT NULL COMMENT 'coincides with zipkin_spans.trace_id' , `span_id` BIGINT NOT NULL COMMENT 'coincides with zipkin_spans.id' , `a_key` VARCHAR( 255 ) NOT NULL COMMENT 'BinaryAnnotation.key or Annotation.value if type == -1' , `a_value` BLOB COMMENT 'BinaryAnnotation.value(), which must be smaller than 64KB' , `a_type` INT NOT NULL COMMENT 'BinaryAnnotation.type() or -1 if Annotation' , `a_timestamp` BIGINT COMMENT 'Used to implement TTL; Annotation.timestamp or zipkin_spans.timestamp' , `endpoint_ipv4` INT COMMENT 'Null when Binary/Annotation.endpoint is null' , `endpoint_ipv6` BINARY( 16 ) COMMENT 'Null when Binary/Annotation.endpoint is null, or no IPv6 address' , `endpoint_port` SMALLINT COMMENT 'Null when Binary/Annotation.endpoint is null' , `endpoint_service_name` VARCHAR( 255 ) COMMENT 'Null when Binary/Annotation.endpoint is null' ) ENGINE=InnoDB ROW_FORMAT=COMPRESSED CHARACTER SET=utf8 COLLATE utf8_general_ci; ALTER TABLE zipkin_annotations ADD UNIQUE KEY(`trace_id_high`, `trace_id`, `span_id`, `a_key`, `a_timestamp`) COMMENT 'Ignore insert on duplicate' ; ALTER TABLE zipkin_annotations ADD INDEX(`trace_id_high`, `trace_id`, `span_id`) COMMENT 'for joining with zipkin_spans' ; ALTER TABLE zipkin_annotations ADD INDEX(`trace_id_high`, `trace_id`) COMMENT 'for getTraces/ByIds' ; ALTER TABLE zipkin_annotations ADD INDEX(`endpoint_service_name`) COMMENT 'for getTraces and getServiceNames' ; ALTER TABLE zipkin_annotations ADD INDEX(`a_type`) COMMENT 'for getTraces' ; ALTER TABLE zipkin_annotations ADD INDEX(`a_key`) COMMENT 'for getTraces' ; CREATE TABLE IF NOT EXISTS zipkin_dependencies ( `day` DATE NOT NULL, `parent` VARCHAR( 255 ) NOT NULL, `child` VARCHAR( 255 ) NOT NULL, `call_count` BIGINT ) ENGINE=InnoDB ROW_FORMAT=COMPRESSED CHARACTER SET=utf8 COLLATE utf8_general_ci; ALTER TABLE zipkin_dependencies ADD UNIQUE KEY(`day`, `parent`, `child`); |
pom.xml 添加如下配置:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | <!-- zipkin storage mysql. --> <dependency> <groupId>io.zipkin.java</groupId> <artifactId>zipkin-storage-mysql</artifactId> <version> 2.4 . 1 </version><!-- 此版本与zipkin版本对应 --> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-jdbc</artifactId> </dependency> <!-- 这是mysql驱动,如果自己配置也行,加这个依赖也行 --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> </dependency> <!--/ zipkin storage mysql. --> |
配置:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | server: port: 9411 spring: datasource: schema: classpath:/mysql.sql # 已经存在数据库及其表,则可不写 url: jdbc:mysql: //localhost:3306/zipkin username: root password: root # Switch this on to create the schema on startup: initialize: true continueOnError: true sleuth: enabled: false zipkin: storage: type: mysql |
在启动类添加数据源驱动:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | package com.thunisoft.maybeesleuthcenter; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; import org.springframework.context.annotation.Bean; import zipkin.server.EnableZipkinServer; import zipkin.storage.mysql.MySQLStorage; import javax.sql.DataSource; @EnableZipkinServer @SpringBootApplication public class MaybeeSleuthcenterApplication { public static void main(String[] args) { SpringApplication.run(MaybeeSleuthcenterApplication. class , args); } @Bean public MySQLStorage mySQLStorage(DataSource datasource) { return MySQLStorage.builder().datasource(datasource).executor(Runnable::run).build(); } } |
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步