to speed up the metadata loading when service starts up? . . . . . . 585 13.6.8 Other The ANTLR plugin generates codes in the same level directory as src, which is easy to commit by mistake. How to avoid with flexibility thanks to custom systems based on multi‐level (kernel, feature, and ecosystem) plugin capabilities. 1.3. Advantages 3 2 Design Philosophy ShardingSphere adopts the database plus design 6 Core Concept Agent Based on bytecode enhancement and plugin design to provide tracing, metrics and logging features. Only after the plugin of the Agent is enabled, the monitoring indicator data can

to speed up the metadata loading when service starts up? . . . . . . 555 13.6.8 Other The ANTLR plugin generates codes in the same level directory as src, which is easy to commit by mistake. How to avoid with flexibility thanks to custom systems based on multi‐level (kernel, feature, and ecosystem) plugin capabilities. 1.3. Advantages 3 2 Design Philosophy ShardingSphere adopts the database plus design 6 Core Concept Agent Based on bytecode enhancement and plugin design to provide tracing, metrics and logging features. Only after the plugin of the Agent is enabled, the monitoring indicator data can

How to speed up the metadata loading when service starts up? . . . . . . 502 8.6.8 Other The ANTLR plugin generates codes in the same level directory as src, which is easy to commit by mistake. How to avoid with flexibility thanks to custom systems based on multi‐level (kernel, feature, and ecosystem) plugin capabilities. 1.2 Design Philosophy ShardingSphere adopts the database plus design philosophy, 6 Core Concept Agent Based on bytecode enhancement and plugin design to provide tracing, metrics and logging features. Only after the plugin of the Agent is enabled, the monitoring indicator data can

How to speed up the metadata loading when service starts up? . . . . . . 463 8.6.8 Other The ANTLR plugin generates codes in the same level directory as src, which is easy to commit by mistake. How to avoid JDBC and a Proxy, and its core adopts a micro‐ kernel and pluggable architecture. Thanks to its plugin‐oriented architecture, features can be flexibly expanded at will. The project is committed to providing with flexibility thanks to custom systems based on multi‐level (kernel, feature, and ecosystem) plugin capabilities. 1.1. What is ShardingSphere 3 Apache ShardingSphere document, v5.2.0 1.1.4 Roadmap

VARCHAR(128) NOT NULL COMMENT 'undo_log context,such as serialization', `rollback_info` LONGBLOB NOT NULL COMMENT 'rollback info', `log_status` INT(11) NOT NULL COMMENT '0:normal status,1:defense status', 的 jdbcURL 的识别适配 除了以上可选插件外，ShardingSphere 社区开发者还贡献了大量的插件实现，可以在 ShardingSphere Plugin 仓库中查看插件的使用说明，ShardingSphere Plugin 仓库中的插件会和 ShardingSphere 保持相 同的发布节奏，可以在 https://central.sonatype.com/ 进行检索，并安装到 version}.jar 9.1. ShardingSphere-JDBC 120 Apache ShardingSphere document │ │ └── shardingsphere-agent-plugin-core-${latest.release.version}.jar │ ├── logging │ │ └── shardingsphere-agent-logging-file-${latest

onfig.yaml? placeholder-type=system_props 其他实现 具体可参考 https://github.com/apache/shardingsphere‐plugin 。 Spring Boot 简介 ShardingSphere 提供 JDBC 驱动，开发者可以在 Spring Boot 中配置 ShardingSphereDriver 来使用 ShardingSphere。 VARCHAR(128) NOT NULL COMMENT 'undo_log context,such as serialization', `rollback_info` LONGBLOB NOT NULL COMMENT 'rollback info', `log_status` INT(11) NOT NULL COMMENT '0:normal status,1:defense status ' 解 析 的 Hive 方言实现 除了以上可选插件外，ShardingSphere 社区开发者还贡献了大量的插件实现，可以在 ShardingSphere Plugin 仓库中查看插件的使用说明，ShardingSphere Plugin 仓库中的插件会和 ShardingSphere 保持相 同的发布节奏，可以手动打包安装到 ShardingSphere 中。 9.1. ShardingSphere-JDBC

to speed up the metadata loading when service starts up? . . . . . 366 7.8.28 [Other] The ANTLR plugin generates codes in the same level directory as src, which is easy to commit by mistake. How to avoid bytecode enhance and plug‐in design to provide tracing, metrics and logging features. Enable the plugin in agent to collect data and send data to the integrated 3rd APM system. 4.10. Observability 66 attributes: "service.name=shardingsphere-agent" otel.traces.exporter: "zipkin" Logging: props: LEVEL: "INFO" • Parameter description: 4.10. Observability 68 Apache ShardingSphere document, v5.1.2 Name Descrip-

to speed up the metadata loading when service starts up? . . . . . 354 7.8.28 [Other] The ANTLR plugin generates codes in the same level directory as src, which is easy to commit by mistake. How to avoid bytecode enhance and plug‐in design to provide tracing, metrics and logging features. Enable the plugin in agent to collect data and send data to the integrated 3rd APM system. APM APM is the abbreviation attributes: "service.name=shardingsphere-agent" otel.traces.exporter: "zipkin" Logging: props: LEVEL: "INFO" • Parameter description: 4.10. Observability 65 Apache ShardingSphere document, v5.1.1 Name Descrip-

VARCHAR(128) NOT NULL COMMENT 'undo_log context,such as serialization', `rollback_info` LONGBLOB NOT NULL COMMENT 'rollback info', `log_status` INT(11) NOT NULL COMMENT '0:normal status,1:defense status', ShardingSphere document, v5.2.0 其他 语句 说明 示例 SHOW INSTANCE INFO 查询当前 proxy 的实例信息 SHOW INSTANCE INFO SHOW MODE INFO 查询当前 proxy 的 mode 配置 SHOW MODE INFO COUNT DATABASE RULES [FROM database] 查询 database 中的规则数量 驱动处理方式同上。 5. 启动 ShardingSphere‐Proxy： sh bin/start.sh 6. 查看 proxy 日志 logs/stdout.log，看到日志中出现： [INFO ] [main] o.a.s.p.frontend.ShardingSphereProxy - ShardingSphere-Proxy start success 确认启动成功。 7. 按需配置迁移

exporter: "zipkin" Logging: 4.10. 可观察性 64 Apache ShardingSphere document, v5.1.2 props: LEVEL: "INFO" • 参数说明； 名称 说明 取值范围 默认值 JVM _INFOR‐ MATION_CO LLEC‐ TOR_ENABLED 是 否 开 启 JVM 采集器 true、false • 启动插件 通过改造后的 ShardingSphere‐Proxy 的启动脚本启动。 bin/start.sh 正常启动可以在对应的 ShardingSphere‐Proxy 日志查看到 plugin 的启动日志，访问 Proxy 后，可以通过 配置的地址查看到 Metric 和 Tracing 的数据。 4.10. 可观察性 66 5 用户手册 本章节面向 Apache ShardingSphere VARCHAR(128) NOT NULL COMMENT 'undo_log context,such as serialization', `rollback_info` LONGBLOB NOT NULL COMMENT 'rollback info', `log_status` INT(11) NOT NULL COMMENT '0:normal status,1:defense status',