database solution based on the underlying database, which can scale computing and storage horizontally. D is tr ib ut ed T ra ns ac ti on Transactional capability is key to ensuring database integrity and pagination, sorting, and aggregation queries. In terms of business implementation, it can enable R&D personnel to no longer care about the scope of SQL usage, focus on business function development, and shardingsphere.infra.config.mode.ModeConfiguration Attributes: • N a m e * Da taType Description D ef au lt Va lu e t y p e String Type of mode configu‐ rationValues could be: Standalone or Cluster

database solution based on the underlying database, which can scale computing and storage horizontally. D is tr ib ut ed T ra ns ac ti on Transactional capability is key to ensuring database integrity and shardingsphere.infra.config.mode.ModeConfiguration Attributes: • N a m e * Da taType Description D ef au lt Va lu e t y p e String Type of mode configu‐ rationValues could be: Standalone or Cluster api.CacheOption Attributes: 9.1. ShardingSphere-JDBC 114 Apache ShardingSphere document na me • D a t a T y p e * Des cription Default Value ini tia lCa pac ity i n t Initial capacity of local cache

discovery type name type: # Database discovery type, such as: MySQL.MGR props (?): group-name: 92504d5b-6dec-11e8-91ea-246e9612aaf1 # Required parameters for database discovery types, such as MGR's group-name shardingsphere.infra.config.mode.ModeConfiguration Attributes: • N a m e * Da taType Description D ef au lt Va lu e t y p e String Type of mode configu‐ rationValues could be: Standalone or Cluster Collection Binding table rules E mpty broadcastTables (*) Collection Broadcast table rules E mpty d efaultDatabaseS hardingStrategy (?) Sharding StrategyCon‐ figuration Default database sharding

document, v5.2.1 type: # Database discovery type, such as: MySQL.MGR props (?): group-name: 92504d5b-6dec-11e8-91ea-246e9612aaf1 # Required parameters for database discovery types, such as MGR's group-name shardingsphere.infra.config.mode.ModeConfiguration Attributes: • N a m e * Da taType Description D ef au lt Va lu e t y p e String Type of mode configu‐ rationValues could be: Standalone or Cluster api.ReadwriteSplittingRuleConfiguration Configurable Properties: • Name* DataType Description d ataSo urces (+) Colle ction Data sources of write

指标描述 build_info G AU GE 构建信息 parsed_sql_total C OU NT ER 按类型（INSERT、UPDATE、DELETE、SELECT、DDL、DCL、D AL、TCL、RQL、RDL、RAL、RUL）分类的解析总数 routed_sql_total C OU NT ER 按类型（INS ERT、UPDATE、DELETE、SELECT）分类的路由总 h t t p s : / / g i t h u b . c o m / o r a c l e / g r a a l v m‐ r e a c h a b i l i t y‐ m e t a d a t a 打开新的 is‐ sue，并提交包含依赖的第三方库缺失的 GraalVM Reachability Metadata 的 PR。ShardingSphere 在 shardingsp refused？ 2. 配置 conf/global.yaml 和 conf/database-*.yaml 可以从 Docker 容器中获取配置文件模板，拷贝到宿主机任意目录中： docker run -d --name tmp --entrypoint=bash apache/shardingsphere-proxy docker cp tmp:/opt/shardingsphere-proxy/conf

h t t p s : / / g i t h u b . c o m / o r a c l e / g r a a l v m‐ r e a c h a b i l i t y‐ m e t a d a t a 打开新的 is‐ sue，并提交包含依赖的第三方库缺失的 GraalVM Reachability Metadata 的 PR。ShardingSphere 在 shardingsp refused？ 2. 配置 conf/server.yaml 和 conf/config-*.yaml 可以从 Docker 容器中获取配置文件模板，拷贝到宿主机任意目录中： docker run -d --name tmp --entrypoint=bash apache/shardingsphere-proxy docker cp tmp:/opt/shardingsphere-proxy/conf ext-lib 目录挂载到容器中，启动容器： 9.2. ShardingSphere-Proxy 132 Apache ShardingSphere document docker run -d \ -v /host/path/to/conf:/opt/shardingsphere-proxy/conf \ -v /host/path/to/ext-lib:/opt/shardingsphere-proxy/ext-lib

refused？ 2. 配置 conf/server.yaml 和 conf/config-*.yaml 可以从 Docker 容器中获取配置文件模板，拷贝到宿主机任意目录中： docker run -d --name tmp --entrypoint=bash apache/shardingsphere-proxy docker cp tmp:/opt/shardingsphere-proxy/conf 使用二进制发布 包中的对应步骤。 4. 启动 ShardingSphere‐Proxy 容器 将宿主机中的 conf 与 ext-lib 目录挂载到容器中，启动容器： docker run -d \ -v /host/path/to/conf:/opt/shardingsphere-proxy/conf \ -v /host/path/to/ext-lib:/opt/shardingsphere-proxy/ext-lib 配置示例 完整配置示例请参考 ShardingSphere 仓库内的 server.yaml：https://github.com/apache/sharding sphere/blob/aac0d3026e00575114701be603ec189a02a45747/shardingsphere‐proxy/shardingsphere‐p roxy‐bootstrap/src/main/r

Apache ShardingSphere document, v5.2.0 type: # 数据库发现类型，如：MySQL.MGR props (?): group-name: 92504d5b-6dec-11e8-91ea-246e9612aaf1 # 数据库发现类型必要参数，如 MGR 的 group-name 配置示例 databaseName: database_discovery_db apache.shardingsphere.readwritesplitting.api.ReadwriteSplittingRuleConfiguration 可配置属性： 名称 数据类型 说明 d ataSources (+) Collection 读写数据源配置 loa dBalancers String 读写分离数据源名称 • staticStrategy Sta ticReadwriteSp littingStrateg yConfig‐ uration 静态读写分离配置 • d ynamicStrategy Dyna micReadwriteSp littingStrateg yConfig‐ uration 动态读写分离配置 • lo adBalancerName

quicker startup with -A │ Database changed │Database changed MySQL [test1]> XA START '61c052438d3eb'; │MySQL [test2]> XA START '61c0524390927'; Query OK, 0 rows affected (0.030 sec) │Query OK, 0 XA END '61c052438d3eb'; │MySQL [test2]> XA END '61c0524390927'; Query OK, 0 rows affected (0.006 sec) │Query OK, 0 rows affected (0.008 sec) │ MySQL [test1]> XA PREPARE '61c052438d3eb'; │MySQL [test2]> affected (0.018 sec) │Query OK, 0 rows affected (0.011 sec) │ MySQL [test1]> XA COMMIT '61c052438d3eb'; 4.4. 分布式事务 46 Apache ShardingSphere document, v5.1.0 │MySQL [test2]> XA COMMIT '61c0524390927';

quicker startup with -A │ Database changed │Database changed MySQL [test1]> XA START '61c052438d3eb'; │MySQL [test2]> XA START '61c0524390927'; Query OK, 0 rows affected (0.030 sec) │Query OK, 0 XA END '61c052438d3eb'; │MySQL [test2]> XA END '61c0524390927'; Query OK, 0 rows affected (0.006 sec) │Query OK, 0 rows affected (0.008 sec) │ MySQL [test1]> XA PREPARE '61c052438d3eb'; │MySQL [test2]> sec) 4.4. 分布式事务 46 Apache ShardingSphere document, v5.1.1 │ MySQL [test1]> XA COMMIT '61c052438d3eb'; │MySQL [test2]> XA COMMIT '61c0524390927'; Query OK, 0 rows affected (0.011 sec) │Query OK,