RaigorJiang opened a new issue #14661:
URL: https://github.com/apache/shardingsphere/issues/14661
Hi community,
In order to facilitate users to manage the scaling configuration, we will
add some new DistSQL syntax.
At the same time, since the scaling feature has been refactored to support
different levels of configurations (#13875), DistSQL will also support
different levels:
#### Example
1. Automatic scaling process, specifying minimal configuration
```sql
CREATE SHARDING SCALING scaling_name(
COMPLETION_DETECTOR(TYPE(NAME=IDLE,
PROPERTIES("incremental-task-idle-minute-threshold"=30))),
DATA_CONSISTENCY_CHECKER(TYPE(NAME=DATA_MATCH,
PROPERTIES("chunk-size"=1000)))
);
```
2. Automatic scaling process, specifying complete configuration
```sql
CREATE SHARDING SCALING scaling_name(
INPUT(
WORKER_THREAD=40,
BATCH_SIZE=1000,
RATE_LIMITER(TYPE(NAME=QPS, PROPERTIES("qps"=50)))
),
OUTPUT(
WORKER_THREAD=40,
BATCH_SIZE=1000,
RATE_LIMITER(TYPE(NAME=TPS, PROPERTIES("tps"=2000)))
),
STREAM_CHANNEL(TYPE(NAME=MEMORY, PROPERTIES("block-queue-size"=10000))),
COMPLETION_DETECTOR(TYPE(NAME=IDLE,
PROPERTIES("incremental-task-idle-minute-threshold"=30))),
DATA_CONSISTENCY_CHECKER(TYPE(NAME=DATA_MATCH,
PROPERTIES("chunk-size"=1000)))
);
```
3. Manual scaling process
```sql
CREATE SHARDING SCALING scaling_name(
INPUT(
WORKER_THREAD=40,
BATCH_SIZE=1000,
RATE_LIMITER(TYPE(NAME=QPS, PROPERTIES("qps"=50)))
),
OUTPUT(
WORKER_THREAD=40,
BATCH_SIZE=1000,
RATE_LIMITER(TYPE(NAME=TPS, PROPERTIES("tps"=2000)))
),
STREAM_CHANNEL(TYPE(NAME=MEMORY, PROPERTIES("block-queue-size"=10000)))
);
```
4. Empty configuration (done in #14551)
```sql
CREATE SHARDING SCALING scaling_name;
```
5. Drop scaling configuration (done in #14551)
```sql
DROP SHARDING SCALING scaling_name;
```
6. Enable scaling configuration
```sql
ENABLE SHARDING SCALING scaling_name;
```
7. Disable scaling configuration
```sql
DISABLE SHARDING SCALING scaling_name;
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
