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 2020/12/23 03:00:58 UTC

[GitHub] [shardingsphere] tristaZero opened a new issue #8725: Support `ALTER REPLICA_QUERY RULE`

tristaZero opened a new issue #8725:
URL: https://github.com/apache/shardingsphere/issues/8725


   // Create rule
   CREATE REPLICA_QUERY RULE (
   logic_ds_a (primary=primary_ds_a, repilca=repilca_ds_a_0, repilca_ds_a_1) RANDOM(xxx=xxx),
   logic_ds_b (primary=primary_ds_b, repilca=repilca_ds_b_0, repilca_ds_b_1 ROUNDROBIN(xxx=xxx),
   )
   
   
   Hi,
   
   This issue is a consequent one from #8615. We will provide more DistSQL(Distributed SQL) to help users `create`, `alter` and `delete` configuration rules with SQL than files. As you know, the standard interaction way with a DB is SQL.
   
   ```sql
   
   // Multi-rule modification with all properties
   ALTER REPLICA_QUERY RULE (
   logic_ds_a (primary=primary_new_ds_a, repilca=repilca_ds_a_0) RANDOM(xxx=xxx),
   logic_ds_b (primary=primary_new_ds_b, repilca=repilca_ds_b_0 ROUNDROBIN(xxx=xxx)
   )
   
   
   // Multi-rule modification with partial properties
   ALTER REPLICA_QUERY RULE (
   logic_ds_a (primary=primary_new_ds_a, repilca=repilca_ds_a_0),
   logic_ds_b (primary=primary_new_ds_b, repilca=repilca_ds_b_0 ROUNDROBIN(xxx=xxx)
   )
   
   
   // One-rule modification
   ALTER REPLICA_QUERY RULE (
   logic_ds_a (primary=primary_new_ds_a, repilca=repilca_ds_a_0)
   )
   ```


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] terrymanu closed issue #8725: Support `ALTER REPLICA_QUERY RULE`

Posted by GitBox <gi...@apache.org>.

terrymanu closed issue #8725:
URL: https://github.com/apache/shardingsphere/issues/8725


   


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org