SkyWalking

mysql的驅動依賴

選擇下載版本 v9.4

?現在后解壓縮目錄結構

一、修改config目錄文件?application.yml

修改1：

? selector: ${SW_STORAGE:h2}?

修改后：

? selector: ${SW_STORAGE:mysql}?

?修改2：使用mysql數據庫

? mysql:
? ? properties:
? ? ? jdbcUrl: ${SW_JDBC_URL:"jdbc:mysql://localhost:3306/swtest?rewriteBatchedStatements=true&allowMultiQueries=true"}
? ? ? dataSource.user: ${SW_DATA_SOURCE_USER:root}
? ? ? dataSource.password: ${SW_DATA_SOURCE_PASSWORD:root@1234}
? ? ? dataSource.cachePrepStmts: ${SW_DATA_SOURCE_CACHE_PREP_STMTS:true}
? ? ? dataSource.prepStmtCacheSize: ${SW_DATA_SOURCE_PREP_STMT_CACHE_SQL_SIZE:250}
? ? ? dataSource.prepStmtCacheSqlLimit: ${SW_DATA_SOURCE_PREP_STMT_CACHE_SQL_LIMIT:2048}
? ? ? dataSource.useServerPrepStmts: ${SW_DATA_SOURCE_USE_SERVER_PREP_STMTS:true}
? ? metadataQueryMaxSize: ${SW_STORAGE_MYSQL_QUERY_MAX_SIZE:5000}
? ? maxSizeOfBatchSql: ${SW_STORAGE_MAX_SIZE_OF_BATCH_SQL:2000}
? ? asyncBatchPersistentPoolSize: ${SW_STORAGE_ASYNC_BATCH_PERSISTENT_POOL_SIZE:4}

修改 jdbcUrl、dataSource.user、dataSource.password 節點 后

jdbcUrl: ${SW_JDBC_URL:"jdbc:mysql://localhost:3306/skywalking?rewriteBatchedStatements=true&allowMultiQueries=true"} # mysql連接字符串，skywalking為mysql數據庫名稱
dataSource.user: ${SW_DATA_SOURCE_USER:root} # 更新為自己的mysql數據庫用戶名
dataSource.password: ${SW_DATA_SOURCE_PASSWORD:root} # 更新為自己的mysql數據庫密碼

?? mysql:
? ? properties:
? ? ? jdbcUrl: ${SW_JDBC_URL:"jdbc:mysql://localhost:3306/skywalking?rewriteBatchedStatements=true&allowMultiQueries=true"}
? ? ? dataSource.user: ${SW_DATA_SOURCE_USER:root}
? ? ? dataSource.password: ${SW_DATA_SOURCE_PASSWORD:123456}
? ? ? dataSource.cachePrepStmts: ${SW_DATA_SOURCE_CACHE_PREP_STMTS:true}
? ? ? dataSource.prepStmtCacheSize: ${SW_DATA_SOURCE_PREP_STMT_CACHE_SQL_SIZE:250}
? ? ? dataSource.prepStmtCacheSqlLimit: ${SW_DATA_SOURCE_PREP_STMT_CACHE_SQL_LIMIT:2048}
? ? ? dataSource.useServerPrepStmts: ${SW_DATA_SOURCE_USE_SERVER_PREP_STMTS:true}
? ? metadataQueryMaxSize: ${SW_STORAGE_MYSQL_QUERY_MAX_SIZE:5000}
? ? maxSizeOfBatchSql: ${SW_STORAGE_MAX_SIZE_OF_BATCH_SQL:2000}
? ? asyncBatchPersistentPoolSize: ${SW_STORAGE_ASYNC_BATCH_PERSISTENT_POOL_SIZE:4}

二、可選，修改SkyWalking UI端口

?修改webapp目錄application.yml

可修改serverPort??節點端口號，默認8080

# Licensed to the Apache Software Foundation (ASF) under one or more
# contributor license agreements. ?See the NOTICE file distributed with
# this work for additional information regarding copyright ownership.
# The ASF licenses this file to You under the Apache License, Version 2.0
# (the "License"); you may not use this file except in compliance with
# the License. ?You may obtain a copy of the License at
#
# ? ? http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.

serverPort: ${SW_SERVER_PORT:-8080}

# Comma seperated list of OAP addresses.
oapServices: ${SW_OAP_ADDRESS:-http://localhost:12800}

zipkinServices: ${SW_ZIPKIN_ADDRESS:-http://localhost:9412}
?

三、現在mysql依賴驅動包，復制到目錄oap-libs下

?mysql-connector-java

四、運行bin目錄startup.bat

?打開?http://localhost:8080/

?