5.5.2 Actuator interface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 6 User Manual 19 6.1 Usage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93 10.12 Unable to obtain a suitable IP in the case of multiple network interfaces . . . . . . . . . 93 iv 10.13 During the zk authorization upgrade process, there was a false Concepts & Features This chapter describes concepts and features about ElasticJob. Please refer to User manual for more details. 5.1 Schedule Model ElasticJob is a thread‐level scheduling framework for

52 Logging . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52 4 User Manual 53 4.1 ShardingSphere‐JDBC . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Test engine . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 355 x 6.5.2 User Guide . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 355 Test case configuration 2 Test environment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 379 6.8.3 User guide . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 379 Environment

56 Logging . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56 9 User Manual 57 9.1 ShardingSphere‐JDBC . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Test engine . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 463 11.5.2 User Guide . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 463 Test case configuration Test environment type . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 489 11.8.3 User guide . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 489 Environment

platform such as Java, Ruby, and C# for Microsoft .NET. Independent Interfaces − MyBatis provides database-independent interfaces and APIs that help the rest of the application remain independent of any name = "url" value = "database_url"/> tag It is used to configure the connection properties of the database, such as driver-name, url, user- name, and password of the database that we want to connect. It is of three types namely − UNPOOLED

53 Logging . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53 4 User Manual 54 4.1 ShardingSphere‐JDBC . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Test engine . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 328 6.5.2 User Guide . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 328 Test case configuration 2 Test environment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 352 6.8.3 User guide . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 352 Environment

Incremental Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60 4.6.6 User Norms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61 Supported . . . . . . 65 Column shadow algorithm DML statement support list . . . . . . . . . . . . . . 65 5 User Manual 67 5.1 ShardingSphere‐JDBC . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . documents • Features#Scaling : Core Concept, User Norms • User Manual#Scaling : Build, Manual • RAL#Scaling : DistSQL for Scaling • Dev Manual#Scaling : SPI interfaces and implementations 2.3. ShardingSphere-Scaling

11.6 Limitations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58 9 User Manual 59 9.1 ShardingSphere‐JDBC . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Test engine . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 492 11.5.2 User Guide . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 492 Test case configuration Test environment type . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 518 11.8.3 User guide . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 518 Environment

Incremental Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57 4.7.6 User Norms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57 Supported . . . 64 Used in ShardingSphere‐Proxy . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67 5 User Manual 68 5.1 ShardingSphere‐JDBC . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . starter. Developers can choose the suitable method according to different situa‐ tions. Please refer to User Manual for more details. 2.1.3 3. Create Data Source Use ShardingSphereDataSourceFactory and rule

Incremental Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59 4.7.6 User Norms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59 Supported . . . 67 Used in ShardingSphere‐Proxy . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70 5 User Manual 71 5.1 ShardingSphere‐JDBC . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . environment requires Java JRE 8 or later. 2.1.4 Procedure 1. Rules configuration. Please refer to User Manual for more details. 2. Import Maven dependency org.apache.shardingsphere

Phase Description . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81 3.5.8 User Norms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 82 Supported Items 123 Appendix 2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 146 4 User Manual 148 4.1 ShardingSphere‐JDBC . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Features This chapter describes concepts and features about Apache ShardingSphere. Please refer to User man‐ ual for more details. 3.1 Sharding 3.1.1 Background The traditional solution that stores