启动服务 • 使用默认配置项 sh %SHARDINGSPHERE_PROXY_HOME%/bin/start.sh 默认启动端口为 3307，默认配置文件目录为：%SHARDINGSPHERE_PROXY_HOME%/conf/。 • 自定义端口和配置文件目录 sh %SHARDINGSPHERE_PROXY_HOME%/bin/start.sh ${proxy_port} ${proxy_conf_directory} 说明 默认值 logicTable String 分片逻辑表名称 • act ualDataSources (?) String 数据源名称，多个数据 源以逗号分隔 使用全部配置的数据源 sh ardingStrategy (?) S hardingStrateg yCon‐ figuration 分片策略 使用默认分片策略 keyGe nerateStrategy (?) KeyGenerato Linux/macOS 操作系统请运行 bin/start.sh，Windows 操作系统请运行 bin/start.bat 启动 ShardingSphere‐Proxy。默认监听端口 3307，默认配置目录为 Proxy 内的 conf 目录。启动脚本可以 指定监听端口、配置文件所在目录，命令如下： bin/start.sh [port] [/path/to/conf] 9. 使用客户端连接

start sh %SHARDINGSPHERE_PROXY_HOME%/bin/start.sh The default port is 3307, while the default profile directory is %SHARDINGSPHERE_PROXY_HOME%/ conf/. • Customize port and profile directory sh %SHA %SHARDINGSPHERE_PROXY_HOME%/bin/start.sh ${proxy_port} ${proxy_conf_directory} 5. Use ShardingSphere‐Proxy. Use MySQL or PostgreSQL or openGauss client to connect ShardingSphere‐Proxy. Use the MySQL client ataSource‐ Configuration> shadow data source mapping name and configuration tables MapSh adowTableCon‐ figuration> shadow table name and configuration shad owAlgorithms Map

0 码力 | 483 页 | 4.27 MB | 1 年前

3

start sh %SHARDINGSPHERE_PROXY_HOME%/bin/start.sh The default port is 3307, while the default profile directory is %SHARDINGSPHERE_PROXY_HOME%/ conf/. • Customize port and profile directory sh %SHA %SHARDINGSPHERE_PROXY_HOME%/bin/start.sh ${proxy_port} ${proxy_conf_directory} • Force start sh %SHARDINGSPHERE_PROXY_HOME%/bin/start.sh -f Use the -f parameter to force start the Proxy. This parameter ataSource‐ Configuration> shadow data source mapping name and configuration tables MapSh adowTableCon‐ figuration> shadow table name and configuration shad owAlgorithms Map

0 码力 | 523 页 | 4.51 MB | 1 年前

3

configuration to start sh %SHARDINGSPHERE_PROXY_HOME%/bin/start.sh Default port is 3307, default profile directory is %SHARDINGSPHERE_PROXY_HOME%/conf/ . • Customize port and profile directory sh %SHARDINGSPH %SHARDINGSPHERE_PROXY_HOME%/bin/start.sh ${port} ${proxy_conf_directory} 2.2.4 4. Use ShardingSphere-Proxy Use MySQL or PostgreSQL client to connect ShardingSphere‐Proxy. For example with MySQL: mysql -u${proxy_username} it into %SHARDINGSPHERE_SCALING_HOME%/lib directory. 2.3.3 3. Start Server sh %SHARDINGSPHERE_SCALING_HOME%/bin/start.sh 2.3.4 4. Create Migration Job Use HTTP interface to manage the migration jobs

configuration to start sh %SHARDINGSPHERE_PROXY_HOME%/bin/start.sh Default port is 3307, default profile directory is %SHARDINGSPHERE_PROXY_HOME%/conf/ . • Customize port and profile directory sh %SHARDINGSPH %SHARDINGSPHERE_PROXY_HOME%/bin/start.sh ${port} ${proxy_conf_directory} 2.2.4 Use ShardingSphere-Proxy Use MySQL or PostgreSQL client to connect ShardingSphere‐Proxy. For example with MySQL: mysql -u${proxy_username} and put it into %SHARDINGSPHERE_PROXY_HOME%/lib directory. 2.3.3 Start Server sh %SHARDINGSPHERE_PROXY_HOME%/bin/start.sh 2.3.4 Create Migration Job Use DistSQL interface to manage the migration jobs

