. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 136 9.1.4 Optional Plugins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 146 9.1.5 Unsupported Items . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 411 9.2.6 Optional Plugins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 411 9.2.7 Session Management the components are required and the specific im‐ plementation method can be replaced thanks to plugins. It includes a query optimizer, distributed transaction engine, distributed execution engine, permission

bin. tar.gz -C agent cd agent tree ├── LICENSE ├── NOTICE ├── conf │ └── agent.yaml ├── plugins │ ├── lib │ │ ├── shardingsphere-agent-metrics-core-${latest.release.version}.jar │ │ └── sha ShardingSphere document 配置说明 conf/agent.yaml 用于管理 agent 配置。内置插件包括 File、Prometheus、OpenTelemetry。 plugins: # logging: # File: # props: # level: "INFO" # metrics: # Prometheus: # host: "localhost" 9.1. ShardingSphere-JDBC 140 Apache ShardingSphere document <plugins> org.graalvm.buildtools native-maven-plugin

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 124 9.1.4 Optional Plugins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 130 9.1.5 Unsupported Items . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 393 9.2.6 Optional Plugins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 394 9.2.7 Session Management the components are required and the specific im‐ plementation method can be replaced thanks to plugins. It includes a query optimizer, distributed transaction engine, distributed execution engine, permission

类型处理 类型处理 (typeHandlers) (typeHandlers) 对象工厂 对象工厂 (objectFactory) (objectFactory) 插件(plugins) 插件(plugins) 环境配置 环境配置 (environments) (environments) 数据库厂商标 数据库厂商标 识 识 (databaseIdProvider) (databaseIdProvider) configuration 配置 properties 属性 settings 设置 typeAliases 类型命名 typeHandlers 类型处理器 objectFactory 对象工厂 plugins 插件 environments 环境 environment 环境变量 transactionManager 事务管理器 dataSource 数据源 databaseIdProvider ObjectFactory，在初始化你的 ObjectFactory 实例后， objectFactory 元素体中定义的 属性会被传递给 setProperties 方法。 插件（ 插件（plugins） ） MyBatis 允许你在已映射语句执行过程中的某一点进行拦截调用。默认情况下，MyBatis 允许使用插件来拦截的方法调用包括： Executor (update, query, flushStatements

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 277 4.2.6 Optional Plugins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 278 4.2.7 Session Management the components are required and the specific im‐ plementation method can be replaced thanks to plugins. It includes a query optimizer, distributed transaction engine, distributed execution engine, permission tion_type = “XA” SET VARIABLE agent_p lugins_enabled = [TRUE / FALSE] Set whether the agent plugins are enabled, the default value is false SET VARIABLE agent_plu gins_enabled = TRUE SHOW ALL

configuration 配置 properties 属性 settings 设置 typeAliases 类型命名 typeHandlers 类型处理器 objectFactory 对象工厂 plugins 插件 environments 环境 environment 环境变量 transactionManager 事务管理器 dataSource 数据源 databaseIdProvider 继 承 org.apache.ibatis.type.BaseTypeHandler  指定其映射某个 JDBC 类型（可选操作）  在 mybatis 全局配置文件中注册 3.6 plugins 插件机制 1) 插件是 MyBatis 提供的一个非常强大的机制，我们可以通过插件来修改 MyBatis 的一些 核心行为。插件通过动态代理机制，可以介入四大对象的任何一个方法的执行 2) jar 和 jsqlparser-0.9.5.jar 2) 在 MyBatis 全局配置文件中配置分页插件 <plugins> plugins> 3) 使用 PageHelper 提供的方法进行分页 4) 可以使用更强大的 PageInfo 封装返回结果

dialects / database protocols such as MySQL, PostgreSQL, SQLServer, Oracle supported are all weaved by plugins. Developers can customize their own Shard‐ ingSphere just like building lego blocks. There are lots collection of ignored plugins, indicating that the plugins in the collection are not active - Opentracing - Jaeger - Zipkin - Prometheus - OpenTelemetry - Logging plugins: Prometheus: host: "localhost" exporter of traces Logging: props: LEVEL: "INFO" #log level When ignoredPluginNames is configured, plugins in the collection are ignored! 4.6 Scaling 4.6.1 Background There is a problem which how to migrate

bin. tar.gz -C agent cd agent tree ├── LICENSE ├── NOTICE ├── conf │ └── agent.yaml ├── plugins │ ├── lib │ │ ├── shardingsphere-agent-metrics-core-${latest.release.version}.jar 9.1. ShardingSphere-JDBC agent/logs/stdout.log。 配置说明 conf/agent.yaml 用于管理 agent 配置。内置插件包括 File、Prometheus、OpenTelemetry。 plugins: # logging: # File: # props: # level: "INFO" # metrics: # Prometheus: # host: "localhost" actId> ${shardingsphere.version} <plugins> org.graalvm.buildtools native-maven-plugin

the components are required and the specific im‐ plementation method can be replaced thanks to plugins. It includes a query optimizer, distributed transaction engine, distributed execution engine, permission BASE SET VARIABLE trans ac‐ tion_type = “XA” SET VARIABLE agent_ plugins_enabled = [TRUE / FALSE] Set whether the agent plugins are enabled, the default value is false SET VARIABLE agent_plug ins_enabled version}-shardingsphere-agent-bin ├── LICENSE ├── NOTICE ├── conf │ ├── agent.yaml │ └── logback.xml ├── plugins │ ├── shardingsphere-agent-logging-base-${latest.release.version}.jar │ ├── shardingsphere-age

dialects / database protocols such as MySQL, PostgreSQL, SQLServer, Oracle supported are all weaved by plugins. Developers can customize their own ShardingSphere just like building lego blocks. There are lots ignoredPluginNames: # A collec‐ tion of ignored plugins, indicating that the plugins in the collection are not active ‐ Opentracing ‐ Jaeger ‐ Zipkin ‐ Prometheus ‐ Logging plugins: Prometheus: host: “localhost”#prometheus #zipkin uri Logging: props: LEVEL: “INFO”#log level ˋˋ When ignoredPluginNames is configured, plugins in the collection are ignored! 3.5 Scaling 3.5.1 Background Apache ShardingSphere provides data