configuration。 The Docker environment configuration provides a remote debugging port for ShardingSphere‐ Proxy. You can find the second exposed port for remote debugging in ˋˋshardingsphere‐proxyˋˋ of the ˋˋdocker‐comemage -Dit.scenarios=${scenario_name_1,scenario_name_2,scenario_name_ n} -Dit.cluster.databases=MySQL Remote debug Proxy code in Docker container First of all, you need to modify the configuration file it‐env docker -DskipTests - Dspotless.apply.skip=true Remote debug Proxy started by docker image E2E Test Proxy image opens the 3308 port by default for remote debugging of the instance in the con‐ tainer.

configuration。 The Docker environment configuration provides a remote debugging port for ShardingSphere‐ Proxy. You can find the second exposed port for remote debugging in ˋˋshardingsphere‐proxyˋˋ of the ˋˋdocker‐comemage -Dit.scenarios=${scenario_name_1,scenario_name_2,scenario_name_ n} -Dit.cluster.databases=MySQL Remote debug Proxy code in Docker container First of all, you need to modify the configuration file it‐env docker -DskipTests - Dspotless.apply.skip=true Remote debug Proxy started by docker image E2E Test Proxy image opens the 3308 port by default for remote debugging of the instance in the con‐ tainer.

ngsphere‐ agent JAEG ER_SAMPLER_TYPE Jaeger sample rate type const, probabilistic, ratelimiting, remote const JAEGE R_SAMPLER_PARAM Jaeger sample rate pa‐ rameter const:0, 1, pr obabilistic:0.0 ratelimiting: > 0, Customize the number of acquisitions per second, re‐ mote：need to customize the remote service addres,JA EGER_SAMPLER_MA NAGER_HOST_PORT 1 (const type) SAM‐ PLER_TYPE Zipkin sample configuration。 The Docker environment configuration provides a remote debugging port for ShardingSphere‐ Proxy. You can find the second exposed port for remote debugging in ˋˋshardingsphere‐proxyˋˋ of the ˋˋdocker‐comemage

capabilities available. Usage Local build > cd shardingsphere/shardingsphere-agent > mvn clean install Remote download（No release） > weget http://xxxxx/shardingsphere-agent.tar.gz > tar -zxvcf shardingsphere-agent Jenkins slave: (runs on the {host-sysbench} machine) 2. sysbench_sharding: a. Sharding scenarios for remote deployment of various versions of Proxy b. Execute Sysbench command to pressure test Proxy c. Execute Appendix 2 for drawing scripts) 3. sysbench_master_slave: a. Read and write separation scenarios for remote deployment of various versions of Proxy b. Execute Sysbench command to pressure test Proxy c.

ngsphere‐ agent JAEG ER_SAMPLER_TYPE Jaeger sample rate type const、proba bilistic、ratel imiting、remote const JAEGE R_SAMPLER_PARAM Jaeger sam‐ ple rate parameter const:0、1, pr obabilistic:0.0 ‐ ratelimiting: > 0, Customize the number of acquisitions per secon d，re‐ mote：need to customize the remote service addres,JA EGER_SAMPLER_MA NAGER_HOST_PORT 1（const type） SAM‐ PLER_TYPE Zipkin sample Jenkins slave: (runs on the {host-sysbench} machine) 2. sysbench_sharding: a. Sharding scenarios for remote deployment of various versions of Proxy b. Execute Sysbench command to pressure test Proxy c. Execute

ngsphere‐ agent JAEG ER_SAMPLER_TYPE Jaeger sample rate type const, probabilistic, ratelimiting, remote const JAEGE R_SAMPLER_PARAM Jaeger sample rate pa‐ rameter const:0, 1, pr obabilistic:0.0 ratelimiting: > 0, Customize the number of acquisitions per second, re‐ mote：need to customize the remote service addres,JA EGER_SAMPLER_MA NAGER_HOST_PORT 1 (const type) SAM‐ PLER_TYPE Zipkin sample Jenkins slave: (runs on the {host-sysbench} machine) 2. sysbench_sharding: a. Sharding scenarios for remote deployment of various versions of Proxy b. Execute Sysbench command to pressure test Proxy c. Execute

configuration。 The Docker environment configuration provides a remote debugging port for ShardingSphere‐ Proxy. You can find the second exposed port for remote debugging in ˋˋshardingsphere‐proxyˋˋ of the ˋˋdocker‐comemage not null, s_i_id integer not null, s_quantity integer, s_ytd integer, s_order_cnt integer, s_remote_cnt integer, s_data varchar(50), s_dist_01 char(24), s_dist_02 char(24), 6.6. Performance Test UPDATE bmsql_stock SET s_quantity = ?, s_ytd = s_ytd + ?, s_order_cnt = s_order_cnt + 1, s_remote_cnt = s_remote_cnt + ? WHERE s_w_id = ? AND s_i_id = ? stmtNewOrderInsertOrderLine INSERT INTO bmsql_order_line

(Dependency Injection) Beans can be freely used in Job, such as data source connection pool and Dubbo remote service, etc., which is more convenient for business development. 5.2 Elastic Schedule Elastic control the distribution of single‐point jobs to other job machines, and also can’t start the job of remote server. ElasticJob doesn’t support ssh secret management and other functions. In summary, ElasticJob

shardi ngsphere‐ agent JAEG ER_SAMPLER_TYPE Jaeger 采 样 率 类型 const、proba bilistic、ratel imiting、remote const JAEGE R_SAMPLER_PARAM Jaeger 采 样 率 参数 c onst：0、1，pro babilistic：0.0 ‐ 1.0，ratelimiting：> 工具可以通过如下方式连接并 debug 容器中的 Proxy 代码： IDEA ‐> Run ‐> Edit Configurations ‐> Add New Configuration ‐> Remote JVM Debug 编辑对应的信息：‐ Name：一个描述性的名字，例如 docker‐debug。‐ Host：可以访问 docker 的 IP，例 如 127.0.0.1。‐ Port：调试端口 not null, s_i_id integer not null, s_quantity integer, s_ytd integer, s_order_cnt integer, s_remote_cnt integer, s_data varchar(50), s_dist_01 char(24), s_dist_02 char(24), s_dist_03 char(24),

工具可以通过如下方式连接并 debug 容器中的 Proxy 代码： IDEA ‐> Run ‐> Edit Configurations ‐> Add New Configuration ‐> Remote JVM Debug 编辑对应的信息：‐ Name：一个描述性的名字，例如 e2e‐debug。‐ Host：可以访问 docker 的 IP，例如 127.0.0.1。‐ Port：调试端口（需要在下一步中设置）。‐ getLast()).getMappedPort(3308) 获取到映 射的对外随机端口为 51837。（或者通过命令 docker ps 查看）‐ 参考 远程调试通过镜像启 动的 Proxy 中的方式，将 Remote JVM Debug 配置中的 Port 设置为上一步中获取到的端口， 例如 51837。 编辑好上面的信息后，在 IDEA 中 Run ‐> Run ‐> e2e‐debug ‐> debug not null, s_i_id integer not null, s_quantity integer, s_ytd integer, s_order_cnt integer, s_remote_cnt integer, s_data varchar(50), s_dist_01 char(24), s_dist_02 char(24), s_dist_03 char(24),