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/08/05 06:32:50 UTC

[GitHub] [shardingsphere] strongduanmu edited a comment on issue #10996: Support encrypt route when config multiple data sources

strongduanmu edited a comment on issue #10996:
URL: https://github.com/apache/shardingsphere/issues/10996#issuecomment-888858430


   In order to solve the single table routing in the multi-data source aggregation scenario, the order of the rule needs to be adjusted. The latest order is as follows.
   
   <div class="okr-block-clipboard" data-okr="%7B%22okrDelta%22%3A%5B%7B%22lineType%22%3A%22unsupport%22%2C%22lineOptions%22%3A%7B%7D%2C%22lineContent%22%3A%5B%5D%7D%5D%2C%22businessKey%22%3A%22lark-doc%22%7D"></div><div data-zone-id="0" data-line-index="0" style="white-space: pre;">
   
   Type | Order | Use
   -- | -- | --
   ShardingRule | ShardingOrder——-10 | ShardingTableMetaDataBuilder ShardingSQLRewriteContextDecorator ShardingResultMergerEngine ShardingSQLRouter
   SingleTableRule | SingleTableOrder——0 | SingleTableSQLRouter
   EncryptRule | EncryptOrder——10 | EncryptTableMetaDataBuilder EncryptSQLRewriteContextDecorator EncryptResultDecoratorEngine
   ReadwriteSplittingRule | ReadwriteSplittingOrder——20 | ReadwriteSplittingSQLRouter
   DatabaseDiscoveryRule | DatabaseDiscoveryOrder——30 | DatabaseDiscoverySQLRouter
   ShadowRule | ShadowOrder——40 | ShadowSQLRewriteContextDecorator ShadowSQLRouter
   
   </div>
   
   As shown in the figure below, the kernel execution will be executed in ascending order of order.
   
   ![image](https://user-images.githubusercontent.com/10829171/127446898-880d1238-a53c-463d-a430-ea20187e4374.png)
   
   When the rule is initialized, the data source aggregation rule needs to be loaded in reverse order to ensure that it can be routed from the logical data source to the real data source during routing.
   
   ![image](https://user-images.githubusercontent.com/10829171/127447060-e863b193-840c-464b-b842-1cedbef3fe33.png)
   


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