. . . . . . . . . . . . . 346 7.8.4 [Proxy] In Windows environment, could not find or load main class org.apache.shardingsphere.proxy.Bootstrap, how to solve it? . . . . . . . . . . . 346 7.8.5 [Proxy] Reading table information for completion of table and column names │Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A "/api/v2/spans" SAMPLER_TYPE: "const" SAMPLER_PARAM: "1" OpenTracing: props: OPENTRACING_TRACER_CLASS_NAME: "org.apache.skywalking.apm.toolkit. opentracing.SkywalkingTracer" OpenTelemetry: props:

. . . . . . . . . . . 304 7.7.4 4. [Proxy] In Windows environment, could not find or load main class org.apache.shardingsphere.proxy.Bootstrap, how to solve it? . . . . . . . . . . . 304 7.7.5 5. [Proxy] system parameters Add startup arguments -Dorg.apache.shardingsphere.tracing.opentracing.tracer.class=org.apache.skywalking. apm.toolkit.opentracing.SkywalkingTracer Call initialization method ShardingTracer "shardingsphere-agent" URL_VERSION: "/api/v2/spans" #zipkin uri Opentracing: props: OPENTRACING_TRACER_CLASS_NAME: "org.apache.skywalking.apm.toolkit. opentracing.SkywalkingTracer" OpenTelemetry: props:

. . . . . . . . . . . . . 358 7.8.4 [Proxy] In Windows environment, could not find or load main class org.apache.shardingsphere.proxy.Bootstrap, how to solve it? . . . . . . . . . . . 358 7.8.5 [Proxy] version} to the actual version. 3. Edit application.yml. spring: shardingsphere: datasource: names: ds_0, ds_1 ds_0: type: com.zaxxer.hikari.HikariDataSource driverClassName: com.mysql.cj.jdbc.Driver Reading table information for completion of table and column names │Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A

. . . . . . . . . . . . . . . . . 298 7.14 In Windows environment, could not find or load main class org.apache.shardingsphere.proxy.Bootstrap, how to solve it? . . . . . . . . . . . . . . . 298 7 Sources Configuration Real data sources list. Tables Configuration Configurations of logic table names, data node and table sharding rules. Data Node Configuration It is used in the configurations of it requires to rewrite logic table names in sharding settings into actual table names acquired after routing. Database sharding does not require to rewrite table names. In addition to that, there are also

StandalonePersistRepository . . . . . . . . . . . . . . . . . . . . . . . . . . . . 293 Fully‐qualified class name . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 293 Definition . . . . . . . . ClusterPersistRepository . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 294 Fully‐qualified class name . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 294 Definition . . . . . . . . GovernanceWatcher . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 294 Fully‐qualified class name . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 294 Definition . . . . . . . .

StandalonePersistRepository . . . . . . . . . . . . . . . . . . . . . . . . . . . . 320 Fully‐qualified class name . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 320 Definition . . . . . . . . ClusterPersistRepository . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 321 Fully‐qualified class name . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 321 Definition . . . . . . . . GovernanceWatcher . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 321 Fully‐qualified class name . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 321 Definition . . . . . . . .

1：通过读取系统参数注入 APM 系统提供的 Tracer 实现类 启动时添加参数 -Dorg.apache.shardingsphere.tracing.opentracing.tracer.class=org.apache.skywalking. apm.toolkit.opentracing.SkywalkingTracer 调用初始化方法 4.5. 分布式治理 51 Apache ShardingSphere URL_VERSION: "/api/v2/spans" #zipkin 服务的抓取 span 的 uri Opentracing: props: OPENTRACING_TRACER_CLASS_NAME: "org.apache.skywalking.apm.toolkit. opentracing.SkywalkingTracer" OpenTelemetry: props: shardingsphere.datasource.names=ds0,ds1 # 配置第 1 个数据源 spring.shardingsphere.datasource.ds0.type=com.zaxxer.hikari.HikariDataSource spring.shardingsphere.datasource.ds0.driver-class-name=com.mysql.jdbc.Driver

1：通过读取系统参数注入 APM 系统提供的 Tracer 实现类 启动时添加参数 -Dorg.apache.shardingsphere.tracing.opentracing.tracer.class=org.apache.skywalking. apm.toolkit.opentracing.SkywalkingTracer 调用初始化方法 ShardingTracer.init(); shardingsphere.datasource.names=ds0,ds1 # 配置第 1 个数据源 spring.shardingsphere.datasource.ds0.type=com.zaxxer.hikari.HikariDataSource spring.shardingsphere.datasource.ds0.driver-class-name=com.mysql.jdbc.Driver datasource.ds1.type=com.zaxxer.hikari.HikariDataSource spring.shardingsphere.datasource.ds1.driver-class-name=com.mysql.jdbc.Driver spring.shardingsphere.datasource.ds1.jdbc-url=jdbc:mysql://localhost:3306/ds1

StandalonePersistRepository . . . . . . . . . . . . . . . . . . . . . . . . . . . . 440 Fully‐qualified class name . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 440 Definition . . . . . . . . ClusterPersistRepository . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 441 Fully‐qualified class name . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 441 Definition . . . . . . . . DatabaseTypedSQLParserFacade . . . . . . . . . . . . . . . . . . . . . . . . . . 442 Fully‐qualified class name . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 442 Definition . . . . . . . .

Reading table information for completion of table and column names │Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A "/api/v2/spans" SAMPLER_TYPE: "const" SAMPLER_PARAM: "1" OpenTracing: props: OPENTRACING_TRACER_CLASS_NAME: "org.apache.skywalking.apm.toolkit. opentracing.SkywalkingTracer" OpenTelemetry: props: sphere-agent.jar \ 4.10. 可观察性 64 Apache ShardingSphere document, v5.1.1 -classpath ${CLASS_PATH} ${MAIN_CLASS} >> ${STDOUT_FILE} 2>&1 & • 启动插件 通过改造后的 ShardingSphere‐Proxy 的启动脚本启动。 bin/start.sh 正常启动可以在对应的