You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/09/24 10:11:26 UTC
[GitHub] [shardingsphere] RaigorJiang opened a new pull request #12686: Add scaling distSQL:`CHECKOUT SCALING jobId`.
RaigorJiang opened a new pull request #12686:
URL: https://github.com/apache/shardingsphere/pull/12686
Changes proposed in this pull request:
1. Add scaling distSQL:`CHECKOUT SCALING jobId`.
2. Remove `JOB` keyword from the following SQL syntax
- SHOW SCALING JOB LIST -> SHOW SCALING LIST
- SHOW SCALING JOB STATUS jobId -> SHOW SCALING STATUS jobId
- START SCALING JOB jobId -> START SCALING jobId
- STOP SCALING JOB jobId -> STOP SCALING jobId
- DROP SCALING JOB jobId -> DROP SCALING jobId
- RESET SCALING JOB jobId -> RESET SCALING jobId
- CHECK SCALING JOB jobId -> CHECK SCALING jobId
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] sandynz commented on pull request #12686: Add scaling distSQL:`CHECKOUT SCALING jobId`.
Posted by GitBox <gi...@apache.org>.
sandynz commented on pull request #12686:
URL: https://github.com/apache/shardingsphere/pull/12686#issuecomment-926569533
Verification:
```
mysql> show scaling list;
+--------------------+-----------------------+----------------------+--------+---------------------+---------------------+
| id | tables | sharding_total_count | active | create_time | stop_time |
+--------------------+-----------------------+----------------------+--------+---------------------+---------------------+
| 648136988280487936 | t_order_item, t_order | 2 | 0 | 2021-09-24 12:24:59 | 2021-09-24 14:28:00 |
+--------------------+-----------------------+----------------------+--------+---------------------+---------------------+
1 row in set (0.05 sec)
mysql> show scaling status 648136988280487936;
+------+-------------+----------+-------------------------------+--------------------------+
| item | data_source | status | inventory_finished_percentage | incremental_idle_minutes |
+------+-------------+----------+-------------------------------+--------------------------+
| 0 | ds_1 | FINISHED | 100 | 333 |
| 1 | ds_0 | FINISHED | 100 | 333 |
+------+-------------+----------+-------------------------------+--------------------------+
2 rows in set (0.02 sec)
mysql> checkout scaling 648136988280487936;
Query OK, 0 rows affected (0.00 sec)
```
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tristaZero merged pull request #12686: Add scaling distSQL:`CHECKOUT SCALING jobId`.
Posted by GitBox <gi...@apache.org>.
tristaZero merged pull request #12686:
URL: https://github.com/apache/shardingsphere/pull/12686
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org