0-beta Jenkins * 1: ${host-jenkins} Sysbench * 1: ${host-sysbench} ShardingSphere-Proxy * 1: ${host-proxy} MySQL Server * 2: ${host-mysql-1}, ${host-mysql-2} The hardware standards of Jenkins and Sysbench Apache ShardingSphere document, v5.0.0-beta Jenkins Configuration Create 6 Jenkins tasks, and each task calls the next task in turn: (runs on the ${host-jenkins} ma‐ chine). 1. sysbench_install: Pull the compression package The following tasks are run on a separate Sysbench pressure generating machine via Jenkins slave: (runs on the {host-sysbench} machine) 2. sysbench_sharding: a. Sharding scenarios for remote

0-beta 至少需要 5 台机器： Jenkins * 1: ${host-jenkins} Sysbench * 1: ${host-sysbench} ShardingSphere-Proxy * 1: ${host-proxy} MySQL Server * 2: ${host-mysql-1}, ${host-mysql-2} 可以适当降低 Jenkins 和 Sysbench 机器的硬件标准 ShardingSphere document, v5.0.0-beta Jenkins 配置 创建 6 个 Jenkins 任务，每个任务依次调用下一个任务：（运行在 ${host‐jenkins} 机器） 1. sysbench_install: 拉取最新代码，打包 Proxy 压缩包 以下任务通过 Jenkins slave 运行在单独的 Sysbench 发压机器：（运行在 ${host‐sysbench} b. 使用 Jenkins 的 Publish HTML reports 插件将所有图片整合到一个 HTML 页面中 3.10. 测试引擎 122 Apache ShardingSphere document, v5.0.0-beta 测试过程 以 sysbench_sharding 为例（其他场景类似） 进入 sysbench 压测结果目录 cd /home/jenkins/sysbench_res/sharding

required: Jenkins * 1: ${host-jenkins} Sysbench * 1: ${host-sysbench} ShardingSphere-Proxy * 1: ${host-proxy} MySQL Server * 2: ${host-mysql-1}, ${host-mysql-2} The hardware standards of Jenkins and Sysbench Sysbench machines can appropriately lower. Software Environment Jenkins: The latest version Sysbench: 1.0.20 ShardingSphere-Proxy: package from master branch MySQL Server: 5.7.28 Test Program According 500000 Set parameter: max_connections = 2000 Jenkins Configuration Create 6 Jenkins tasks, and each task calls the next task in turn: (runs on the ${host-jenkins} ma‐ chine). 1. sysbench_install: Pull the

required: Jenkins * 1: ${host-jenkins} Sysbench * 1: ${host-sysbench} ShardingSphere-Proxy * 1: ${host-proxy} MySQL Server * 2: ${host-mysql-1}, ${host-mysql-2} The hardware standards of Jenkins and Sysbench Sysbench machines can appropriately lower. Software Environment Jenkins: The latest version Sysbench: 1.0.20 ShardingSphere-Proxy: package from master branch MySQL Server: 5.7.28 Test Program According 500000 Set parameter: max_connections = 2000 Jenkins Configuration Create 6 Jenkins tasks, and each task calls the next task in turn: (runs on the ${host-jenkins} ma‐ chine). 1. sysbench_install: Pull the