启动服务 • 使用默认配置项 sh %SHARDINGSPHERE_PROXY_HOME%/bin/start.sh 默认启动端口为 3307，默认配置文件目录为：%SHARDINGSPHERE_PROXY_HOME%/conf/。 • 自定义端口和配置文件目录 sh %SHARDINGSPHERE_PROXY_HOME%/bin/start.sh ${proxy_port} ${proxy_conf_directory} 5.1.47.jar， 并 将 其 放 入 %SHARDINGSPHERE_SCALING_HOME%/lib 目录。 2.3.3 3. 启动服务 sh %SHARDINGSPHERE_SCALING_HOME%/bin/start.sh 2.3.4 4. 任务管理 通过相应的 HTTP 接口管理迁移任务。 详情参见使用手册。 2.3. ShardingSphere-Scaling(Alpha) eport/ script/test_plan/test.jmx 压测结果处理 注意修改为上一步生成的 result.jtl 的位置。 sh shardingsphere-benchmark/report/script/gen_report.sh 历史压测数据展示 正在进行中，请等待。 3.10.5 性能测试 (sysbench) 环境 推荐硬件环境 CPU: 32 Cores

configuration to start sh %SHARDINGSPHERE_PROXY_HOME%/bin/start.sh Default port is 3307, default profile directory is %SHARDINGSPHERE_PROXY_HOME%/conf/ . • Customize port and profile directory sh %SHARDINGSPH %SHARDINGSPHERE_PROXY_HOME%/bin/start.sh ${port} ${proxy_conf_directory} 2.2.5 Use ShardingSphere-Proxy Use MySQL or PostgreSQL client to connect ShardingSphere‐Proxy. For example with MySQL: mysql -u${proxy_username} ShardingSphere-Proxy • Startup script Configure the absolute path of shardingsphere‐agent.jar to the start.sh startup script of shardingsphere proxy. nohup java ${JAVA_OPTS} ${JAVA_MEM_OPTS} \ -javaagent:/

languages. 1 Apache ShardingSphere document 1.2 Product Features F ea tu re Definition Da ta Sh ar di ng Data sharding is an effective way to deal with massive data storage and computing. Shard‐ ShardingSphere provides a com‐ plete, transparent, secure, and low‐cost data encryption solution. Sh ad ow Da ta ba se In full‐link online load testing scenarios, ShardingSphere supports data isolation start sh %SHARDINGSPHERE_PROXY_HOME%/bin/start.sh The default port is 3307, while the default profile directory is %SHARDINGSPHERE_PROXY_HOME%/ conf/. • Customize port and profile directory sh %SHA

languages. 1 Apache ShardingSphere document 1.2 Product Features F ea tu re Definition Da ta Sh ar di ng Data sharding is an effective way to deal with massive data storage and computing. Shard‐ ShardingSphere provides a com‐ plete, transparent, secure, and low‐cost data encryption solution. Sh ad ow Da ta ba se In full‐link online load testing scenarios, ShardingSphere supports data isolation start sh %SHARDINGSPHERE_PROXY_HOME%/bin/start.sh The default port is 3307, while the default profile directory is %SHARDINGSPHERE_PROXY_HOME%/ conf/. • Customize port and profile directory sh %SHA

configuration to start sh %SHARDINGSPHERE_PROXY_HOME%/bin/start.sh Default port is 3307, default profile directory is %SHARDINGSPHERE_PROXY_HOME%/conf/ . • Customize port and profile directory sh %SHARDINGSPH %SHARDINGSPHERE_PROXY_HOME%/bin/start.sh ${port} ${proxy_conf_directory} 2.2.4 4. Use ShardingSphere-Proxy Use MySQL or PostgreSQL client to connect ShardingSphere‐Proxy. For example with MySQL: mysql -u${proxy_username} put it into %SHARDINGSPHERE_PROXY_HOME%/lib directory. 2.3.3 3. Start Server sh %SHARDINGSPHERE_PROXY_HOME%/bin/start.sh 2.3.4 4. Create Migration Job Use DistSQL interface to manage the migration jobs