skywalkingmysql配置_SkyWalking后端服务存储配置

更新时间:2023-05-16 03:41:42 阅读: 评论:0

skywalkingmysql配置_SkyWalking后端服务存储配置
版本:7.0.0
描述
采集的数据需要存储,提供给相关⼈员查看系统调⽤链路信息,因此需要配置存储项。
⼀般在本地尝鲜可以使⽤默认的h2数据库。可以很快的部署SkyWalking服务,体验相关功能。
开发环境可以使⽤MySQL数据库。
测试和⽣产环境建议使⽤elasticarch。
配置
在l⾥⾯,配置storage模块。
具体配置项如下:
lector:存储选择器
elasticarch:elasticarch6.X以下配置项
nameSpace:命名空间,如:SkyWalking
clusterNodes:集群节点,如:localhost:9200
protocol:协议,如:HTTPpullman
trustStorePath:SSL配置路径
trustStorePass:SSL配置,7.0.0之后可以在cretsManagementFile⾥⾯管理
ur:⽤户名,7.0.0之后可以在cretsManagementFile⾥⾯管理
password:密码,7.0.0之后可以在cretsManagementFile⾥⾯管理
cretsManagementFile:安全管理⽂件
enablePackedDownsampling:如果开启,则采样索引(⼩时和天精度)将向下合并到分钟索引中,es7.0.0的⼀个增强功能,降低50%的索引数(移除了天和⼩时的索引需求),但是性能和之前的⼏乎⼀致。对于es6.x版本的影响只是保持⼩时和天的索引,⽤户需要⼿动移除他们。
dayStep:es6.x版本,分钟/⼩时/⽉粒度的指标和追踪索引被整合到天⾥⾯,ES每天创建⼀个新的索引。
indexShardsNumber:索引分⽚数
indexReplicasNumber:索引备份数
顶尖套
recordDataTTL:记录有效时长
otherMetricsDataTTL:其他指标有效时长(分钟/⼩时/天)
monthMetricsDataTTL:⽉度指标有效时长
bulkActions:批量操作数
flushInterval:刷盘间隔时间
concurrentRequests:并发请求数
resultWindowMaxSize:结果窗⼝最⼤值
metadataQueryMaxSize:元数据查询最⼤值
gmentQueryMaxSize:追踪段最⼤查询数
profileTaskQueryMaxSize:性能剖析最⼤查询数
advanced:
elasticarch7:elasticarch7.X以下配置项
nameSpace:命名空间
clusterNodes:集群节点
protocol:协议
trustStorePath:SSL⽂件路径
trustStorePass:SSL PASS项,7.0.0之后可以在cretsManagementFile⾥⾯管理
enablePackedDownsampling: 如果开启,则采样索引(⼩时和天精度)将向下合并到分钟索引中,es7.0.0的⼀个增强功能,降低50%的索引数(移除了天和⼩时的索引需求),但是性能和之前的⼏乎⼀致。
somebody needs youdayStep:
ur:⽤户名,7.0.0之后可以在cretsManagementFile⾥⾯管理
password:密码,7.0.0之后可以在cretsManagementFile⾥⾯管理
cretsManagementFile:安全管理⽂件
indexShardsNumber:分⽚数
indexReplicasNumber:副本数
recordDataTTL:记录有效时长
otherMetricsDataTTL:其他指标有效时长(分钟/⼩时/天)
monthMetricsDataTTL:⽉度指标有效时长
bulkActions:批量操作数
flushInterval:刷盘间隔时间
concurrentRequests:并发请求数lvds
resultWindowMaxSize:结果窗⼝最⼤值
a good yearmetadataQueryMaxSize:元数据查询最⼤值
gmentQueryMaxSize:追踪段最⼤查询数
profileTaskQueryMaxSize:性能剖析最⼤查询数
advanced:
roughlyh2:h2把内存数据库
driver:驱动
url:数据库URL
ur:⽤户名
metadataQueryMaxSize:查询最⼤值
mysql:MySQL数据库
properties:
jdbcUrl:连接URL
dataSource.ur:⽤户名
dataSource.password:密码
dataSource.cachePrepStmts:预加载缓存
dataSource.prepStmtCacheSize:预加载缓存⼤⼩dataSource.prepStmtCacheSqlLimit:预加载SQL限制dataSource.uServerPrepStmts:开启服务端预加载机制metadataQueryMaxSize:最⼤查询数
influxdb:
metabaType:数据库类型(⽬前可选择:h2, mysql)
h2Props:
dataSourceClassName:数据库驱动
dataSource.url:数据库URL
dataSource.ur:⽤户名
dataSource.password:密码
mysqlProps:
jdbcUrl:连接URL
dataSource.ur:⽤户名
dataSource.password:密码
dataSource.cachePrepStmts:预加载缓存
dataSource.prepStmtCacheSize:预加载缓存⼤⼩dataSource.prepStmtCacheSqlLimit:预加载SQL限制dataSource.uServerPrepStmts:开启服务端预加载机制metadataQueryMaxSize:最⼤查询数
url:InfluxDB连接URL
ur:InfluxDB⽤户名
password:InfluxDB密码
databa:InfluxDB数据库
actions:InfluxDB收集活动数
duration:InfluxDB等待时长
fetchTaskLogMaxSize:请求中提取任务⽇志的最⼤数量
⽰例
具体配置在 l 的 storage 模块 。 可以看出,配置项都是可以使⽤运⾏时参数替换的,也就是说,这些配置都可以在运⾏时指定参数。梦想照进现实
⼀般除了连接项,如IP,端⼝,⽤户名,密码这样的必须指定的配置项,其他配置建议使⽤默认值。
storage:
lector: ${SW_STORAGE:h2}
elasticarch:
nameSpace: ${SW_NAMESPACE:"skywalking"}
clusterNodes: ${SW_STORAGE_ES_CLUSTER_NODES:172.18.20.107:9220}
protocol: ${SW_STORAGE_ES_HTTP_PROTOCOL:"http"}
trustStorePath: ${SW_SW_STORAGE_ES_SSL_JKS_PATH:"../es_keystore.jks"}
trustStorePass: ${SW_SW_STORAGE_ES_SSL_JKS_PASS:""}
ur: ${SW_ES_USER:""}
password: ${SW_ES_PASSWORD:""}
cretsManagementFile: ${SW_ES_SECRETS_MANAGEMENT_FILE:""} # Secrets management file in the properties format includes the urname, password, which are managed by 3rd party tool.
enablePackedDownsampling: ${SW_STORAGE_ENABLE_PACKED_DOWNSAMPLING:true} # Hour and Day metrics will be merged into minute index.
dayStep: ${SW_STORAGE_DAY_STEP:1} # Reprent the number of days in the one minute/hour/
day index.
indexShardsNumber: ${SW_STORAGE_ES_INDEX_SHARDS_NUMBER:2}
indexReplicasNumber: ${SW_STORAGE_ES_INDEX_REPLICAS_NUMBER:0}
# Tho data TTL ttings will override the same ttings in core module.
platform是什么意思recordDataTTL: ${SW_STORAGE_ES_RECORD_DATA_TTL:7} # Unit is day
otherMetricsDataTTL: ${SW_STORAGE_ES_OTHER_METRIC_DATA_TTL:45} # Unit is day
monthMetricsDataTTL: ${SW_STORAGE_ES_MONTH_METRIC_DATA_TTL:18} # Unit is month
bulkActions: ${SW_STORAGE_ES_BULK_ACTIONS:1000} # Execute the bulk every 1000 requests
flushInterval: ${SW_STORAGE_ES_FLUSH_INTERVAL:10} # flush the bulk every 10 conds whatever the number of requests
concurrentRequests: ${SW_STORAGE_ES_CONCURRENT_REQUESTS:2} # the number of concurrent requests
resultWindowMaxSize: ${SW_STORAGE_ES_QUERY_MAX_WINDOW_SIZE:10000}
metadataQueryMaxSize: ${SW_STORAGE_ES_QUERY_MAX_SIZE:5000}
gmentQueryMaxSize: ${SW_STORAGE_ES_QUERY_SEGMENT_SIZE:200}
profileTaskQueryMaxSize: ${SW_STORAGE_ES_QUERY_PROFILE_TASK_SIZE:200}
advanced: ${SW_STORAGE_ES_ADVANCED:""}
elasticarch7:
nameSpace: ${SW_NAMESPACE:""}
clusterNodes: ${SW_STORAGE_ES_CLUSTER_NODES:localhost:9200}
protocol: ${SW_STORAGE_ES_HTTP_PROTOCOL:"http"}
trustStorePath: ${SW_SW_STORAGE_ES_SSL_JKS_PATH:"../es_keystore.jks"}
trustStorePass: ${SW_SW_STORAGE_ES_SSL_JKS_PASS:""}
enablePackedDownsampling: ${SW_STORAGE_ENABLE_PACKED_DOWNSAMPLING:true} # Hour and Day metrics will be merged into minute index.
dayStep: ${SW_STORAGE_DAY_STEP:1} # Reprent the number of days in the one minute/hour/day index.
ur: ${SW_ES_USER:""}
password: ${SW_ES_PASSWORD:""}
cretsManagementFile: ${SW_ES_SECRETS_MANAGEMENT_FILE:""} # Secrets management file in the properties format includes the urname, password, which are managed by 3rd party tool.
indexShardsNumber: ${SW_STORAGE_ES_INDEX_SHARDS_NUMBER:2}
indexReplicasNumber: ${SW_STORAGE_ES_INDEX_REPLICAS_NUMBER:0}
绿色的英语# Tho data TTL ttings will override the same ttings in core module.
recordDataTTL: ${SW_STORAGE_ES_RECORD_DATA_TTL:7} # Unit is day
otherMetricsDataTTL: ${SW_STORAGE_ES_OTHER_METRIC_DATA_TTL:45} # Unit is day
monthMetricsDataTTL: ${SW_STORAGE_ES_MONTH_METRIC_DATA_TTL:18} # Unit is month
bulkActions: ${SW_STORAGE_ES_BULK_ACTIONS:1000} # Execute the bulk every 1000 requests
flushInterval: ${SW_STORAGE_ES_FLUSH_INTERVAL:10} # flush the bulk every 10 conds whatever the number of requests
concurrentRequests: ${SW_STORAGE_ES_CONCURRENT_REQUESTS:2} # the number of concurrent requests
resultWindowMaxSize: ${SW_STORAGE_ES_QUERY_MAX_WINDOW_SIZE:10000}
metadataQueryMaxSize: ${SW_STORAGE_ES_QUERY_MAX_SIZE:5000}
gmentQueryMaxSize: ${SW_STORAGE_ES_QUERY_SEGMENT_SIZE:200}
profileTaskQueryMaxSize: ${SW_STORAGE_ES_QUERY_PROFILE_TASK_SIZE:200}
advanced: ${SW_STORAGE_ES_ADVANCED:""}face time
h2:
driver: ${SW_STORAGE_H2_DRIVER:org.h2.jdbcx.JdbcDataSource}
url: ${SW_STORAGE_H2_URL:jdbc:h2:mem:skywalking-oap-db}
ur: ${SW_STORAGE_H2_USER:sa}
metadataQueryMaxSize: ${SW_STORAGE_H2_QUERY_MAX_SIZE:5000}
mysql:
properties:
jdbcUrl: ${SW_JDBC_URL:"jdbc:mysql://localhost:3306/swtest"}
dataSource.ur: ${SW_DATA_SOURCE_USER:root}

本文发布于:2023-05-16 03:41:42,感谢您对本站的认可!

本文链接:https://www.wtabcd.cn/fanwen/fan/90/110136.html

版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系,我们将在24小时内删除。

上一篇:汇编作业集锦
下一篇:cuba说明
标签:配置   数据库   加载   需要   查询   服务   功能   请求
相关文章
留言与评论(共有 0 条评论)
   
验证码:
Copyright ©2019-2022 Comsenz Inc.Powered by © 专利检索| 网站地图