默认情况下，Zipkin Server 都会将跟踪信息存储在内存中，每次重启 Zipkin Server 都会使得之前收集的跟踪信息丢失，而且当有大量跟踪信息时我们的内存存储也会成为瓶颈。

所有正常情况下我们都需要将跟踪信息对接到外部存储组件（比如 MySQL、Elasticsearch）中去。本文首先介绍如何使用 MySQL 实现 Zipkin 的数据持久化。

首先创建一个名为 zipkin 的数据库，如何到Github上下载MySQL脚本，执行创建表结构

1. 使用jar包运行zipkin

下载最新的zipkin

https://search.maven.org/remote_content?g=io.zipkin&a=zipkin-server&v=LATEST&c=exec

运行

java -jar -DSTORAGE_TYPE=mysql  -DMYSQL_HOST=localhost -DMYSQL_TCP_PORT=3306  -DMYSQL_USER=root -DMYSQL_PASS=123456 -DMYSQL_DB=zipkin zipkin-server-2.23.2-exec.jar

可以看到zipkin_spans表中有了数据

mysql> select * from zipkin_spans where name = 'get /students/{schoolname}';
+---------------+---------------------+---------------------+----------------------------+---------------------+---------------------+--------------+------------------+----------+
| trace_id_high | trace_id            | id                  | name                       | remote_service_name | parent_id           | debug        | start_ts         | duration |
+---------------+---------------------+---------------------+----------------------------+---------------------+---------------------+--------------+------------------+----------+
|             0 | 5269165354849432675 | 1242664465845218647 | get /students/{schoolname} |                     | 5269165354849432675 | 0x           | 1610428616435867 |   237893 |
|             0 | 5269165354849432675 | 5269165354849432675 | get /students/{schoolname} |                     |                NULL | 0x           | 1610428616414131 |   265520 |
+---------------+---------------------+---------------------+----------------------------+---------------------+---------------------+--------------+------------------+----------+
2 rows in set (0.00 sec)

2. 使用docker运行

docker run --name zipkin -d -p 9411:9411 -e STORAGE_TYPE=mysql -e  MYSQL_HOST=localhost -e MYSQL_TCP_PORT=3306 -e MYSQL_USER=root -e  MYSQL_PASS=123456 -e MYSQL_DB=zipkin openzipkin/zipkin

也可以使用docker-compose.yml启动

version: '2'

services:
  zipkin:
    image: openzipkin/zipkin
    container_name: zipkin
    environment:
      - STORAGE_TYPE=mysql
      - MYSQL_HOST=192.168.60.1
      - MYSQL_TCP_PORT=3306
      - MYSQL_USER=root
      - MYSQL_PASS=hangge1234
      - MYSQL_DB=zipkin
      #- RABBIT_ADDRESSES=192.168.60.133:5672
      #- RABBIT_USER=hangge
      #- RABBIT_PASSWORD=123
    ports:
      - 9411:9411

我使用本地的MySQL测试，发现zipkin连接不上MySQL，报下面错误，看issue可能是mariadb-client的版本不对

Caused by: java.lang.NoClassDefFoundError: Could not initialize class org.mariadb.jdbc.internal.com.send.authentication.SendGssApiAuthPacket at jdk.internal.reflect.GeneratedConstructorAccessor26.newInstance(Unknown Source) ~[?:?] at jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[?:?] at java.lang.reflect.Constructor.newInstanceWithCaller(Unknown Source) ~[?:?] at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:?]

最终我使用官方提供的docker-compose.yml测试成功

最后更新：

1. 使用jar包运行zipkin

2. 使用docker运行