shortest time, this chapter provides users with a simplest quick start with Apache ShardingSphere. Example Codes: https://github.com/apache/shardingsphere/tree/master/examples 7.1 ShardingSphere-JDBC 7 FOO_XXX ... - !BAR_XXX ... props: key_1: value_1 key_2: value_2 4. Take spring boot as an example, edit application.properties. # Configuring DataSource Drivers spring.datasource.driver-class-name=org %SHARDINGSPHERE_PROXY_HOME%/conf/database-xxx.yaml. %SHARDINGSPHERE_PROXY_HOME% is the proxy extract path. for example: /opt/ shardingsphere-proxy-bin/ Please refer to Configuration Manual for more details. 3. Import

shortest time, this chapter provides users with a simplest quick start with Apache ShardingSphere. Example Codes: https://github.com/apache/shardingsphere/tree/master/examples 7.1 ShardingSphere-JDBC 7 FOO_XXX ... - !BAR_XXX ... props: key_1: value_1 key_2: value_2 4. Take spring boot as an example, edit application.properties. # Configuring DataSource Drivers spring.datasource.driver-class-name=org %SHARDINGSPHERE_PROXY_HOME%/conf/config-xxx.yaml. %SHARDINGSPHERE_PROXY_HOME% is the proxy extract path. for example: /opt/ shardingsphere-proxy-bin/ Please refer to Configuration Manual for more details. 3. Import

Shadow Algorithm . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 304 7.6.6 Use Example . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 304 Scenario . . . . environment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 305 Shadow algorithm example . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 306 7.7 Test . . . . . . . . . . . shortest time, this chapter provides users with a simplest quick start with Apache ShardingSphere. Example Codes: https://github.com/apache/shardingsphere/tree/master/examples 2.1 ShardingSphere-JDBC 2

Shadow Algorithm . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 283 7.5.6 Use Example . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 283 Scenario . . . . environment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 284 Shadow algorithm example . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 284 7.6 Test . . . . . . . . . . . 4. Use ShardingSphere-Proxy Use MySQL or PostgreSQL client to connect ShardingSphere‐Proxy. For example with MySQL: mysql -u${proxy_username} -p${proxy_password} -h${proxy_host} -P${proxy_port} 2.2.

Shadow Algorithm . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 293 7.6.6 Use Example . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 293 ix Scenario . . environment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 294 Shadow algorithm example . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 294 7.7 Test . . . . . . . . . . . 4 Use ShardingSphere-Proxy Use MySQL or PostgreSQL client to connect ShardingSphere‐Proxy. For example with MySQL: mysql -u${proxy_username} -p${proxy_password} -h${proxy_host} -P${proxy_port} 2.3

shortest time, this chapter provides users with a simplest quick start with Apache ShardingSphere. Example Codes: https://github.com/apache/shardingsphere/tree/master/examples 2.1 ShardingSphere-JDBC 2 %SHARDINGSPHERE_PROXY_HOME%/conf/config-xxx.yaml. %SHARDINGSPHERE_PROXY_HOME% is the proxy extract path. for example: /opt/ shardingsphere-proxy-bin/ Please refer to Configuration Manual for more details. 3. Import certain rules through certain fields, with each sharding con‐ taining only part of the data. For example, according to primary key sharding, even primary keys are put into the 0 database (or table) and

shortest time, this chapter provides users with a simplest quick start with Apache ShardingSphere. Example Codes: https://github.com/apache/shardingsphere/tree/master/examples 2.1 ShardingSphere-JDBC 2 %SHARDINGSPHERE_PROXY_HOME%/conf/config-xxx.yaml. %SHARDINGSPHERE_PROXY_HOME% is the proxy extract path. for example: /opt/ shardingsphere-proxy-bin/ Please refer to Configuration Manual for more details. 3. Import certain rules through certain fields, with each sharding con‐ taining only part of the data. For example, according to primary key sharding, even primary keys are put into the 0 database (or table) and

4. Use ShardingSphere-Proxy Use MySQL or PostgreSQL client to connect ShardingSphere‐Proxy. For example with MySQL: mysql -u${proxy_username} -p${proxy_password} -h${proxy_host} -P${proxy_port} 2.2. certain rules through certain fields, with each sharding con‐ taining only part of the data. For example, according to primary key sharding, even primary keys are put into the 0 database (or table) and Binding Table It refers to the primary table and the joiner table with the same sharding rules, for example, t_order and t_order_item are both sharded by order_id, so they are binding tables with each other

configuration file of MyBatis thiselementcontainsfourattributesnamelyresources, url, class, andname. For example, the name of the mapper xml file is Student.xml and it resides in the package named as mybatis,, mapper interface. The attribute name points to the package name of the mapper interface. In the example provided in this chapter, we have specified the class path of the mapper XML using the resource attribute available today. Let us create a SqlMapConfig.xml configuration file to connect to mysql database. The example given below are the dataSource properties driver − name, url, user − name, andpassword for MySQL

multiple individual job items, one or some of which will be executed by the distributed servers. For example, if a job is divided into 4 slices, and there are two servers to execute the job, then each server the sharding items, converting the sharding items’numbers to more readable business codes. For example, to horizontally split the databases according to the regions, database A stores data from Beijing reasonably for the job to leverage the resources, and assign the sharding items dynamically. For example, we have 10 sharding items and there are 3 servers, the number of sharding items are server A =