Goal . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 8.1.4 Application Scenarios . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 Mass data high concurrency 8.2.5 Application Scenarios . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36 Application Scenarios for ShardingSphere XA Transactions . . . . . . . . . . . . 36 Application Scenarios Scenarios for ShardingSphere BASE Transaction . . . . . . . . . . . 36 Application Scenarios for ShardingSphere LOCAL Transaction . . . . . . . . . . 37 8.2.6 Related references . . . . . . . . . . . . .

SQL databases and objects in Java, .NET, and Ruby on Rails. The mappings are decoupled from the application logic by packaging the SQL statements in XML configuration files. It abstracts almost all of the Interfaces − MyBatis provides database-independent interfaces and APIs that help the rest of the application remain independent of any persistence-related resources. Open source− MyBatis is free and an open the form of stored procedures so that business logic can be kept out of the database, and the application is more portable and easier to deploy and test. Supports inline SQL − No pre-compiler is needed

Goal . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 8.1.4 Application Scenarios . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 Mass data high concurrency 8.2.5 Application Scenarios . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36 Application Scenarios for ShardingSphere XA Transactions . . . . . . . . . . . . 36 Application Scenarios Scenarios for ShardingSphere BASE Transaction . . . . . . . . . . . 36 Application Scenarios for ShardingSphere LOCAL Transaction . . . . . . . . . . 37 8.2.6 Related references . . . . . . . . . . . . .

Goal . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 3.1.4 Application Scenarios . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 Mass data high concurrency 3.2.5 Application Scenarios . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 Application Scenarios for ShardingSphere XA Transactions . . . . . . . . . . . . 32 Application Scenarios Scenarios for ShardingSphere BASE Transaction . . . . . . . . . . . 32 Application Scenarios for ShardingSphere LOCAL Transaction . . . . . . . . . . 32 3.2.6 Related references . . . . . . . . . . . . .

Goal . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 3.1.4 Application Scenarios . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 Mass data high concurrency 3.2.5 Application Scenarios . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 Application Scenarios for ShardingSphere XA Transactions . . . . . . . . . . . . 31 Application Scenarios Scenarios for ShardingSphere BASE Transaction . . . . . . . . . . . 31 Application Scenarios for ShardingSphere LOCAL Transaction . . . . . . . . . . 31 3.2.6 Related references . . . . . . . . . . . . .

distributed database access application with the database. Focusing on interaction, it effectively organizes the interaction between messy applications and the database. The application and database that use high‐performance light‐weight OLTP application developed with Java; ShardingSphere‐Proxy provides static entry and all languages support, applicable for OLAP application and the sharding databases management ShardingSphere‐Proxy and unified sharding strategy by the same registry center, ShardingSphere can build an application system applicable to all kinds of scenarios. Architects can adjust the system architecture to

high‐performance light‐weight OLTP application developed with Java. ShardingSphere‐Proxy provides static entry and all languages support, applicable for OLAP application and the sharding databases management ShardingSphere‐Proxy and a unified sharding strategy by the same registry center, ShardingSphere can build an application system that is applicable to all kinds of scenarios. Ar‐ chitects can adjust the system architecture High loss Decentralization Yes No Static Entry No Yes ShardingSphere‐JDBC is suitable for java application. 3.1.2 ShardingSphere-Proxy ShardingSphere‐Proxy is the second product of Apache ShardingSphere

high‐performance light‐weight OLTP application developed with Java. ShardingSphere‐Proxy provides static entry and all languages support, applicable for OLAP application and the sharding databases management ShardingSphere‐Proxy and a unified sharding strategy by the same registry center, ShardingSphere can build an application system that is applicable to all kinds of scenarios. Ar‐ chitects can adjust the system architecture High loss Decentralization Yes No Static Entry No Yes ShardingSphere‐JDBC is suitable for java application. 3.1.2 ShardingSphere-Proxy ShardingSphere‐Proxy is the second product of Apache ShardingSphere

high‐performance light‐weight OLTP application developed with Java. ShardingSphere‐Proxy provides static entry and all languages support, applicable for OLAP application and the sharding databases management ShardingSphere‐Proxy and a unified sharding strategy by the same registry center, ShardingSphere can build an application system that is applicable to all kinds of scenarios. Ar‐ chitects can adjust the system architecture Notice: Please change ${latest.release.version} to the actual version. 3. Edit application.yml. spring: shardingsphere: datasource: names: ds_0, ds_1 ds_0: type: com.zaxxer.hikari

FOO_XXX ... - !BAR_XXX ... props: key_1: value_1 key_2: value_2 4. 以 spring boot 为例，编辑 application.properties。 # 配置 DataSource Driver spring.datasource.driver-class-name=org.apache.shardingsphere ShardingSphere-JDBC 116 Apache ShardingSphere document 修改配置 在 classpath 中增加 seata.conf 文件。 client { application.id = example ## 应用唯一主键 transaction.service.group = my_test_tx_group ## 所属事务组 } 根据实际场景修改 Seata 5000 14301 ShardingSphere Seata‐AT transaction has been disabled. 2 5000 14302 Please config application id within seata.conf file. 9.4. 错误码 407 Apache ShardingSphere document 锁 SQL S tate V endor