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: [email protected]
