Spring Cloud入门教程-使用rabbitMQ传输链路数据，储存到MySQL

《一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码》，点击传送门，即可获取！

ALTER TABLE zipkin_spans ADD INDEX(trace_id_high, trace_id, id) COMMENT ‘forjoining with zipkin_annotations’;

ALTER TABLE zipkin_spans ADD INDEX(trace_id_high, trace_id) COMMENT ‘forgetTracesByIds’;

ALTER TABLE zipkin_spans ADD INDEX(name) COMMENT ‘for getTraces and getSpanNames’;

ALTER TABLE zipkin_spans ADD INDEX(start_ts) COMMENT ‘for getTraces ordering andrange’;

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 64bit’,

trace_id BIGINT NOT NULL COMMENT ‘coincideswith zipkin_spans.trace_id’,

span_id BIGINT NOT NULL COMMENT ‘coincideswith 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 toimplement TTL; Annotation.timestamp or zipkin_spans.timestamp’,

endpoint_ipv4 INT COMMENT ‘Null whenBinary/Annotation.endpoint is null’,

endpoint_ipv6 BINARY(16) COMMENT ‘Null whenBinary/Annotation.endpoint is null, or no IPv6 address’,

endpoint_port SMALLINT COMMENT ‘Null whenBinary/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 ‘forgetTraces/ByIds’;

ALTER TABLE zipkin_annotations ADD INDEX(endpoint_service_name) COMMENT ‘forgetTraces 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 ‘fordependencies 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);

修改eureka-client-zipkin 项目添加rabbitMQ 依赖

org.springframework.cloud

spring-cloud-stream-binder-rabbit

增加配置：

spring.rabbitmq.host=localhost

spring.rabbitmq.port=5672

spring.rabbitmq.password=guest

spring.rabbitmq.username=guest

zipkin链接方式

spring.zipkin.sender.type=rabbit

#是否启动zipkin，默认为true

spring.zipkin.enabled=true

支持通过服务发现来定位host name：

spring.zipkin.locator.discovery.enabled=true

重新启动项目eureka-client-zipkin。

使用 以下命令重新启动zipkin-server-xxx.jar :

最后

总而言之，面试官问来问去，问的那些Redis知识点也就这么多吧，复习的不够到位，知识点掌握不够熟练，所以面试才会卡壳。将这些Redis面试知识解析以及我整理的一些学习笔记分享出来给大家参考学习

还有更多学习笔记面试资料也分享如下：

《一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码》，点击传送门，即可获取！
资料也分享如下：

[外链图片转存中…(img-4NH4YREL-1714660710593)]

《一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码》，点击传送门，即可获取！