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/03/04 09:33:52 UTC

[GitHub] [shardingsphere] tuohai666 opened a new issue #9590: Refactor the features of shardingsphere-replica-query and shardingsphere-ha

tuohai666 opened a new issue #9590:
URL: https://github.com/apache/shardingsphere/issues/9590


   The concept **Source to Replica Replication** (called Primary Secondaries or Master Slave previously) and MGR (MySQL Group Replication) relate to the function **Replication**.
   
   The shardingsphere-replica-query module mainly splits read and write queries and routes to different data sources. There's no replication function in this module. So the name shardingsphere-replica-query or shardingsphere-master-slave (previous) is not appropriate for further use. It's suggested to rename the module to **shardingsphere-read-write-splitting**.
   
   For the shardingsphere-ha module, it's function is check and interoperate with the database replication process.  So it's better to rename this module to **shardingsphere-replication**.


----------------------------------------------------------------
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 #9590: Refactor the features of shardingsphere-replica-query and shardingsphere-ha

Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #9590:
URL: https://github.com/apache/shardingsphere/issues/9590


   


-- 
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] tristaZero commented on issue #9590: Refactor the features of shardingsphere-replica-query and shardingsphere-ha

Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #9590:
URL: https://github.com/apache/shardingsphere/issues/9590#issuecomment-796625307


   Hi, here is another solution for consideration
   
   ```sql
   rules:
     - !HA # Need new name, todo
       dataSources:
         pr_ds:
           name: pr_ds # removed
           dataSourceNames:
             - ds_0
             - ds_1
             - ds_2
           replicaQuery: false # removed
           haTypeName: mgr
       haTypes:
         mgr:
           type: MGR
           props:
             groupName: 92504d5b-6dec-11e8-91ea-246e9612aaf1
             zkServerLists: 'localhost:2181'
             keepAliveCron: '0/5 * * * * ?'
   
     - !REPLICA_QUERY # Need new name, todo
       dataSources:
         ds_0:
           primaryDataSourceName: primary_ds_0
           replicaDataSourceNames:
             - primary_ds_0_replica_0
             - primary_ds_0_replica_1
           loadBalancerName: roundRobin
         ds_1: # new
           autoAwareDataSourceName: pr_ds
           loadBalancerName: random
       loadBalancers:
         roundRobin:
           type: ROUND_ROBIN
         random:
           type: RANDOM
   ```
   
   Notes,
   - `HA` and `REPLICA_QUERY` need new names
   - `ds_1` is an example for using `HA` and `REPLICA_QUERY` togather
   - Remove `name` and `replicaQuery` of `HA` rule


----------------------------------------------------------------
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] tristaZero edited a comment on issue #9590: Refactor the features of shardingsphere-replica-query and shardingsphere-ha

Posted by GitBox <gi...@apache.org>.
tristaZero edited a comment on issue #9590:
URL: https://github.com/apache/shardingsphere/issues/9590#issuecomment-796625307


   Hi, here is another solution for consideration
   
   ```sql
   rules:
     - !HA # Need new name, todo
       dataSources:
         pr_ds:
           name: pr_ds # removed
           dataSourceNames:
             - ds_0
             - ds_1
             - ds_2
           replicaQuery: false # removed
           haTypeName: mgr
       haTypes:
         mgr:
           type: MGR
           props:
             groupName: 92504d5b-6dec-11e8-91ea-246e9612aaf1
             zkServerLists: 'localhost:2181'
             keepAliveCron: '0/5 * * * * ?'
   
     - !REPLICA_QUERY # Need new name, todo
       dataSources:
         read_write_0:
           primaryDataSourceName: primary_ds_0
           replicaDataSourceNames:
             - primary_ds_0_replica_0
             - primary_ds_0_replica_1
           loadBalancerName: roundRobin
         read_write_1: # new
           autoAwareDataSourceName: pr_ds
           loadBalancerName: random
       loadBalancers:
         roundRobin:
           type: ROUND_ROBIN
         random:
           type: RANDOM
   ```
   
   Notes,
   - `HA` and `REPLICA_QUERY` need new names
   - `ds_1` is an example for using `HA` and `REPLICA_QUERY` togather
   - Remove `name` and `replicaQuery` of `HA` rule


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