将zipkin追踪信息保存到数据库（只需修改zipkin server即可）

1 引入mysql数据库依赖

<!-- 配置mysql -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>

2 在配置文件msql连接

spring: 
 sleuth: 
  enabled: false #表示当前程序不使用sleuth
 datasource: #配置msyql 连接
  schema[0]: classpath:/zipkin.sql #数据库创建脚本，可以到官网下载
  url: jdbc:mysql://localhost:3306/zipkin?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&useSSL=false  
  username: root
  password: root
  driver-class-name: com.mysql.jdbc.Driver 
  initialize: true
  continue-on-error: true
zipkin: 
 storage: 
  type: mysql #mysql存储zipkin追踪信息

3 创建数据库和表

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';  
    ALTER TABLE zipkin_annotations ADD INDEX(`trace_id`, `span_id`, `a_key`) COMMENT 'for dependencies job';  
      
    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`);