1 SQL Error Code . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 290 4.4.2 Server Error Code . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 292 5 Dev Manual ShardingSphere-Proxy ShardingSphere‐Proxy is a transparent database proxy, providing a database server that encapsulates database binary protocol to support heterogeneous languages. 1.1.2 Product Features ShardingSphere-Proxy ShardingSphere‐Proxy is a transparent database proxy, providing a database server that encapsulates database binary protocol to support heterogeneous languages. Currently, MySQL

Other Exception . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 318 4.4.2 Server Error Code . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 318 5 Dev Manual ShardingSphere-Proxy ShardingSphere‐Proxy is a transparent database proxy, providing a database server that encapsulates database binary protocol to support heterogeneous languages. 1 Apache ShardingSphere ShardingSphere-Proxy ShardingSphere‐Proxy is a transparent database proxy, providing a database server that encapsulates database binary protocol to support heterogeneous languages. Currently, MySQL

Import Dependencies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 2.2.4 Start Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 2.2.5 Use ShardingSphere‐Proxy ShardingSphere-Proxy ShardingSphere‐Proxy defines itself as a transparent database proxy, providing a database server that encapsulates database binary protocol to support heterogeneous languages. Currently, MySQL Configuration Edit %SHARDINGSPHERE_PROXY_HOME%/conf/config-xxx.yaml. Edit %SHARDINGSPHERE_PROXY_HOME%/conf/server.yaml. %SHARDINGSPHERE_PROXY_HOME% is the shardingsphere proxy extract path. for ex‐ ample: /op

Job statistics API . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52 Job server status display API . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53 Job sharding status Execution Monitor . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74 Monitoring job server alive . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74 6.3.4 Console . . . . . . HTTP, file, big data – Focus business SDK, can work with Spring IOC • Admin Console – Job administration – Job event trace query – Registry center management 3 3 Environment Required 3.1 Java

ShardingSphere‐Proxy 可以通过以下方式：‐ 二进制发布包 ‐ Docker ‐ Helm 2. 规则配置 编辑 %SHARDINGSPHERE_PROXY_HOME%/conf/server.yaml。 编辑 %SHARDINGSPHERE_PROXY_HOME%/conf/config-xxx.yaml。 %SHARDINGSPHERE_PROXY_HOME% 为 Proxy 比它们之间的区别，以帮助开发者进行技术选型。 3.2. 分布式事务 27 Apache ShardingSphere document, v5.2.0 LOCAL XA BASE 业务改造 无 无 需要 seata server 一致性 不支持 支持 最终一致 隔离性 不支持 支持 业务方保证 并发性能 无影响 严重衰退 略微衰退 适合场景 业务方处理不一致 短事务 & 低并发 长事务 & 高并发 3.2.5 (推荐) mode: type: Cluster repository: type: # 持久化仓库类型 props: # 持久化仓库所需属性 namespace: # 注册中心命名空间 server-lists: # 注册中心连接地址 foo_key: foo_value bar_key: bar_value overwrite: # 是否使用本地配置覆盖持久化配置 注意事项 1

2 规则配置 编辑 %SHARDINGSPHERE_PROXY_HOME%/conf/config-xxx.yaml。 编辑 %SHARDINGSPHERE_PROXY_HOME%/conf/server.yaml。 %SHARDINGSPHERE_PROXY_HOME% 为 Proxy 解压后的路径，例：/opt/shardingsphere‐ proxy‐bin/ 详情请参见 配置手册。 Language）负责资源和规则的创建、修改和删除； • RQL（Resource & Rule Query Language）负责资源和规则的查询和展现； • RAL（Resource & Rule Administration Language）负责 Hint、事务类型切换、分片执行计划查询 等管理功能。 3.3. DistSQL 14 Apache ShardingSphere document, v5 alt_conv1 FOR ‘LATIN1’TO ‘UTF8’FROM iso8859_1_to_utf8; CREATE FOREIGN DATA WRAPPER alt_fdw1 CREATE SERVER alt_fserv1 FOREIGN DATA WRAPPER alt_fdw1 CREATE LANGUAGE alt_lang1 HANDLER plpgsql_call_handler

Import Dependencies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 2.2.3 3. Start Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 2.2.4 4. Use ShardingSphere‐Proxy Import Dependencies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 2.3.3 3. Start Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 2.3.4 4. Create Migration ShardingSphere-Proxy ShardingSphere‐Proxy defines itself as a transparent database proxy, providing a database server that encapsulates database binary protocol to support heterogeneous languages. Currently, MySQL

Import Dependencies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 2.2.3 Start Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 2.2.4 Use ShardingSphere‐Proxy Import Dependencies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 2.3.3 Start Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 2.3.4 Create Migration ShardingSphere-Proxy ShardingSphere‐Proxy defines itself as a transparent database proxy, providing a database server that encapsulates database binary protocol to support heterogeneous languages. Currently, MySQL

Other Exception . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 439 9.4.2 Server Error Code . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 439 10 Dev Manual ShardingSphere-Proxy ShardingSphere‐Proxy is a transparent database proxy, providing a database server that encapsulates database binary protocol to support heterogeneous languages. 1 Apache ShardingSphere ShardingSphere-Proxy ShardingSphere‐Proxy is a transparent database proxy, providing a database server that encapsulates database binary protocol to support heterogeneous languages. Currently, MySQL

编辑%SHARDINGSPHERE_PROXY_HOME%/conf/config-xxx.yaml。详情请参见配置手册。 编辑%SHARDINGSPHERE_PROXY_HOME%/conf/server.yaml。详情请参见配置手册。 %SHARDINGSPHERE_PROXY_HOME% 为 Proxy 解 压 后 的 路 径， 例： /Users/ss/shardingsphere‐proxy‐bin/ -P${proxy_port} 2.3 ShardingSphere-Scaling (Experimental) 2.3.1 1. 规则配置 编辑%SHARDINGSPHERE_PROXY_HOME%/conf/server.yaml。详情请参见运行部署。 %SHARDINGSPHERE_PROXY_HOME% 为 Proxy 解 压 后 的 路 径， 例： /Users/ss/shardingsphere‐proxy‐bin/ Language）负责资源和规则的创建、修改和删除； • RQL（Resource & Rule Query Language）负责资源和规则的查询和展现； • RAL（Resource & Rule Administration Language）负责 Hint、事务类型切换、分片执行计划查询 等管理功能。 3.3.3 目标 打破中间件和数据库之间的界限，让开发者像使用数据库一样使用 Apache ShardingSphere，是