DataType Description defaultType String Default transaction type providerType (?) String Transaction provider type props (?) Properties Transaction properties 9.1. ShardingSphere-JDBC 104 Apache ShardingSphere shardingsphere:shardingsphere-cluster-mode-repository-consul, Consul based persistence • XA transaction manager provider definition – org.apache.shardingsphere:shardingsphere-transaction-xa-narayana, XA distributed based on Narayana • SQL translator – org.apache.shardingsphere:shardingsphere-sql-translator-jooq-provider, JooQ SQL translator • Row Value Expressions definition 9.1. ShardingSphere-JDBC 131 Apache

DataType Description defaultType String Default transaction type providerType (?) String Transaction provider type props (?) Properties Transaction properties HA Background Build high availability rule org.apache.shardingsphere shardingsphere-sql-translator-jooq-provider 5.2.0 • Build GraalVM Native Image /yaml-config/authentication/ ## @param compute.serverConfig.authority.privilege.type authority provider for storage node, the default value is ALL_PERMITTED ## @param compute.serverConfig.authority

DataType Description defaultType String Default transaction type providerType (?) String Transaction provider type props (?) Properties Transaction properties 9.1. ShardingSphere-JDBC 111 Apache ShardingSphere shardingsphere:shardingsphere-cluster-mode-repository-etcd, Etcd based persistence • XA transaction manager provider definition – org.apache.shardingsphere:shardingsphere-transaction-xa-narayana, XA distributed /yaml-config/authentication/ ## @param compute.serverConfig.authority.privilege.type authority provider for storage node, the default value is ALL_PERMITTED ## @param compute.serverConfig.authority

DataType Description defaultType String Default transaction type providerType (?) String Transaction provider type props (?) Properties Transaction properties 4.1. ShardingSphere-JDBC 95 Apache ShardingSphere /yaml-config/authentication/ ## @param compute.serverConfig.authority.privilege.type authority provider for storage node, the default value is ALL_PERMITTED ## @param compute.serverConfig.authority database, mapped through user-database-mappings. The administrator can choose which authority provider to use as needed when configuring the Author‐ ity Rule. Parameter rules: - !AUTHORITY users:

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 80 7.4 Job Class Name Provider . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 80 7.5 Roadmap . . . . . execution. SPI Name Description JobExecutorThreadPoolSizeProvider Job executor thread pool size provider Implementation Class Description CPUUsageJobE xecutorThreadPool‐ SizeProvider Use CPU available 4 Job Class Name Provider Job class name provider, used to provide job class name in different contain environments. SPI Name Description JobClassNameProvider Job class name provider Implementation

In Apache ShardingSphere, many functionality implementations are uploaded through SPI (Service Provider Interface), which is a kind of API for the third party to implement or expand, and can be applied ssword>, hostname is % or empty string means do not care about authorized host provider: type: # authority provider for storage node, the default value is ALL_ PERMITTED Example ALL_PERMITTED rules: - root@localhost:root - my_user@:pwd provider: type: ALL_PERMITTED DATABASE_PERMITTED rules: - !AUTHORITY users: - root@:root - my_user@:pwd provider: type: DATABASE_PERMITTED props: use

ShardingSphere document • SQL 翻译 – org.apache.shardingsphere:shardingsphere-sql-translator-jooq-provider， 使用 JooQ 的 SQL 翻译器 • 行表达式 – org.apache.shardingsphere:shardingsphere-infra-expr-espresso， 基 于 org.apache.shardingsphere shardingsphere-sql-translator-jooq-provider 5.4.0 • 通过命令行构建 GraalVM Native /yaml-config/authentication/ ## @param compute.serverConfig.authority.privilege.type authority provider for storage node, the default value is ALL_PERMITTED ## @param compute.serverConfig.authority

In Apache ShardingSphere, many functionality implementations are uploaded through SPI (Service Provider Interface), which is a kind of API for the third party to implement or expand, and can be applied ssword>, hostname is % or empty string means do not care about authorized host provider: type: # authority provider for storage node, the default value is ALL_ PRIVILEGES_PERMITTED Example ALL_PRIVILEGES_PERMITTED ALL_PRIVILEGES_PERMITTED rules: - !AUTHORITY users: - root@localhost:root - my_user@:pwd provider: type: ALL_PRIVILEGES_PERMITTED 5.2. ShardingSphere-Proxy 159 Apache ShardingSphere document, v5.1

Narayana 的 XA 分布式事务管理器 • SQL 翻译 – org.apache.shardingsphere:shardingsphere-sql-translator-jooq-provider， 使用 JooQ 的 SQL 翻译器 9.1.5 不支持项 DataSource 接口 • 不支持 timeout 相关操作。 Connection 接口 • 不支持存储过程，函数，游标的操作； org.apache.shardingsphere shardingsphere-sql-translator-jooq-provider 5.3.1 • 通过命令行构建 GraalVM Native /yaml-config/authentication/ ## @param compute.serverConfig.authority.privilege.type authority provider for storage node, the default value is ALL_PERMITTED ## @param compute.serverConfig.authority

/yaml-config/authentication/ ## @param compute.serverConfig.authority.privilege.type authority provider for storage node, the default value is ALL_PERMITTED ## @param compute.serverConfig.authority 返回值说明 列 说明 users 用户 provider 权限提供者类型 props 权限参数 示例 • 查询权限规则配置 SHOW AUTHORITY RULE; mysql> SHOW AUTHORITY RULE; +--------------------+---------------+-------+ | users | provider | props | +------ default_type 默认事务类型 provider_type 事务提供者类型 props 事务参数 示例 • 查询事务规则配置 SHOW TRANSACTION RULE; mysql> SHOW TRANSACTION RULE; +--------------+---------------+-------+ | default_type | provider_type | props |