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 integrity and security and is also one of the databases’core technologies. ShardingSphere provides distributed transaction ca‐ pability on top of a single database, which can achieve data security across underlying

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 Dis‐ tributed Trans‐ action Transactional capability is key to ensuring database integrity and security and is also one of the databases’core technologies. With a hybrid engine based on XA and BASE trans‐

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 (sharding, readwrite‐splitting and shadow), transform (data encrypt and mask), authen‐ tication (security, audit and authority), governance (circuit breaker and access limitation and an‐ alyze, QoS and

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 ib ut ed T ra ns ac ti on Transactional capability is key to ensuring database integrity and security and is also one of the databases’core technologies. With a hybrid engine based on XA and BASE transac‐

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 (sharding, readwrite‐splitting and shadow), transform (data encrypt and mask), authen‐ tication (security, audit and authority), governance (circuit breaker and access limitation and an‐ alyze, QoS and

Other Exception . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 467 9.4.2 Server Error Code . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 467 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 ib ut ed T ra ns ac ti on Transactional capability is key to ensuring database integrity and security and is also one of the databases’core technologies. With a hybrid engine based on XA and BASE transac‐

Import Dependencies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 2.2.3 3. Start Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 2.2.4 4. Use ShardingSphere‐Proxy Import Dependencies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 2.3.3 3. Start Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 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. Friendlier to DBA

Import Dependencies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 2.2.4 Start Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 2.2.5 Use ShardingSphere‐Proxy (sharding, readwrite‐splitting and shadow), transform (data encrypt and mask), authen‐ tication (security, audit and authority), governance (circuit breaker and access limitation and an‐ alyze, QoS and 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

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 . . . . . . to split the job, enabling the job to be executed in distributed environment, where every single server only executes one of the slice that is assigned to it. ElasticJob is aware of the number of servers

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