Applicable to any kind of client that is compatible with MySQL/PostgreSQL protocol, such as MySQL Command Client, MySQL Workbench, etc. 3.2. Using ShardingSphere-Proxy 8 Apache ShardingSphere document through some graph database clients, the client or proxy may have an er‐ ror prompt. You can use command‐line clients (mysql, psql, gsql, etc.) to connect to the Proxy’s authentication function. 7.2. ShardingSphere-Proxy does not help to manage the configuration uniformly. But by writing the sharding algorithm through line expressions, the rule con‐ figuration can be effectively stored together, which is easier to browse

Applicable to any kind of client that is compatible with MySQL/PostgreSQL protocol, such as MySQL Command Client, MySQL Workbench, etc. 1.3. Deployment 6 Apache ShardingSphere document, v5.2.1 ShardingSphere-JDBC through some graph database clients, the client or proxy may have an er‐ ror prompt. You can use command‐line clients (mysql, psql, gsql, etc.) to connect to the Proxy’s authentication function. 2.2. ShardingSphere-Proxy does not help to manage the configuration uniformly. But by writing the sharding algorithm through line expressions, the rule con‐ figuration can be effectively stored together, which is easier to browse

Applicable to any kind of client that is compatible with MySQL/PostgreSQL protocol, such as MySQL Command Client, MySQL Workbench, etc. 3.2. Using ShardingSphere-Proxy 8 Apache ShardingSphere document through some graph database clients, the client or proxy may have an er‐ ror prompt. You can use command‐line clients (mysql, psql, gsql, etc.) to connect to the Proxy’s authentication function. 7.2. ShardingSphere-Proxy does not help to manage the configuration uniformly. But by writing the sharding algorithm through line expressions, the rule con‐ figuration can be effectively stored together, which is easier to browse

Applicable to any kind of client that is compatible with MySQL/PostgreSQL protocol, such as MySQL Command Client, MySQL Workbench, etc. 1.3. Deployment 8 Apache ShardingSphere document, v5.2.0 ShardingSphere-JDBC through some graph database clients, the client or proxy may have an er‐ ror prompt. You can use command‐line clients (mysql, psql, gsql, etc.) to connect to the Proxy’s authentication function. 2.2. ShardingSphere-Proxy does not help to manage the configuration uniformly. But by writing the sharding algorithm through line expressions, the rule con‐ figuration can be effectively stored together, which is easier to browse

Friendlier to DBA, the MySQL version provided now can use any kind of terminal (such as MySQL Command Client, MySQL Workbench, etc.) that is compatible of MySQL protocol to operate data. • Totally traversed according to logical database name, and the command is executed in the physical database. For example: SET autocommit=0; If this command is executed in t_order, t_order will have 2 physical only be executed once. For example: CREATE USER customer@127.0.0.1 identified BY '123'; This command will be executed in all the physical database instances to ensure customer users have access to

shell, python, perl. The script to be executed can be configured through the property script.command.line, without coding. The script path can contain parame‐ ters, after the parameters are passed, the observe. Because of developer can not debug in production environment, ElasticJob provide dump command to export job runtime information for debugging. Please refer to Operation Manual for more details scriptJob: elasticJobType: SCRIPT cron: 0/10 * * * * ? shardingTotalCount: 3 props: script.command.line: "echo SCRIPT Job: " Job Start Schedule Job Just start Spring Boot Starter directly. The schedule

databases, such as openGauss) versions are provided. It can use any kind of terminal (such as MySQL Command Client, MySQL Workbench, etc.) that is com‐ patible of MySQL or PostgreSQL protocol to operate data databases, such as openGauss) versions are provided. It can use any kind of terminal (such as MySQL Command Client, MySQL Workbench, etc.) that is compatible with MySQL or PostgreSQL protocol to operate data stored in the database before. The relevant department suddenly needs to encrypt the data from the on‐line business. This scenario generally needs to deal with three issues as followings: • How to encrypt

databases, such as openGauss) versions are provided. It can use any kind of terminal (such as MySQL Command Client, MySQL Workbench, etc.) that is com‐ patible of MySQL or PostgreSQL protocol to operate data databases, such as openGauss) versions are provided. It can use any kind of terminal (such as MySQL Command Client, MySQL Workbench, etc.) that is compatible with MySQL or PostgreSQL protocol to operate data stored in the database before. The relevant department suddenly needs to encrypt the data from the on‐line business. This scenario generally needs to deal with three issues as followings: • How to encrypt

Apache ShardingSphere ElasticJob document 脚本作业 支持 shell，python，perl 等所有类型脚本。可通过属性配置 script.command.line 配置待执行脚本， 无需编码。执行脚本路径可包含参数，参数传递完毕后，作业框架会自动追加最后一个参数为作业运行 时信息。 例如如下脚本： #!/bin/bash echo sharding scriptJob: elasticJobType: SCRIPT cron: 0/10 * * * * ? shardingTotalCount: 3 props: script.command.line: "echo SCRIPT Job: " 作业启动 定时调度 定时调度作业在 Spring Boot 应用程序启动完成后会自动启动，无需其他额外操作。 一次性调度 一 次 性 调 "${myScriptJob.shardingTotalCount}" cron="$ {myScriptJob.cron}"> ${myScriptJob.scriptCommandLine} 6.1. 使用手册 39

databases, such as openGauss) versions are provided. It can use any kind of terminal (such as MySQL Command Client, MySQL Workbench, etc.) that is com‐ patible of MySQL or PostgreSQL protocol to operate data databases, such as openGauss) versions are provided. It can use any kind of terminal (such as MySQL Command Client, MySQL Workbench, etc.) that is compatible of MySQL or PostgreSQL protocol to op‐ erate data Those identifiers are temporary nodes, which are registered when instances are on‐line and cleared when instances are off‐line. The registry center monitors the change of those nodes to govern the database