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 2022/04/16 10:12:40 UTC

[GitHub] [shardingsphere] sandynz opened a new pull request, #16878: Add DistSQL manual mode whole process example

sandynz opened a new pull request, #16878:
URL: https://github.com/apache/shardingsphere/pull/16878

   
   Changes proposed in this pull request:
   - Add DistSQL manual mode whole process example
   


-- 
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 a diff in pull request #16878: Add DistSQL manual mode whole process example

Posted by GitBox <gi...@apache.org>.
sandynz commented on code in PR #16878:
URL: https://github.com/apache/shardingsphere/pull/16878#discussion_r851623146


##########
docs/document/content/user-manual/shardingsphere-scaling/usage.cn.md:
##########
@@ -289,3 +284,225 @@ mysql> preview select count(1) from t_order;
 ### DistSQL 手动模式接口
 
 数据校验、切换配置等操作可以手动执行。详情请参见：[RAL #弹性伸缩](/cn/user-manual/shardingsphere-proxy/distsql/syntax/ral/#%E5%BC%B9%E6%80%A7%E4%BC%B8%E7%BC%A9)。
+
+### DistSQL 手动模式完整流程示例
+
+本示例演示从已有 MySQL 数据库迁移到 proxy。
+
+除了明确说明在 MySQL 执行的 SQL，其他都是在 proxy 执行。
+
+#### 新建源端库
+
+已有数据不需要这个步骤。这里是模拟一个源端库用于测试。
+
+在 MySQL 执行 SQL：
+```sql
+drop database if exists scaling_ds_0;

Review Comment:
   All SQL keywords added this time are changed to uppercase.



-- 
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] totalo commented on a diff in pull request #16878: Add DistSQL manual mode whole process example

Posted by GitBox <gi...@apache.org>.
totalo commented on code in PR #16878:
URL: https://github.com/apache/shardingsphere/pull/16878#discussion_r851613397


##########
docs/document/content/user-manual/shardingsphere-scaling/usage.cn.md:
##########
@@ -289,3 +284,225 @@ mysql> preview select count(1) from t_order;
 ### DistSQL 手动模式接口
 
 数据校验、切换配置等操作可以手动执行。详情请参见：[RAL #弹性伸缩](/cn/user-manual/shardingsphere-proxy/distsql/syntax/ral/#%E5%BC%B9%E6%80%A7%E4%BC%B8%E7%BC%A9)。
+
+### DistSQL 手动模式完整流程示例
+
+本示例演示从已有 MySQL 数据库迁移到 proxy。
+
+除了明确说明在 MySQL 执行的 SQL，其他都是在 proxy 执行。
+
+#### 新建源端库
+
+已有数据不需要这个步骤。这里是模拟一个源端库用于测试。
+
+在 MySQL 执行 SQL：
+```sql
+drop database if exists scaling_ds_0;

Review Comment:
   Do keywords need to be capitalized?



-- 
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] totalo merged pull request #16878: Add DistSQL manual mode whole process example

Posted by GitBox <gi...@apache.org>.
totalo merged PR #16878:
URL: https://github.com/apache/shardingsphere/pull/16878


-- 
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